Google Drive (Live)
Vendor/Partner | |
|---|---|
Version | V3 |
API Documentation | |
Sunset Date | None listed as of 01/04/2024 |
Channel(s) | All |
Refresh Time (CST) | On change; 2AM |
Default backfill | N/A |
Alli Data Library |
|
Before Getting Started
To get started with the Google Drive datasource, ensure you have the following:
A Google account with access to a Google Sheet
Required Authorization
Click the button to login to your Google account instance and provide Alli access to your Google Drive.
Additional Configurations
Link To Your Google Sheet
Enter the URL for the Google Sheet you would like to ingest data from into Alli.
Sheet Name
Optionally specify which sheet tab you would like to ingest data from into Alli. If left blank Alli will assume the first sheet tab in your workbook. Sheet tab names must be less than 32 characters.
Frequently Asked Questions
What is the difference between the Google Drive and the Google Drive Live datasource type?
The main difference between these datasource types is the freshness of the data in Alli. The standard Google Drive datasource updates data in Alli every day on a set schedule. The Google Drive Live datasource type is constantly updating data in Alli each time there is an update within the Google Sheet. This happens because each time the Google Sheet saves, it sends a notification to Alli that there are updates to the data and Alli should refresh it’s data.
What limitations should I be aware of with this datasource type?
Currently, this datasource type can only save data to your Redshift database.
How can I query the data from this datasource type?
The data can be queried through Alli Data Explorer’s Custom SQL option (Tutorial). Additionally, this data is saved in a slightly different location and requires the client slug to be slightly altered in the query in this format {client_slug}_external.{datasourcename}. For example, if I have a datasource in my Demo client named test_live_google_drive, I can query this data by doing: select * from demo_external.test_live_google_drive.
How is data updated in Alli?
The Google Drive Live datasource type will do a full replace of data on each load.
Does this datasource support parent-child relationships?
The Google Drive Live datasource type does not currently support parent-child relationships.