None listed as of 01/04/2024
Refresh Time (CST)
On change; 2AM
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
Click the button to login to your Google account instance and provide Alli access to your Google Drive.
Link To Your Google Sheet
Enter the URL for the Google Sheet you would like to ingest data from into Alli.
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 alerted in the query. 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.