Google Drive PRIVATE PREVIEWlink
Google Drive is a file storage and synchronization service. Fivetran supports syncing files from your Google Drive to your destination. You can sync multiple files as unique tables to your destination.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture Deletes | ||
Custom Data | check | All tables and fields |
Data Blocking | ||
Column Hashing | ||
Re-sync | check | Connector level |
History | ||
API Configurable | ||
Priority-first sync | ||
dbt Package |
Setup guidelink
Follow our step-by-step Google Drive setup guide to connect your Google Drive with your destination using Fivetran connectors.
Sync overviewlink
The Google Drive connector is a Magic Folder connector. We retrieve all the files from the folder that you specify into your destination. Each file is synced as a separate table in the destination.
We only sync the files inside the specified folder. We ignore nested folders.
Schema informationlink
We use the file name (without the extension) as the destination table name. For example, a file called sample.csv
is synced as SAMPLE
table.
If we find more than one file of the same name, but with different extensions in the folder, we check the last modified dates of the files and sync only the most recently modified file.