Dashboard Takes a Long Time to Fetch Connector Schema
Issue
While setting up a connector, Fivetran takes a long time to fetch the connector's schema. The following message appears:
We'll email you when your schema is ready! Fetching the schema
usually only takes a few minutes, though it can take up to a few days for larger datasets.
We will continue to fetch the connector schema in the background.
Environment
All connectors except the Magic Folder.
Resolution
To resolve this issue, you can choose to block or hash columns after the initial sync is complete by doing the following:
- Delete the connector.
- Create a new connector with the same name.
- Click Start Initial Sync.
Cause
This issue may occur if you choose to block or hash sensitive data before an initial sync occurs. In that case, Fivetran must first extract the data from the source so we can discover the schema, then wait until you have decided what to mask before completing the sync and loading data to the destination.
This may take a long time because we must extract all columns specific to your account and the connector before starting an initial sync.