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 ID. {%dropdown-button name="shared_drive"%}

{%dropdown-bodyname="shared_drive"%}

You can find this ID in the URL when you're viewing the drive in your browser (drive.google.com/drive/u/0/```your_drive_id```).

{%dropdown-end%}

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%}

8. Select the necessary Use binary strings option from the dropdown. {%dropdown-button name="use-binary-strings"%}

{%dropdown-body name="use-binary-strings"%}

The "Use binary strings" determines whether string fields are encoded in binary format when loading data.

Recommended setting: "No" (default).

{%dropdown-end%}

‍

Additional information

Folder

Possible parameters:```/{{workspace_id}}/{{workspace_title}}/{{data_source}}/{{dataclass}}/{{data_table_title}}/{{report_type}}/{{filename}}/{{YYYY}}/{{MM}}/{{DD}}{{YYYY_today}}/{{MM_today}}/{{DD_today}}```‍

File format

Possible formats:

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

Filename

Possible parameters:```{{data_source}}-{{report_type}}-{{data_table_title}}-{{filename}}-{{dataclass}}-{{YYYY}}-{{MM}}-{{DD}}-{{H}}-{{M}}-{{S}}-{{timestamp}}-{{chunk_id}}```‍

• ```{{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

{%docs-informer warning title="Important"%}

{{YYYY}}/{{MM}}/{{DD}} partitioning is based on a date field in the exported data. If the dataset does not contain an actual date field (for example, no “date” column/field), these partition values cannot be derived and date-based partitioning will not work as expected. In that case, use {{YYYY_today}}/{{MM_today}}/{{DD_today}} to partition by the export run date instead.

{%docs-informer-end%}

{%docs-informer info%}

{{YYYY}}/{{MM}}/{{DD}} refer to the record’s date-based partition values (if applicable), while {{YYYY_today}}/{{MM_today}}/{{DD_today}} always use today’s date.

{%docs-informer-end%}

‍

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

‍