Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
Repo info
    Ahmad K. Bawaneh

    Have a quick question on chart loading time improvements with redis caching activated. I have the following caching parameters setup in my superset_config.py file

        'CACHE_TYPE': 'redis',
        'CACHE_DEFAULT_TIMEOUT': 60 * 60 * 24,  # 1 day default (in secs)
        'CACHE_KEY_PREFIX': 'superset_results',
        'CACHE_REDIS_URL': 'redis://localhost:6379/0',
        'CACHE_TYPE': 'redis',
        'CACHE_DEFAULT_TIMEOUT': 60 * 60 * 24,  # 1 day default (in secs)
        'CACHE_KEY_PREFIX': 'superset_results',
        'CACHE_REDIS_URL': 'redis://localhost:6379/0',

    And tested this against the World bank's data dashboard. With an without caching, I am getting about 250 ~ 700 ms load time from watching the network response times in firefox for chart queries. Curious to see what performance numbers are others are seeing with caching on vs off

    I'm running a redis + postgres on a metal server and superset in docker.

    Hi, is there any Pros and Cons of Apache Superset Single Tenant vs Multi tenant?
    need help with filter box : it seems it does not generate sql
    Andre Violante
    Hey is there a slack channel for Superset still?
    I want to share my thread on Twitter about how to build an Apache Superset dashbord with GSheet integration. This is an easy entry for data analysts or new users in Superset. It only requires Docker + Bash + SQL. Happy dashboarding! https://twitter.com/AldoEscobarLVP/status/1399708801163530241
    rahul ranjan
    hi All, can we embed apache superset dashboard in other app like power bi is embeded in in node js, https://www.youtube.com/watch?v=A5KFY5Jh1Uc
    rahul ranjan
    Hi everyone, can we embed superset in another app like we can embed microsoft power bi in react js --https://www.youtube.com/watch?v=A5KFY5Jh1Uc. Let me know any one has an idea.
    Hi all. having a challenge with filters on annotations. We need assistance to get the annotations working due to this issue. apache/superset#13451 . Any developers keen to contract with us to sort this out?
    Rajendra Engla
    Hi All, I have to try to connect our Superset instance started via docker-compose to our AWS Redshift cluster. I have followed the steps mentioned in https://superset.apache.org/docs/databases/installing-database-drivers but the following error "ERROR: Could not load database driver: RedshiftEngineSpec" even when the system logs show that the required driver was installed
    rahul ranjan
    2 replies
    Hi All, when i am trying to embed dashboard in iframe getting below error, can any one suggest on this.

    Hi @All
    Export to csv is not working for superset-iframe integration-

    Steps to reproduce-

    1. Open the superset dashboard.
    2. Click on "Export CSV"
    3. Blank page is opening in new tab.

    Actual results-
    Blank page is opening in new tab as in the screenshot

    Expected results-
    CSV gets downloaded


    1 reply
    Kamil Biela
    hello everyone, anyone had problem configuring google oauth? I'm using config that should be ok, but I get redirect loops
    superset redirects to google, google redirects back to superset and so on
    I dont see anything in logs
    kind of going crazy here :D
    Hello Everyone, I am running superset on OpenShift , I have installed it using Helm Chart
    I am using Trino as backend database query engine, When I am running complex query , It takes around 50 seconds to complete but my sqllab showing 504 gateway time-out in exactly 30 seconds, I tried providing environment variable GUNICORN_TIMEOUT to 300 but its not working , Please help if anyone already came across such and resolved?
    Kushagra Mangal
    Getting Error
    Associated data exists, please delete them first
    When trying to delete users. Anyone has any idea on how to fix this?
    Hello, i am new with superset
    i am struggling to know the database used by superset to store its metadata (users, databases,...)
    i am using docker compose to launch superset
    where the connection parameters to the database are set?
    to see if i can query it easily
    and if also i can plugin it with another postgres database
    thank you for your precious help 🙂
    Sujith Kumar S
    Hi, not able to use from_dttm in apache superset, its not replacing the filter values.
    Sujith Kumar S
    Hello Everyone, with clause in not working against MSSQL from superset. Any options ?
    Hey guys, im currently trying to configure superset to use my custom Auhtorization Service (OAUTH2). My Service returns an access Token successfully but superset disregards the token I think, and starts the auhtorization process over and over again. Im stuck in a redirect loop. Do you have any Idea, why this is hapeninng?
    ahh figured it out - to impl custom oauth provider in superset you have to impl. userinfo getter in superset SecurityManager.
    Raj Nishtala
    Hello Everyone, the latest apache/superset docker image throw the following internal server error when I try to login, any thoughts on why this is happening? the traceback is below
    docker-files-superset-1 | Traceback (most recent call last): docker-files-superset-1 | File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request docker-files-superset-1 | rv = self.dispatch_request() docker-files-superset-1 | File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request docker-files-superset-1 | return self.view_functions[rule.endpoint](**req.view_args) docker-files-superset-1 | File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/views.py", line 517, in login docker-files-superset-1 | user = self.appbuilder.sm.auth_user_db( docker-files-superset-1 | File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/manager.py", line 869, in auth_user_db docker-files-superset-1 | self.noop_user_update(first_user) docker-files-superset-1 | File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/sqla/manager.py", line 244, in noop_user_update docker-files-superset-1 | .where(self.user_model.id == user.id) docker-files-superset-1 | AttributeError: 'NoneType' object has no attribute 'id' docker-files-superset-1 | - - [31/Jan/2022:10:37:56 +0000] "POST /login/ HTTP/1.1" 500
    4 replies
    Ronald Munjoma
    most of the communication is now on slack
    Hi All,
    Can someone help me how to create Dashboard and Charts through API only, without using the GUI to create it.
    salah alhashmi
    I want good programmer is ready to be moderator for volder npm package.
    the requirement:
    • good javascript developer.
    • already have knowledge about volder files, and code structure.
    • being good in project management, CI, testing and conversation
      send me a message for more information
    Jonathan Churque

    Hi there i m trying tu use {{ 'from_dttm' }}
    inside my metric custom sql like so :

    • (select count(*) FROM prod.inscription_state where root_status >= 0 and islive = false and root_date > {{ from_dttm}})

    is it possible ? cause right now i have an Error: syntax error at or near "{" LINE 7: and root_date > {{ 'from_dttm'}}) AS "(select count(*) ... ^

    I have enable Jinja template in my k8s helm values :

    A dictionary of overrides to append at the end of superset_config.py - the name does not matter

    WARNING: the order is not guaranteed


    but no luck for me :(

    salah alhashmi
    Hey, I've been working on this schema builder project, Volder for a while. Would you be interested in using it or contributing to it? It would be great if I can get some feedback on this project, or just add a star
    nikil katturi
    Hi all, we have a use case on superset for caching the dashboard. I know we can do with calery but we also wanted to cache the filters too
    Hi All, ERROR: (builtins.NoneType) None
    (Background on this error at: http://sqlalche.me/e/13/dbapi)
    Can anyone help with this?
    Hello Everyone,
    I'm new around here and SuperSet :)
    Docker and SuperSet installations are ok, but I cannot login via localhost:8088.
    Everything Inst. I did it through the guide but I don't know why. Has anyone had similar problems before?
    Joe Bordes
    if you execute docker ps do you see the 8088 port mapped to your server in the ports column?
    [root@ereteam ~]# docker ps
    1991ec6e9bd3 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (unhealthy) 8088/tcp superset_worker
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (healthy)>8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" 26 minutes ago Up 26 minutes 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" 26 minutes ago Up 26 minutes 6379/tcp superset_cache
    "unhealthy " I couldn't understand the part.