Setup Steps

Setup Instructions

DLH.io securely connects to your Google Drive account that you have access to using the security of Google authentication. Using the form in the DLH.io portal please complete the following basic steps.

1. Enter a Name or Alias for this connection, in the 'Name/Alias' field, that is unique from other connectors

2. Enter a 'Target Schema Prefix', which will be the prefix for the schema at the target you will sync your data files into

3. Enter a Folder Path,is a path on the root bucket from where desired files will be retrieved

   • File Pattern, is a regular expression (RegEx) used to isolated only certain files to be retrieved
   • File Type, allows for a pre-determined type of file extension to be retreived

4. Enter your Service Account Key, which should be a JSON string

   • Paste the entire Service Account Key (JSON). If using this bucket as process storage for BigQuery, please Add this Service Account email, dlh-global-bq-data-sync-svc@stg-DLH.io.iam.gserviceaccount.com, as a principal user on your GCP project and assign it the Storage Admin role.

5. Click the Save & Test button. Once your credentials are accepted you should be able to see a successful connection.

Other Information and Links

• Change Log & Notes
• Connector's Supported Features
• Main Overview for this Connector