Alert: We'll Email You When Your Schema Is Ready

Issue

During an initial sync for a new connection, Fivetran takes a long time to fetch the schema. The following alert appears on the Schema tab:

We'll email you when your schema is ready! Fetching your data now! It might take a while. We'll send you an email when this is done.

Environment

All connectors except the Magic Folder connectors.

Resolution

If you have chosen to block data or hash columns, you can resolve this issue by creating a new connection and completing the initial sync first:

1. Delete the existing connection.
2. Create a new connection with the same name.
3. Click Start initial sync.
4. Wait for the initial sync to complete.
5. Reconfigure data blocking and column hashing.

If you haven't configured data blocking and column hashing, contact our support team.

Cause

This issue occurs when you block or hash columns before running the initial sync. When this happens, we must extract and cache your source data to discover the full schema, then apply your blocking and hashing selections before syncing the data to the destination. This extra step delays the initial sync because Fivetran must query all tables and columns in your source.