Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    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
    Hi I just you will get responses on the Slack channel: https://join.slack.com/t/apache-superset/shared_invite/zt-uxbh5g36-AISUtHbzOXcu0BIj7kgUaw
    most of the communication is now on slack
    Roopkumar
    @roop11lucky
    Hi All,
    Can someone help me how to create Dashboard and Charts through API only, without using the GUI to create it.
    salah alhashmi
    @alguerocode
    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
      https://github.com/devSupporters/volder
    Jonathan Churque
    @madbean

    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

    configOverrides:
    ENABLE_TEMPLATE_PROCESSING: "True"

    but no luck for me :(

    salah alhashmi
    @alguerocode
    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
    https://github.com/devSupporters/volder
    _
    nikil katturi
    @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
    di-coder
    @di-coder
    Hi All, ERROR: (builtins.NoneType) None
    (Background on this error at: http://sqlalche.me/e/13/dbapi)
    Can anyone help with this?
    AhmetKahyaoglu
    @AhmetKahyaoglu
    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
    @joebordes
    Hi
    if you execute docker ps do you see the 8088 port mapped to your server in the ports column?
    AhmetKahyaoglu
    @AhmetKahyaoglu
    [root@ereteam ~]# docker ps
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    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) 0.0.0.0:8088->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.
    Joe Bordes
    @joebordes
    80e0e565f0f3 this one looks correct
    but the other two may be getting in the way
    you should have only one
    try docker stop 1991ec6e9bd3
    and again with the other unhealthy one
    AhmetKahyaoglu
    @AhmetKahyaoglu
    I am trying
    AhmetKahyaoglu
    @AhmetKahyaoglu
    I tried, the result did not change.
    Screen log ;
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    supersetapp | util.raise(
    supersetapp | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise
    superset_app | raise exception
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    superset_app | self.dialect.do_execute(
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    superset_app | cursor.execute(statement, parameters)
    superset_app | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "ab_permission_view_role" does not exist
    superset_app | LINE 2: FROM ab_permission_view JOIN ab_permission_view_role ON ab_p...
    superset_app | ^
    superset_app |
    superset_app | [SQL: SELECT ab_permission_view.id AS ab_permission_view_id, ab_permission_view.permission_id AS ab_permission_view_permission_id, ab_permission_view.view_menu_id AS ab_permission_view_view_menu_id
    superset_app | FROM ab_permission_view JOIN ab_permission_view_role ON ab_permission_view.id = ab_permission_view_role.permission_view_id JOIN ab_role ON ab_role.id = ab_permission_view_role.role_id JOIN ab_permission ON ab_permission.id = ab_permission_view.permission_id JOIN ab_view_menu ON ab_view_menu.id = ab_permission_view.view_menu_id
    superset_app | WHERE ab_permission.name = %(name_1)s AND ab_role.id IN (%(id_1)s)]
    superset_app | [parameters: {'name_1': 'menu_access', 'id_1': 2}]
    superset_app | (Background on this error at: http://sqlalche.me/e/13/f405)
    superset_app | 172.18.0.1 - - [07/Mar/2022:15:09:19 +0000] "GET /login/ HTTP/1.1" 500 0 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
    superset_app | 127.0.0.1 - - [07/Mar/2022:15:09:35 +0000] "GET /health HTTP/1.1" 200 2 "-" "curl/7.74.0"
    superset_worker_beat | [2022-03-07 15:10:00,030: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
    docker status ;
    [root@ereteam ~]# docker ps
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    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) 0.0.0.0:8088->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
    [root@ereteam ~]# docker stop 1991ec6e9bd3
    1991ec6e9bd3
    [root@ereteam ~]# docker ps
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" About an hour ago Up About an hour (healthy) 0.0.0.0:8088->8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" About an hour ago Up About an hour (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" About an hour ago Up About an hour 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" About an hour ago Up About an hour 6379/tcp superset_cache
    [root@ereteam ~]#
    Joe Bordes
    @joebordes
    try accessing the IP directly
    docker inspect 80e0e565f0f3
    get the IP of the container and access directly http://{ip}:8088
    AhmetKahyaoglu
    @AhmetKahyaoglu
    Hello,
    Good morning everybody. I couldn't access from Docker IP's either. Anyone have any other suggestions? It's a critical issue for me. :/
    AhmetKahyaoglu
    @AhmetKahyaoglu
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    1991ec6e9bd3 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 5 minutes (unhealthy) 8088/tcp superset_worker
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 5 minutes (healthy) 0.0.0.0:8088->8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 4 minutes (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" 17 hours ago Up 5 minutes 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" 17 hours ago Up 5 minutes 6379/tcp superset_cache
    AhmetKahyaoglu
    @AhmetKahyaoglu
    Hello everyone, @joebordes I solved the problem. I leave the link below.
    apache/superset#11612
    Thanks for your support.
    Joe Bordes
    @joebordes
    great!!
    have a wonderful day
    salah alhashmi
    @alguerocode

    All-In-One, free resources and collections related to javascript. we provide useful links to help you learn JavaScript, web development and other related stuff along with some of the best resources available online.

    https://github.com/devSupporters/masterJS

    di-coder
    @di-coder
    Hi All, I have enabled the ALERT_REPORTS feature and also configured SMTP. The scheduler is working properly but I don't receive any emails.
    Can any help ???
    EMAIL_NOTIFICATIONS = True # all the emails are sent using dryrun
    SMTP_HOST = "smtp.gmail.com"
    SMTP_STARTTLS = True
    SMTP_SSL = False
    SMTP_USER = "XXXXXXX"
    SMTP_PORT = 587
    SMTP_PASSWORD = "XXXXXXX"
    SMTP_MAIL_FROM = "XXXXXXX"
    ALERT_REPORTS = TRUE
    ilex
    @ilex:oakforest.in
    [m]
    @di-coder: did you try with port 465, SSL true and STARTTLS false?
    di-coder
    @di-coder
    Okay Sure I'll Check.