scubamut
2/28/2018 - 6:22 AM

Show tables in superset.db database

Show tables in superset.db database

import os

os.chdir('C:/users/scuba/.superset')
sqlite_file = os.getcwd() + '\\superset.db'
db = sqlite3.connect(sqlite_file)
cursor = db.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
tables = cursor.fetchall()
for table_name in tables:
    print(table_name)