Google Cloud Storage
Google Cloud Storage is Google's cloud storage system.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step Google Cloud Storage connector setup guide to start syncing files from Google Cloud Storage to your destination.
Sync overview
Syncing spreadsheets
To sync Excel files, you must select xls/xlsx/xlsm as the file type in the connection setup form and specify the cell reference during connection configuration. We use the cell reference to sync contiguous data to the right of the cell and below it in the Excel worksheet. Let's say you have two Excel worksheets in a workbook, Data1 and Data2, and you want to sync your data from cell C3 of the Data2 worksheet. Then, your cell reference will be 'Data2'!C3.
As a result, Fivetran syncs data from worksheet Data2, cell C3.
Fivetran does not support identifying data ranges in rows containing merged cells. Such rows are excluded from data range calculations to ensure accuracy.