Hi there,
At my company we’re adopting DBT to structure our queries, and we are transitioning out Tableau in lieu of Metabase.
I have faced a few issues when having this setup:
-
When a DBT model (which is just a .sql script wrapped in Jinja) is deleted, Metabase does not seem to detect this even after resyncing the database.
-
I’m also facing issues with getting new DBT models which are materialized as scripts. As with many other community posts I’ve seen here - resyncing doesn’t seem to be allowing me to view the new data tables. Are there common practices regarding fixing these sync issues?
What I expected was manually resyncing would allow me to immediately (or at least within a few minutes…) see the changes I’m making within DBT.
- A third issue I faced was dropping a column within my DBT model - resyncing the database for that particular table does not update to the updated columns for that table - not only that, Metabase just doesn’t allow me to access the table as the expected columns are missing. I tried discarding the cached values within the database but wasn’t able to resolve this.
I tried the solution of creating a new DBT model that was the exact same sql script, but renamed to a different name. I expected this to work, but I don’t see my updated table a-n-y-w-h-e-r-e.
Appreciate if anyone can help a newbie out on what I’m probably doing wrong!