Achintyarai22 commented on issue #22037: URL: https://github.com/apache/superset/issues/22037#issuecomment-2519261328
I am facing the same issue i have table with 1 crore rows. Db : postgres query : select * from my_table even with limit = 1000000 then also browser stuck  superset_config.py bellow # Licensed to the Apache Software Foundation (ASF) under one # or more contributor license agreements. See the NOTICE file # distributed with this work for additional information # regarding copyright ownership. The ASF licenses this file # to you under the Apache License, Version 2.0 (the # "License"); you may not use this file except in compliance # with the License. You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, # software distributed under the License is distributed on an # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY # KIND, either express or implied. See the License for the # specific language governing permissions and limitations # under the License. # # This file is included in the final Docker image and SHOULD be overridden when # deploying the image to prod. Settings configured here are intended for use in local # development environments. Also note that superset_config_docker.py is imported # as a final step as a means to override "defaults" configured here # import logging import os from celery.schedules import crontab from flask_caching.backends.filesystemcache import FileSystemCache logger = logging.getLogger() DATABASE_DIALECT = os.getenv("DATABASE_DIALECT") DATABASE_USER = os.getenv("DATABASE_USER") DATABASE_PASSWORD = os.getenv("DATABASE_PASSWORD") DATABASE_HOST = os.getenv("DATABASE_HOST") DATABASE_PORT = os.getenv("DATABASE_PORT") DATABASE_DB = os.getenv("DATABASE_DB") EXAMPLES_USER = os.getenv("EXAMPLES_USER") EXAMPLES_PASSWORD = os.getenv("EXAMPLES_PASSWORD") EXAMPLES_HOST = os.getenv("EXAMPLES_HOST") EXAMPLES_PORT = os.getenv("EXAMPLES_PORT") EXAMPLES_DB = os.getenv("EXAMPLES_DB") # The SQLAlchemy connection string. SQLALCHEMY_DATABASE_URI = ( f"{DATABASE_DIALECT}://" f"{DATABASE_USER}:{DATABASE_PASSWORD}@" f"{DATABASE_HOST}:{DATABASE_PORT}/{DATABASE_DB}" ) SQLALCHEMY_EXAMPLES_URI = ( f"{DATABASE_DIALECT}://" f"{EXAMPLES_USER}:{EXAMPLES_PASSWORD}@" f"{EXAMPLES_HOST}:{EXAMPLES_PORT}/{EXAMPLES_DB}" ) REDIS_HOST = os.getenv("REDIS_HOST", "redis") REDIS_PORT = os.getenv("REDIS_PORT", "6379") REDIS_CELERY_DB = os.getenv("REDIS_CELERY_DB", "0") REDIS_RESULTS_DB = os.getenv("REDIS_RESULTS_DB", "1") RESULTS_BACKEND = FileSystemCache("/app/superset_home/sqllab") CACHE_CONFIG = { "CACHE_TYPE": "RedisCache", "CACHE_DEFAULT_TIMEOUT": 300, "CACHE_KEY_PREFIX": "superset_", "CACHE_REDIS_HOST": REDIS_HOST, "CACHE_REDIS_PORT": REDIS_PORT, "CACHE_REDIS_DB": REDIS_RESULTS_DB, } DATA_CACHE_CONFIG = CACHE_CONFIG QUERY_SEARCH_CACHE_CONFIG = { 'CACHE_TYPE': 'RedisCache', 'CACHE_DEFAULT_TIMEOUT': 5000, # 5 minutes 'CACHE_KEY_PREFIX': 'superset_query_cache_', 'CACHE_REDIS_HOST': REDIS_HOST, 'CACHE_REDIS_PORT': 6379, "CACHE_REDIS_DB": REDIS_RESULTS_DB, 'CACHE_REDIS_URL': 'redis://superset-redis-master:6379' } class CeleryConfig: broker_url = f"redis://{REDIS_HOST}:{REDIS_PORT}/{REDIS_CELERY_DB}" imports = ( "superset.sql_lab", "superset.tasks.scheduler", "superset.tasks.thumbnails", "superset.tasks.cache", ) result_backend = f"redis://{REDIS_HOST}:{REDIS_PORT}/{REDIS_RESULTS_DB}" worker_prefetch_multiplier = 10 task_acks_late = True beat_schedule = { "reports.scheduler": { "task": "reports.scheduler", "schedule": crontab(minute="*", hour="*"), }, "reports.prune_log": { "task": "reports.prune_log", "schedule": crontab(minute=10, hour=0), }, } CELERY_CONFIG = CeleryConfig # FEATURE_FLAGS = {"ALERT_REPORTS": True,"EMBEDDED_SUPERSET": True} ALERT_REPORTS_NOTIFICATION_DRY_RUN = True WEBDRIVER_BASEURL = "http://superset:8088/"; # When using docker compose baseurl should be http://superset_app:8088/ # The base URL for the email report hyperlinks. WEBDRIVER_BASEURL_USER_FRIENDLY = WEBDRIVER_BASEURL SQLLAB_CTAS_NO_LIMIT = True # # Optionally import superset_config_docker.py (which will have been included on # the PYTHONPATH) in order to allow for local settings to be overridden # #Feature Flag FEATURE_FLAGS = { "EMBEDDED_SUPERSET": True, "EMBEDDABLE_CHARTS": True, "ALERT_REPORTS": True } # CORS Enabling ENABLE_CORS = True CORS_OPTIONS = { "supports_credentials": True, "allow_headers": "*", "expose_headers": "*", 'allow_headers': ['*'], "resources": "*", "origins": ["*","http://localhost:4200","http://localhost:3000","http://localhost:3000/";] } # Dashboard embedding GUEST_ROLE_NAME = "Gamma" ENABLE_PROXY_FIX = True GUEST_TOKEN_JWT_SECRET = "gfhgjkll" GUEST_TOKEN_JWT_ALGO = "HS256" GUEST_TOKEN_HEADER_NAME = "X-GuestToken" GUEST_TOKEN_JWT_EXP_SECONDS = 300 # 5 minutes FAB_API_SWAGGER_UI = True WTF_CSRF_ENABLED = False CSRF_ENABLED = True HTTP_HEADERS={"X-Frame-Options":"ALLOWALL"} TALISMAN = False TALISMAN_ENABLED = False FAB_ADD_SECURITY_API = True SQL_MAX_ROW = 10000000 DISPLAY_MAX_ROW = 10000000 APP_NAME = "Prescience" SQLLAB_ASYNC_TIME_LIMIT_SEC = 60 * 60 * 6 # 6 hours SUPERSET_WEBSERVER_TIMEOUT = 3600 SQLLAB_ASYNC_MODE = True ENABLE_ASYNC_QUERY = True DEFAULT_SQLLAB_LIMIT = 1000000000 QUERY_SEARCH_LIMIT = 1000000000 SQLLAB_QUERY_CACHE_ENABLED = True VIZ_ROW_LIMIT = 50000000 QUERY_CACHE_ENABLED = True # THEME_OVERRIDES = { # "colors": { # "text": { # "label": '#879399', # "help": '#737373' # }, # "primary": { # "base": 'red', # }, # "secondary": { # "base": 'green', # }, # "grayscale": { # "base": 'orange', # }, # "error": { # "base": 'Pink' # } # }, # "typography": { # "families": { # "sansSerif": 'Inter', # "serif": 'Georgia', # "monospace": 'Fira Code', # }, # "weights": { # "light": 200, # "normal": 400, # "medium": 500, # "bold": 600 # } # } # } # THEME_OVERRIDES = { # "borderRadius": 16, # "colors": { # "text": { # "label": '#879399', # "help": '#737373' # }, # "primary": { # "base": 'red', # }, # "secondary": { # "base": 'green', # }, # "grayscale": { # # "base": '#FFFF00', # Bright yellow # # "dark1": '#FFEE58', # Light yellow # # "dark2": '#FFF59D', # Pale yellow # # "light1": '#FFF176', # Medium yellow # # "light2": '#FFEB3B', # Vibrant yellow # # "light3": '#FDD835', # Golden yellow # # "light4": '#FBC02D', # Deep yellow # "light5": '#CFF2FF', # Dark golden yellow # }, # "error": { # "base": 'Pink' # } # }, # "typography": { # "families": { # "sansSerif": 'Inter', # "serif": 'Georgia', # "monospace": 'Fira Code', # }, # "weights": { # "light": 200, # "normal": 400, # "medium": 500, # "bold": 600 # } # } # } # CUSTOM_CSS="./custom_styles.css" # APP_ICON="./logo180.png" APP_ICON = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAaUAAAB4CAMAAABl2x3ZAAAAulBMVEX///8AAAD8/PxRUVHc3Nx1dXWPj4+pqakMDAy+vr739/fZ2dnp6enk5OSLi4s/Pz9ZWVn4miXw8PAWFhaxsbH7xoX/+fJubm7+7d795cv6vnX4myn4lAX+6dP5qEb4ojT94sJ+fn4mJibLy8tFRUUcHBz6uG+Xl5dlZWXFxcVdXV17e3sqKipLS0s0NDQzMzP+9Of8ypD6smb7z575qkr81Kn6vID5slv4mRT6wIj7yJT7vXr82bH4oTFk4WNKAAAKBUlEQVR4nO2cDXeaPBTHEUSUNxWttHvadYgObNW2z7rWPt2+/9d6SIKQhAQwtXOec39n56wbkLd/Xm7uTappAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD8Sb79+zY7dRmAJq7Hu6dTlwFoYLYbjy/0U5cCaODH8/ebU5cBaEK/fDx1EQAAAAAAAM6Bn18kXOTm1OPF096wurz4wW399alBMUp7sV73QvZKaHmVMnipIWbjM+85C8NI2u+XnMS8yxNK7CKv0NhE7v5fgSnJ2SjfsR2bT5litTE2lqxMcWKO8vSssgTS2ibSXF6ux0J2t5f4+ez9evdCtJm97vitv97rcDxMA/oF2+df6HRGMVdtp/pOzqLynlHXZCVBfL+k0gmLQjnbLI2io3hDac7dIqnUr8kzyd6NRCoFsTmh0ouKNJy5LM97aS5v43+EjL8SlR5fx7vvZDBd3o53X9iv9aSaVxpTL4hU6nR8l0nFWYpeQhjMe3b2P9s2KumrkKt/qVKmy6hQyd3Ict6UKoWdRJ6phapTVUkfpFyVS5XWh6v0ci3hd77L/7X75ycpxexpd/uNK0xlLGUMB+ULYpU6ITPttR1LWr/T6TvSqhS4PV52U6KSt5XlPKRVq pFJrJLn97n0qLHEPypbRVqjx0sZ+RI0K37Kfnzky+N2KZwp6cLzsiWRSpPEK1+xyBwT0qPJ7srg1jDUP9mlSkTX2NfaivN03KLcrEq6J825aFWkUl8qk1AlJy/BxLScSgnktXW1P4RtotJtyqUXqTQVVKGn4jVdoS5QtT5YYtxAy7tY+JRVqQ0BrlIUiJ+KVFrh0TJPWwz7U5EsaQ0EKmkurra4EetxF8zsJYRMn+lK9vhglbR4w05ZDAKVSDdJVSr4x7DRUrXZdyORSmTNThXS1lGb9Ht1Mjl4Ru1JJw8FlfZpCrOtquQ8oLeT+r50crxsRlvuhRGqRHpbO5OaxUUr0ySST+BkerLkaauoRBq+74savqISLmJHuoX6W9CTfjmNi1XS0MxV/d8WkG69kc4mU9yPa5pISSW8y6Kt6ZKKSlb/HETKRkq2IUjz7i5RCdUtUkrcWeBZ3xc3dBe15n3dKFVTKTd57qujiVcJd6O6bbAalzfY0NYfb2QceiAENdW+ISQqxbW7g1qcEZbJGIjmH7TJ3tZqoKhSLlPV0uNUwtv8jUL69Vy9PmPn3Oztq4TXywOTbKmSivmA8Hy8Z12a3cojG3Vkq/ZrVZXySa8iE6cSNozqS6DC2278FXkZZu9if954fHuoSmitvauf8dDyYaoW2V4Rv85mwD9ZNVslyippMV4SeROCU2mANkrH353+Nx7jwXJElaxluamRqIR8FHIPcCNBgh2ZE94jEDX7JhRU2msgnPQ4lVAJegel3orZ0/sV/vvHdwnvB54ICVLkUckLLlbJRdWtTlgHEIdYpx4rk9G8W1bwPUz3r5MlMWRkYlWykW0j21B/BH3vr5NyYILTebaC79tKrNJ9VpeHjxU7sLBrmVkCkO903iC+gkrpfvoWjSZWJS8zw9dHtx0+ATx9F8awUCVUM3q75CY9MX7NnkqPkRGxpn1lKAJiNCwKrEq25UtytgopgrDYV2jOhpeJValNBEyptk dmhWJcy2LaEaikY0/fiKqpQ4fLGNj4Ep/Vkpt/4j4/H1Xh4ksLWc5MfKl04ZPtGuXTY1XCtmvDjlYlCvhBbJfGW5HNTCkLVskKqFemuJBbfgwoqKQNsu/mlKGHTDyzoSerqbQscvHu0NNicAlUCptUUogCfgzd2g5LtiS+1aesNxwFXJevPJDybJkVVh4Xq1fJjjqMPwCNpfRTxhLVF7pYpmLIHnMsKe9NGhBF1Ne0E0scq12whlgwtSRUdkQsq0x0ozQXFNalgTRnel1iRqxHnEV5PoevS/LafoZxiBColDLHiEQq9aNjWUFuNsGuywZ0t0ycWIiCjceplMtkEplYldxPsvF+XUh4arNNwipN1vM1Yr5+WJgOO96xSsv8MV5+hsnxaoGnPGroolWxoUNyKum63eS+rqikedS+iVVJRzNowwSQ5akf6jJ/ud6Nx4I/u9s2d1CwSn7g5VTHOrEeXPzUxbtCgSvc7UWRmq8fZU/FKVCXaFiCWZXQeTyzoddUVdI8HEPCSyDne/DFNaTppoYhDFXV8LKTOIa+tnEMYZXqXD2sJY6Msn7VF4lm84WSs99iVcJ+vIaAO3uGKPvXsGGOFKiUy4Tsc4Efb12/NK5arJ48b79vhfx+/gSVAuR0qK4KaNUfHUMl7BOv9w9yKi3o85FiRCpp7n5tOtwnHs9LZ3Rbbr5JuGrjGTpQJS3edgShVGWVdJ9dl3CbbWtb/Ugq5WuTaYviS4vaOVRFpY9xqEp4IZnzDlFllZCNt6QbEHflsH2sVl2l/HxDmrAqaV1Ugtpo8RmoRJqRG0zKKqH90oZp5ClyNtWd9TuaSpqLj4guO/y5h4louqA4A5Xw8srbqm1V4l/Bhjh7PI+cIaop0fFUykcTrxIRr6YE56CSjubzIdve7VRye3wMfjCnzpTlkFsUspOoR1Upt/T483ge9oLJD6icg0rEAc5+0kola8vHYbHbslJfDzfcpt3Z1o+ptB9N3NlWcrr WkIUjz0Il/MkDs0fBKjXsanWTcsvglPHRy2W1LbrDXCdXJPxRVcqnN/6cODk02BnFwhKgg3AHq7Q/6XV5JaHupJeCSsSGZawg5BMfDkRQGgTY9DUsDzWJHsTEQSjamnTzieghsqZ5OqXfqqrSgyXMmblzIVOJnHmv3rnIS7AVlQBF4BZTUZ7y7fXVv/lJr4tb8UGv2+cah56KSto0GzoTutp4VPQFdO7oqpPrJiM/sayeSUIgYlvKTfiwouyWGV7FhDlTXqQ6lfApj+r9JbfihS7XKWyGTkR5yl1LHzvppaSSjXqaQcdY+SoVMPElb38vqZ/Ho/qy8+A6CQKVSG+ZSW9sSuNLPNnaJLoLmB/uLIhYlYTIXZAfO+mF7wLWnWxCKvX5eD42IKiv5Cpt2A8jJoAmXZ8R3WhBRYBDRqXyXm23zb3akNs6c7ip8F6t5twPKT0olaQxT7lKsx8X5KTXzy/vQorL6iL0gWmadbECfZqGYaU1rewrqkjdu7u71BQQ8sPU8Y05ruRkGzaeII2tnh8RpkUbub5plrdWgp4oW0RSXpSzQjOq88i6/MX8gpW1L0A0KFfGSJJlbY3yzxVPejXFSnTbDgQTAhPX0QPXDXQhlS+9gZX4vjXl77m3hktVnC3zjkI8qLEELWt7xmTCn7oIAAAA5wH8JsQz4Nfz69WpywA08Pi6Gx96iwT406BfefUOv5T8b+fm+8uh1+YAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGjN/9n78dhogWE9AAAAAElFTkSuQmCC" FAVICONS = [{"href": "/static/assets/my_company_images/logo180.png"}] # Setting it to '/' would take the user to '/superset/welcome/' LOGO_TARGET_PATH = '/' # Specify tooltip that should appear when hovering over the App Icon/Logo LOGO_TOOLTIP = "Prescience" # Specify any text that should appear to the right of the logo try: import superset_config_docker from superset_config_docker import * # noqa logger.info( f"Loaded your Docker configuration at " f"[{superset_config_docker.__file__}]" ) except ImportError: logger.info("Using default Docker config...") -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
