Destination Table Is Empty Even Though the Source File Contains Data

Issue

The source file contains data, but the corresponding destination table is empty.

Environment

Connector: Google Sheets

Resolution

To resolve this issue, check the configured named range and confirm that it includes the data you want to sync:

1. In Fivetran, go to your Google Sheets connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. Check the Named Range field.
5. In the source file, verify that the named range includes the data you want to sync.

If the data is outside the named range, update the named range to include it. After the next successful sync, we replace the destination table with the current contents of the named range.

To run a sync in Fivetran, go to your Google Sheets connection page and click Sync in the top right.

Cause

During each sync, we replace the destination table with the current contents of the configured named range. If the named range is empty during a sync, we replace the destination table with zero records. The table remains empty until the named range contains data and another successful sync runs.