Importing data from Fivetran connectors
Last updated
Last updated
Use this procedure to import data from Fivetran connectors. With 300+ connectors, we have explained how to import data from one of the Fivetran connectors, i.e. Google Drive.
To import data from Google Drive:
Hover over the menu icon and select Connectors. The Connectors page is displayed showing the total number of connectors.
The Data connectors screen is displayed.
Click the plus icon on the top. You can also use the +New data connector button on the workspace to create a new connection.
Select Google Drive. It is a Fivetran connector.
Enter the name of the connector.
Click Create Connection. This takes you to the fivetran page
Click Continue. This opens the page where you can provide the Google Drive details.
Click Copy corresponding to the FiveTran email field to copy this email.
Navigate to your Google Drive and click the folder you want share and sync to the platform, and then click the Share option. You must provide editor access to this folder for all.
Copy the folder URL where the files on the Google Drive are stored.
Click Save & Test to sync the datasets in Google drive to the platform. You can see the datasets that are syncing up.
Note: When the sync fails, you can use the manual sync option to restart the syncing process.
You can now view the datasets fetched from Google drive on this Data connector in the platform with the files and total records in each file. This is displayed in the table.
Click on the dataset or file to view the sample data. This shows maximum of 50 rows and columns.
On this page, you can do the following:
Manually sync the dataset to fetch the latest data by using the Sync option. If you do not sync manually, the platform will sync automatically every few hours. You can also view the timestamp of the last sync triggered.
Modify the existing configurations, using the Edit Configurations button.
To delete the data connector, click the Actions drop-down and select the Delete option.
