Dear Metabase User,
I have a problem that I don’t know how to alleviate.I use Vertica as the source database.Every time I refreshed the database, the refresh was slow.It like this:
Slow refresh bottlenecks are in sync_fields.How can I make it refresh faster or alleviate the situation?
Without knowing which Metabase version you’re using, it’s possible you’re seeing this issue, which is fixed in 0.37.1:
I used version 0.36.3.I don’t think this issue is what I want to ask.I hope to make sync_Schema as fast as possible. Could you please add some configuration items or optimize it? Our current requirements have some requirements on real-time sync.
Upgrade to 0.37.2, which has a much faster sync process: https://github.com/metabase/metabase/pull/13746
It’s currently not possible to sync specific schemas/tables, but there’s a request open for that:
https://github.com/metabase/metabase/issues/5500 - upvote by clicking on the first post
There’s no real-time sync, but you can use the API to initiate the sync process, when your database schema changes.
I got it. In particular, we want to add sync_table functionality as soon as possible.
Another question,sync_schema is asynchronous, what API or other place can I get it from until the refresh is complete?
@jesse1 Then use the API to trigger a sync, when your database schema changes. There’s currently no API available to check, when the sync has completed, which is also the reason for this issue:
https://github.com/metabase/metabase/issues/11354 - upvote by clicking on the first post
@flamber I got it. Thanks.