airbnb/superset

madhavgoswami93

@madhavgoswami93

I want to pass parameters through url to be consumed by sqlquery and reflect on the dashboard. how can i achieve that?

jinleileiking

@jinleileiking

Hi, any link for the utc localtime solution?

1 reply

Aditya Rohilla

@aditya1994

Hey, any way of adding a reset button which cleans all filters from filter box?

Yauvaraj Rimal

@yrimal_gitlab

How do I configure Date filter on Filter box to show in date format and not in epoch?

Aviral Srivastava

@kebab-mai-haddi

I am unable to install Superset due to failing Postgres error: https://stackoverflow.com/questions/63798865/unable-to-start-apache-superset-due-to-failed-postgresdb-connection-using-docker

1 reply

Can someone help me with this? ^

Kames

@ekames4u_twitter

Hello All.. Did anyone set up terdata connection in superset.. I have installed teradata driver and aslo set up environment variables but getting error "Driver not found".. Any pointers for this help is appreciated?

appleyuchi

@appleyuchi

when I type superset load-examples I get (<urlopen error [Errno 101] Network is unreachable>)
could anyone tell me how to solve this? Thanks you for your help

Harikrishnan

@harichandran_twitter

Hi, I am newbie to superset. Can we able to export table/pivot charts into excel or pdf formats? kindly advise how to achieve this.

could anyone update on this?

Sandro Lucas

@osandrolucas

Hi. Can I create a new refresh frequency for dashboards?

shekhar-joshi

@shekhar-joshi

Hi guys,
new on apache-superset.
My question is to migrate all the data from sqllite3 to mysql/postgresql (Any SQL db).
How do I achieve it ??? Please help.. superset is getting slow day by day I need to move the data..

Really really in a need of some directions.. If anyone has done it already then help would be much appreciated

shekhar-joshi

@shekhar-joshi

Can anyone tell me..
why i'm not able to see table previews ?? M not able to see metedata which gives me preview when I select the table.. help would be really appreciated :eyes:

keerthanaturlapati

@keerthanaturlapati

Upon integrating superset with OAuth, the redirect uri is using http instead of https and hence throwing a Error 400: redirect_uri_mismatch. I also set PREFERRED_URL_SCHEME = 'https'. what else could I do here. Thanks !

PersonalFernandoKeuroglian

@PersonalFernandoKeuroglian

Hi Guys, i am new to Apache-Superset, i am creating a simple bar chart, but the x axis not approach to 100 in the graphic object(my max data is 88 for example) , is there any way that my X axis always approach and show 100?, THANKS A LOT, Fernando

Mohamed Nizar

@mohamednizar

I'm trying to schedule queries from superset , but I could not find sufficient resources to do this airflow. can any expert help me to do this ?

Matthias Leinweber

@lnnwvr_twitter

i am a fan of superset for quite a while, finally i got some time to evaluate it in a project. Actually i am looking for some detailed config examples to deploy it in k8s. The deprecated helm chart is quite limited esp. with detailed configuratution .. are there some examples avaiable? otherwise i would start from scratch..
additionally latest docker image seems broken with auth errrors, i was looking for the 0.38 build but i cant find it with tag or with git log 6d605c9

Matthias Leinweber

@lnnwvr_twitter

.. docu didnt container superset init .. found in in init scripts .. does superset support relative url roots host:/somepath/superset ?

vatsalya-ai

@vatsalya-ai

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

@AbhaySoningra

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

@AbhaySoningra

Though a pie chart using aggregate functions for one column worked fine

Chanh Le

@giaosudau

do superset have any plugin to format sql query?

Aditya Verma

@BigDataArtist

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_STARTTLS = True
SMTP_SSL = False
SMTP_USER = "superset"
SMTP_PORT = 587
SMTP_PASSWORD = "*"
SMTP_MAIL_FROM = "someemail@outlook.com"

Aditya Verma

@BigDataArtist

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"
CELERYD_LOG_LEVEL = "DEBUG"
CELERYD_PREFETCH_MULTIPLIER = 1
CELERY_ACKS_LATE = False
CELERY_ANNOTATIONS = {
    "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,
    },
}
CELERYBEAT_SCHEDULE = {
    "email_reports.schedule_hourly": {
        "task": "email_reports.schedule_hourly",
        "schedule": crontab(minute=55, hour="*"),
    }
}

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

@BigDataArtist

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

@MohamedAbdultawab_gitlab

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

@joebordes

Have you tried this: apache/superset#9747 ?

Mohamed Abdultawab

@MohamedAbdultawab_gitlab

yes

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

@joebordes

over my head. sorry

Mohamed Abdultawab

@MohamedAbdultawab_gitlab

Thanks

Where communities thrive

People

Repo info

Activity