Documentation

Note: Google Drive is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Google Drive.

Description

Google Drive is a file storage and synchronization service developed by Google. Google Drive allows users to store files in the cloud, synchronize files across devices, and share files.

Setup guide

Follow our setup guide to connect Google Drive to Improvado.

Authorize your Google account

On the Google Drive connection page, click on the Sign in with Google button and authorize your Google account.

Complete configuration

After the successful authorization with Google, you’ll be redirected to the Destination connection form:

1. Enter a name for your Destination connection in the Title.
2. Enter the Folder. {%dropdown-button name="folder"%}

{%dropdown-bodyname="folder"%}

A forward slash (```/```) means that you need to enter the root path.

{%dropdown-end%}

3. Select the File format from the dropdown.
4. Enter the Filename.
5. (Optional) Enter the Shared Drive.
6. Select the Separator from the dropdown.
7. Select the Partition by from the dropdown. {%dropdown-button name="partition"%}

{%dropdown-body name="partition"%}

Partition is the way of splitting data for uploading to the file.

{%dropdown-end%}

Additional information

Folder

Possible parameters:```/{{workspace_id}}/{{workspace_title}}/{{data_source}}/{{data_table_title}}/{{report_type}}/{{filename}}/{{account}}/{{YYYY}}/{{MM}}/{{DD}}```‍

File format

Possible formats:

• csv
• csv+gzip
• json
• json+gzip
• parquet
• avro

Filename

Possible parameters:```{{filename}}-{{YYYY}}-{{MM}}-{{DD}}```‍

• ```{{filename}} ```- is the same as the destination table name

Important: you cannot use ```{{DD}}``` for partition by month

• ```{{filename}}-{{YYYY}}-{{MM}}-{{DD}}``` – for partition by day
• ```{{filename}}-{{YYYY}}-{{MM}}``` – for partition by month

Also, you can use “_” instead of “-” or do not use any symbols at all, for example:

• ```{{filename}}_{{YYYY}}-{{MM}}-{{DD}}```
• ```{{filename}}{{YYYY}}{{MM}}{{DD}}```

Separator

Possible delimiters that can separate data in your file:

• comma
• semicolon
• tab

Partition by

Possible ways of splitting data:

• Day
• Month

‍