3

I can smoothly connect my MySQL database to Superset and create a table, slice and dashboard, but when I add a new column in the table in MySQL, the table I created in Superset would not change or refresh the schema.

In order to solve the problem, I have to delete the old tables, slice and dashboard and connect again to rebuild them, which doesn't make sense.

Is there any way I can refresh schema in superset when table schema in MySQL is modified?

TylerH
  • 20,799
  • 66
  • 75
  • 101
chilun
  • 292
  • 6
  • 19

1 Answers1

4
  • Superset v. 1.0.0
  • postgreSQL

when schema is changed, just refreshing the schema in table edit won't add the new columns. You have to click: enter image description here

TylerH
  • 20,799
  • 66
  • 75
  • 101
mona-mk
  • 101
  • 2
  • 4
  • Can we automatically Refresh/Update the columns? Meaning to automatically click "Sync columns from source" using a script or a scheduled app? – NikSp Apr 06 '22 at 17:10
  • When I clicked that all columns disappeared. – LWang May 05 '22 at 21:39