How to extract the metadata of slices from superset

162 views
Skip to first unread message

Aakash Bhardwaj

unread,
Dec 5, 2016, 2:04:26 AM12/5/16
to airbnb_superset
Hi all,

This is a general question that I couldn't find the answer to - What database is being used to store the metadata of slices that a user creates (data like the druid source, the json query generated and all the filters and settings), and how should I go about getting that data (Just the source's info should be enough, I can get the data myself if I know how it is being stored) ?

Maxime Beauchemin

unread,
Dec 5, 2016, 11:38:01 AM12/5/16
to airbnb_superset
Well that depends on your setup, you can use different backends for the metadata (MySQL, Postgres, sqlite, ...). By default it's sqlite and the db is in `~/superset`.

You can also use the ORM (SQLAlchemy) to access the data programatically.

```
from superset.models import Slice
from superset import db
slices = db.session.query(Slice).all()
``` 

Max
Reply all
Reply to author
Forward
0 new messages