Google Drive

google drive is the robust files storage and productivity solution from google and is part of the google business and google workspace offerings used by millions of users all different types of files can be stored in google drive and synchronized with your desktop and shared equally as easily for enhanced productivity dlh io provides this connector as a direct way to work with data and files mainly as a source to synchronize or load into your cloud data warehouse destination of choice pre requisities access to files in your google drive setup instructions datalakehouse io securely connects to your google drive account that you have access to using the security of google authentication using the form in the datalakehouse io portal please complete the following basic steps enter a name or alias for this connection, in the ' name/alias ' field, that is unique from other connectors enter a ' target schema prefix ', which will be the prefix for the schema at the target you will sync your data files into enter a folder path ,is a path on the root bucket from where desired files will be retrieved file pattern, is a regular expression (regex) used to isolated only certain files to be retrieved file type, allows for a pre determined type of file extension to be retreived enter your service account key , which should be a json string paste the entire service account key (json) if using this bucket as process storage for bigquery, please add this service account email, dlh global bq data sync svc\@stg datalakehouse iam gserviceaccount com , as a principal user on your gcp project and assign it the storage admin role click the save & test button once your credentials are accepted you should be able to see a successful connection control each column data type sql transformations docid 5zjgrvbhtywqw8 olioh0 allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via datalakehouse io (dlh io) this especially helps when you want to control the data type set in your target connection since all columns are set as varchar(16777216) issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com