Using Google Drive connector in ETL pipeline

The Google drive connector supports the following:

• CSV files including google sheets.

• Fixed width files including google docs.

• Text files including google docs.

The following examples show how to use the Google Drive connector:

• In example 1, the Google Drive connector is the source, and an entity is a destination.

• In example 2, the Google Drive connector is the destination, and an entity is the source.

Prerequisites for the examples

For both the examples below, the following are created:

1. An Entity with the name TEST_Customers_Entity with the following fields: (Data has already been added to the entity.)

   1. 1.Customer_ID as GUID

   2. 2.First_Name as string

   3. 3.Last_Name as string

   4. 4.Country as string

2. CSV file on Google Drive with columns to be mapped to the entity:

   1. 1.Customer_ID

   2. 2.First_Name

   3. 3.Last_Name

   4. 4.Country

3. Connection is established through the Google Drive connector.