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?


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:

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:

It’s currently not possible to sync specific schemas/tables, but there’s a request open for that: - 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.

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: - upvote by clicking :+1: on the first post

@flamber I got it. Thanks.