airbnb/superset

Abhay Soningra

@AbhaySoningra

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

VedashriDebray

@VedashriDebray

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

@mentalists_gitlab

Hi, Can anyone let me know where all can we make use of Python in Apache superset and how?

Billy Odera

@billy-odera

how can i format the numbers for my superset dashboard? instead of 10000 i have 10,000

Bastien Vial-Collet

@vialcollet

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.

josefhernandez

@josefhernandez

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

abdullahaaf

@abdullahaaf

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

@Riskatri

hi, i make a pie chart with datetime data but a value is 14985701929 not a date time. what should i do ??

iosivp

@iosivp

@rajeshchy Have you got any solution for the problem? I need this too.

Michael Rea

@rea725

@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

@ypankovych

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

Aquino

@aquinovo

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

@AlexRiedler

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

@bruce808

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

@Hemanthdev

Name email_reports.send

Traceback
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, kwargs)
File "/root/venv/lib/python3.6/site-packages/superset/tasks/schedules.py", line 527, in schedule_email_report
session,
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
get_reports_user(session)
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

@Riskatri

HI, does anyone know about multiplier and javascript data interceptor in deck.gl scatterplot superset?

LIUHAO_RGG

@t1014t

Instance <Query at 0x25c5a805e48> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: http://sqlalche.me/e/13/bhk3)

sql cant use

Sreekrishnanchidambaram

@Sreekrishnanchidambaram

We are currently amidst a situation, where we want our Dashboard/chart owners to share their dashboard to only a specific set of user, to whom the owner decides to share it with (also some sort of audit for the owners to know who and all have access to dashboard ) .

Version: 0.37.2
Deployed: Google Kubernetes engine & on prem
Authentication: Oauth
Role: Custom role for all normal users (Gamma + sql lab role)
Database: Connection to presto only
Meta store : Postgres (stand alone outside Gke)

Notes : Each user have their own unique database connection to the same presto . Hence the data source permissions for charts are assigned manually for now . We need to automate the permission
Primary concern : The user should to whom the dashboard is shared should only have read access . also some sort of audit for the owners to know who and all have access to dashboard

Guy Doulberg

@guydou

Hey, I am thinking about using apache superset, and I am wonder if it is the right tool to my use-case. I am working for a startup company, which is collecting unique data points, on top of that data we build data warehouse that has KPIs with an hierarchy. We want to build a self service dashboard as part of our offering to our users. Our system is designed to be multi-tenant, but the KPIS and measurements are general, but the data is unique for each tenant, and should be available only for the tenant account. We think that superset might help us with: 1. speeding up dashboard and widgets development using embedded dashboard. 2. Securing the the tenant data (using row level security). I just started my analysis and I don't have experience with superset in a production environment which is part of the customer critical path. Is anyone here as experience using sueprset in such a use-case? Thanks

Where communities thrive

People

Repo info

Activity