Transfer data at scale from your warehouse to Google Drive
Hightouch will prompt you to authorize with your Google account with the following scopes:
After authorizing, you will have successfully connected Hightouch to Google Drive.
Hightouch lets you input the folder link to where the file will be synced to.
- All - All Mode creates a CSV file with all the rows in the query results, every time the sync is run.
- Insert - Insert mode creates a CSV file with the rows that were added since the last sync.
The file name field will allow you to specify the prefix and the name of the file that you want to use for your results. In the screenshot below, we've specified that we want the file to be called results.csv, with a custom prefix.
You can also timestamp variables in the file name, surrounding each with
We currently support these timestamp variables: YYYY, MM, DD, HH, mm. All dates and times will be UTC.
For this destination, we give you the ability to export all columns as they are represented in your model.
If you need to remap the fields that you're exporting, maybe because you don't want to alter your model, you can manually map fields. Only the fields that you map will be exported in this instance. In this example, we're exporting company, email, name, and primaryKey. These fields are mapped to new fields in the CSV, and all other columns from your results are ignored.
We provide you the option to include a CSV header with your exported results.
If a file at that path already exists at the time of a sync, Hightouch will overwrite it. To view different versions of the same file, you can right-click on the file in Google Drive and then click on Manage versions.
This destination will not respect any sorting that you have in your model. It will export results file sorted by ID.