Google Drive
Google Drive is a cloud-based storage and synchronization service provided by Google. It allows users to store files online, share them with others, and access them from any computer, smartphone, or tablet. Users can also collaborate on documents, spreadsheets, and presentations in real-time using Google's suite of productivity tools, which are integrated with Drive. This service is known for its ease of use, accessibility, and generous free storage allowance.
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | True | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
The Google Drive connector combines all files within a single folder into one table. Therefore, it's best to keep only one kind of data in each folder. You can only sync one folder per data source - for multiple folders you will need to create new data sources.
π§ Setup Guide - ELT
Step 1 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Click Authorize to allow Weld to access your Google account using OAuth. You will be redirected to your Google account.
Step 2 - Grant access to Weld
- Click Grant Access to allow Weld to connect to your Google app. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.
Step 3 - Connection Settings
- Select the file type, sync mode and folder that you would like to sync data from.
Step 4 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 5 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Google Drive folder.