Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Roopkumar
    @roop11lucky
    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.
    di-coder
    @di-coder
    @ilex:oakforest.in I tired but same issue. Not getting email and any errors
    milad000cu
    @milad000cu
    I installed Superset and connected the PostGres database to it, but the database list in the dataset creation form is empty and there is no database
    https://pasteboard.co/gT0ocv1NjGDI.jpg
    rahul ranjan
    @ranjanrahul910
    Hi All,
    when i am trying to embed chart in html page getting error Blocked autofocusing on a <input> element in a cross-origin subframe. - anyone any idea how to resolve this
    michaelhagel
    @michaelhagel

    Hey all - creating an API workflow for auto-generating dashboards. Context: ML model monitoring for our enterprise. Problem: Currently stuck on generating a query_context for a POST api/v1/chart/ request, based off of a saved_query.

    Is there a defined way of generating this query_context? Or example repos containing a programatic workflow that I could refer to instead?

    minsu-jo
    @minsu-jo
    What should I do when I need to execute a query with Trino datasource?
    I installed sqlalchemy-trino and trino(trino-python-client) before deploying Superset, and I saw the message when I connected with my Trino cluster: "connection looks good."
    And I also saw the schema and table through the connection with Trino in SQL lab .
    But when I executed a query to Trino, I got an error: "__init__() got an unexpected keyword argument 'user'."
    Mark Thielen
    @MarkThielen

    Hi there, we are looking into working ob the current Alert/Reports area to
    1) Use the Alert/Report Owner to generate the Data within the Celery Worker Code as we are using Row Level Security for Multi Tentant Type Integration
    2) Add a S3 Data Drop as an addition to the already available Email and Slack
    3) Use the Chart Data API to use a configured Chart Context instead of the pre-set Chart Context

    We want to do this based on 1.5.0 Code at this time.

    • Are there any instructions available what we need to take into consideration when forking, etc ?
    • Is there a a responsible group of people that are working on this area (Alerts / Reports) to make sure our approaches are okay ?
      Thanks, Mark