[Python] Superset: error saving charts or dashboard

Discussão em 'Python' iniciado por Stack, Outubro 4, 2024.

  1. Stack

    Stack Membro Participativo

    I have just installed Superset on a brand new machine over Docker and everything works fine but I can't save a chart or dashboard. I always get "Unable to save slice" error message.

    I can save queries and datasources though without problem and if I access to a chart though a permalink I can see the chart as it was with not problem.

    Going through the logs, I saw that the error message is:

    sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
    (Background on this error at: https://sqlalche.me/e/14/e3q8)


    The weird thing is that I'm not using sqlite3, but postgress...

    The DB connection in the superset_config.py is (or I think it is):

    # DB connection
    SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2://XXX:XXX@postgres:5432/superset'
    SQLALCHEMY_TRACK_MODIFICATIONS = True


    I have confirmed that that's the config file set in PATH SUPERSET_CONFIG_PATH=/app/superset_config.py

    I have also confirmed that the postgres machine is running and is accesible from the superset machine.

    Can anyone help to understand why is trying to connect to sqlite3? Thanks!

    Continue reading...

Compartilhe esta Página