Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    abdullahaaf
    @abdullahaaf
    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
    Ahmad K. Bawaneh
    @vegegoku
    Hi
    I playing with superset and i want to embed it inside an application for a demo, I am runing it using the docker-compose and it is working, but when i try to use the public dashboard approach i cant view the dashboard unless the user logs-in
    I have set the flag PUBLIC_ROLE_LIKE = "Gamma" and provided all required permissions in the public role, yet when i try to view the dashboard without logging in it fails with Unexpected Error
    2 replies
    image.png
    Justin
    @Paladiamors

    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_CONFIG = {
        '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',
    }
    
    DATA_CACHE_CONFIG = {
        '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.

    radhakvnr
    @radhakvnr
    Hi, is there any Pros and Cons of Apache Superset Single Tenant vs Multi tenant?
    Chandresh
    @ChandTurakhia_twitter
    hi
    need help with filter box : it seems it does not generate sql
    Andre Violante
    @aviolante
    Hey is there a slack channel for Superset still?
    aoelvp94
    @aoelvp94
    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
    @ranjanrahul910
    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
    @ranjanrahul910
    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.
    timalive
    @timalive
    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
    @rajengla
    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
    @ranjanrahul910:matrix.org
    [m]
    2 replies
    Hi All, when i am trying to embed dashboard in iframe getting below error, can any one suggest on this.
    Anuj
    @anuj-code123

    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

    export_csv_not_working.png

    1 reply
    Kamil Biela
    @kamilbiela
    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
    sbbagal13
    @sbbagal13
    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
    @kushagra_zolo_gitlab
    Getting Error
    Associated data exists, please delete them first
    When trying to delete users. Anyone has any idea on how to fix this?
    bmaatoug
    @bmaatoug:matrix.org
    [m]
    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
    @SSujiplr_twitter
    Hi, not able to use from_dttm in apache superset, its not replacing the filter values.
    Sujith Kumar S
    @SSujiplr_twitter
    Hello Everyone, with clause in not working against MSSQL from superset. Any options ?
    Chiny
    @Chinyeins
    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?
    Chiny
    @Chinyeins
    ahh figured it out - to impl custom oauth provider in superset you have to impl. userinfo getter in superset SecurityManager.
    Raj Nishtala
    @rnishtala
    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 | 172.20.0.1 - - [31/Jan/2022:10:37:56 +0000] "POST /login/ HTTP/1.1" 500
    4 replies
    Ronald Munjoma
    @ronna