Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
Repo info
    Hello everyone. I was trying to connect an Athena database to superset. I have installed superset recently using the building it from source using docker-compose. When I am trying to connect athena it is showing that Pyathena driver not found. I have tried to change the dockerfile and added instructions to include pyathena and built it again but the issue still persists. Any ideas how to fix that or what I am doing wrong?
    Abhay Soningra
    hey everyone
    I am new to apache superset
    I am trying to make a pie chart using one table and values from different colums of a single row
    Is that possible ? I tried but to no luck
    Abhay Soningra
    Though a pie chart using aggregate functions for one column worked fine
    Chanh Le
    do superset have any plugin to format sql query?
    Aditya Verma
    sqlalchemy.orm.exc.NoResultFound: No row was found for one()
    I want to use emails in superset but I am unable to do so, can you please suggest
    EMAIL_NOTIFICATIONS = True # all the emails are sent using dryrun
    SMTP_HOST = "smtp-mail.outlook.com"
    SMTP_SSL = False
    SMTP_USER = "superset"
    SMTP_PORT = 587
    SMTP_MAIL_FROM = "someemail@outlook.com"
    Aditya Verma
    class CeleryConfig(object): # pylint: disable=too-few-public-methods
    #BROKER_URL = "sqla+sqlite:///celerydb.sqlite"
    BROKER_URL = "redis://localhost:6379/0"
    CELERY_IMPORTS = ("superset.sql_lab", "superset.tasks")
    CELERY_RESULT_BACKEND = "redis://localhost:6379/0"
    #CELERY_RESULT_BACKEND = "db+sqlite:///celery_results.sqlite"
        "sql_lab.get_sql_results": {"rate_limit": "100/s"},
        "email_reports.send": {
            "rate_limit": "1/s",
            "time_limit": 120,
            "soft_time_limit": 150,
            "ignore_result": True,
        "email_reports.schedule_hourly": {
            "task": "email_reports.schedule_hourly",
            "schedule": crontab(minute=55, hour="*"),
    EMAIL_NOTIFICATIONS = True # all the emails are sent using dryrun
    SMTP_HOST = "smtp-mail.outlook.com"
    SMTP_SSL = False
    SMTP_USER = "superset"
    SMTP_PORT = 587
    SMTP_MAIL_FROM = "**@outlook.com"
    I am running celery in two diff windows
    celery beat --app=superset.tasks.celery_app:app
    celery worker --app=superset.tasks.celery_app:app --pool=prefork -O fair -c 4
    Please suggest what can I do ?
    Aditya Verma
    I am getting this error
    raise orm_exc.NoResultFound("No row was found for one()")
    sqlalchemy.orm.exc.NoResultFound: No row was found for one()
    Mohamed Abdultawab
    Hi There I'm getting this error in superset dashboards, although I'm already the administrator:
    You don't have the necessary permissions to load dashboards. Please contact your administrator.
    I'm using the apache superset docker image
    I've tried alot of things including creating new database for testing and it worked fine.
    but I can't use the db I've been using for a while now
    What should I do
    Joe Bordes
    Have you tried this: apache/superset#9747 ?
    Mohamed Abdultawab
    I get the following error:
    qlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column dbs.perm does not exis
    and when I try superset db upgrade I get the following:
    sqlalchemy.exc.InternalError: (psycopg2.InternalError) cannot drop table report_schedule because other objects depend on it DETAIL: constraint report_execution_log_report_schedule_id_fkey on table report_execution_log depends on table report_schedule constraint report_recipient_report_schedule_id_fkey on table report_recipient depends on table report_schedule constraint report_schedule_user_report_schedule_id_fkey on table report_schedule_user depends on table report_schedule HINT: Use DROP ... CASCADE to drop the dependent objects too.
    Which is not what I need
    I need to preserve my database
    Joe Bordes
    over my head. sorry
    Mohamed Abdultawab
    Hi! I have superset connected to big query, set up on dockers, on a GCP instance. How do I take backups of the queries, visualisations and dashboards I have made?
    The Mentalist
    Hi, Can anyone let me know where all can we make use of Python in Apache superset and how?
    Billy Odera
    how can i format the numbers for my superset dashboard? instead of 10000 i have 10,000
    Bastien Vial-Collet
    Hi all. I have the same question as @billy-odera . When displaying raw data in a table chart, I can't find a way to format the numbers except by creating metrics. This is not what I want as I don't want to agregate.
    Thanks in advance.
    I've just installed superset from docker. I'm trying to user current user id in a query without success: select '{{current_user_id()}}'what am i doing wrong? The result I get is '{{current_user_id()}}' without value substitution
    Hi, i just installed superset on my linux server using docker, but when i try to access it, i got error like this "sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "db" to address: Name or service not known",
    i already search throughout internet but no one that can solve my problem
    this error dissapear when i re-start my docker-compose, but after couple of times that error come again
    Riska Tri Handayani
    hi, i make a pie chart with datetime data but a value is 14985701929 not a date time. what should i do ??
    @rajeshchy Have you got any solution for the problem? I need this too.
    Michael Rea
    @billy-odera @vialcollet we have the the same need. I think there's a feature request logged for this, but there's no way to currently do it without creating a metric.
    Yaroslav Pankovych
    hey, i have a weird problem with superset, being an admin, I cannot access the Users list, access denied, what could be the reason for that?
    but after superset init issue disappears
    Hi guys. My table cannot be loaded more than 10k rows. How can I increase the memory in superset? I already switched to a machine with 2 CPU and 4 GB RAM to 8 CPU and 32GB RAM.
    Alex Riedler
    I feel like I am missing something, I have added sqlalchemy-redshift package to the docker/requirements-local.txt but I am still getting ERROR: Could not load database driver: RedshiftEngineSpec when testing connection ; any help on how to debug this would be awesome :)
    1 reply
    Bruce Kim
    Hi, I'm using Superset with Postgres and trying to run "SET TIME ZONE" to set the user's timezone prior to the query. I've tried appending in the SQL_QUERY_MUTATOR in config.py but SQL Alchemy rejects it as an invalid query. Any suggestions on how to do this?
    Hemanth Kumar
    Name email_reports.send
    Traceback (most recent call last):
    File "/root/venv/lib/python3.6/site-packages/celery/app/trace.py", line 412, in trace_task
    R = retval = fun(args, **kwargs)
    File "/root/venv/lib/python3.6/site-packages/superset/app.py", line 116, in call
    return task_base.call(self,
    args, kwargs)
    File "/root/venv/lib/python3.6/site-packages/celery/app/trace.py", line 704, in protected_call
    return self.run(*args,
    File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 527, in schedule_email_report
    File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 454, in deliver_slice
    report_content = _get_slice_visualization(slc, delivery_type, session)
    File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 401, in _get_slice_visualization
    driver = create_webdriver(session)
    File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 205, in create_webdriver
    File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 214, in get_reports_user
    == func.lower(config["EMAIL_REPORTS_USER"])
    File "/root/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3500, in one
    raise orm_exc.NoResultFound("No row was found for one()")
    sqlalchemy.orm.exc.NoResultFound: No row was found for one()
    Riska Tri Handayani
    HI, does anyone know about multiplier and javascript data interceptor in deck.gl scatterplot superset?