Once for a client, i needed updated data from google sheets. So i made the external tables in BQ using these google sheets and then scheduled queries to create a new table (native). After that i used cloud functions to transfrom data from different table and made another tables that had the data required for Dashboard.
Great content, thanks Ajan! What about the ingestion of multiple spreadsheets contained in a drive folder (and if they don't respect the same format)? Thanks for this video, I'll look at the others
Once for a client, i needed updated data from google sheets. So i made the external tables in BQ using these google sheets and then scheduled queries to create a new table (native). After that i used cloud functions to transfrom data from different table and made another tables that had the data required for Dashboard.
I did not thought that it could be so easy! Thank you so much for this video
Hii Sir, please upload videos on ETL using Terraform and GitLab.
Great content, thanks Ajan! What about the ingestion of multiple spreadsheets contained in a drive folder (and if they don't respect the same format)? Thanks for this video, I'll look at the others
Is there any connector for that to just easily schedule it up ?