Imports data from a file from Google Drive.
Before you can download data from Google Drive you have to give acces. There are two ways to do this:
Take the steps below to download a Google Spreadsheet with a service account.
conn_id
client_email
from the Service Account `Read` access to the Google spreadsheetTake the steps below to download a Google Spreadsheet with a delegated account. Please take note of the security precautions needed to secure this connection method.
To retrieve the file ID do the following:
https://docs.google.com/spreadsheets/d/1orAc9s3DWu5_G5m3UGxuf9ibMh2P7rrmirNoT-Iw_pI/edit?usp=sharing
extract:
file_id: 1orAc9s3DWu5_G5m3UGxuf9ibMh2P7rrmirNoT-Iw_pI
property | type | required | description |
---|---|---|---|
file_id | string | yes | Contains the file id. |
conn_id | string | no | Connection string as handed to you by the Onesecondbefore team. If your cloud is Google Cloud, the conn_id is not obliged. It will take the client_cloud.db_conn_id. |
delegated_account | string | no | Delegated account to use to download the content of the Google Drive spreadsheet. |
item | description |
---|---|
API | Google Drive API |
Pre-formatted schema | No. This from task does not come with a pre-formatted schema. Do not define file and only define schema
if you use Snowflake. BigQuery can auto-detect the source file.
|