Skip to content
sandadocs
Console Start free trial

Google Drive

Connect Google Drive to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect Google Drive

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Google Drive. It is listed under files and storage; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Folder Url string Yes URL for the folder you want to sync. Using individual streams and glob patterns, it's possible to only sync a subset of all files located in the folder.
Delivery Method one of 3 options No
Start Date string No UTC date and time in the format 2017-01-25T00:00:00.000000Z. Any file modified before this date will not be replicated.
The list of streams to sync array Yes Each item defines a stream: which files belong in it, their format, and how they are parsed and validated. Each stream lands in your warehouse as its own table.
Authentication one of 2 options Yes Credentials for connecting to the Google Drive API.

Delivery Method

Choose one of the following. Each asks for its own fields.

Replicate Records

No further fields.

Copy Raw Files

Field Type Required Description
Preserve Sub-Directories in File Paths boolean No If enabled, sends subdirectory folder structure along with source file names to the destination. Otherwise, files will be synced by their names only. This option is ignored when file-based replication is not enabled. Default true.

Replicate Permissions ACL

Field Type Required Description
Domain string No The Google domain of the identities.
Include Identity Stream boolean No This data can be used in downstream systems to recreate permission restrictions mirroring the original source. Default true.

Authentication

Credentials for connecting to the Google Drive API.

Choose one of the following. Each asks for its own fields.

Authenticate via Google (OAuth)

Field Type Required Description
Client ID string, secret Yes Client ID for the Google Drive API.
Client Secret string, secret Yes Client Secret for the Google Drive API.
Refresh Token string, secret Yes Refresh Token for the Google Drive API.

Service Account Key Authentication

Field Type Required Description
Service Account Information string, secret Yes The JSON key of the service account to use for authorization.

Something unclear or out of date? Tell us, and we will fix the page.