How to speed up sync_schema

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?

Thanks.

Hi @jesse1
Without knowing which Metabase version you’re using, it’s possible you’re seeing this issue, which is fixed in 0.37.1:
https://github.com/metabase/metabase/issues/13628

Hi,@flamber
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.
Thanks.

@jesse1
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 :+1: 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.
https://github.com/metabase/metabase/blob/master/docs/api-documentation.md#post-apidatabaseidsync_schema

@flamber
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?
Thanks.

@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 :+1: on the first post

@flamber I got it. Thanks.