CODEWITHSUNDEEP
linuxapache-superset
Mostafa Zeinali
Mostafa Zeinali

Reputation: 2624

Where does Apache Superset Store User Queries?

I had Apache Superset installed on an ubuntu server. A BI developer had created several dashboards in there for our company. In a chain of mistakes, the server is broken now, so we cannot start the superset server process anymore. Is there any way to rescue the "queries" that were used to create those dashboards or should all of those be re-written? Does superset store the user-defined queries in a DB or in a File/Dir on disk? If it's a DB or a file, where is it? And how can I access it and fish out those queries?

I tinkered a little with the superset-env folder in my home dir, but couldn't find anything useful there.

Upvotes: 1

Views: 2284

Answers (1)

Ana GH
Ana GH

Reputation: 1700

There's a database to store the Apache Superset metadata, the database is going to depend on how you configured Apache Superset in your installation.

With the default installation in older versions of superset it was an sqllite database in ~/.superset/superset.db, this has been probably changed with the newer versions, since sqllite is not recommended for a production installation of superset.

I don't think the organization of the database has been documented, so you'll probably have to guess yourself, with some ocassional help of a search result in starckoverflow.

Upvotes: 1

Related Questions