Connect Google Sheets & BigQuery - Connected Sheets

Is Big Query free with Google?
😊

Why do they allow such an overkill solution for data connectors, big query, and not other google solutions for "small data"?

Hi there, thanks for the video. I was trying to access your BigQuery for beginners video but the link is down. Do you have an updated link?

The Big Query video is removed 😢

Hi sir, loved this video.. could you please upload a video regarding how to write data from a Google sheet to big query database using apps script?

How to make sure that bigQuery will detect the right data types in the schema when connecting a google sheet?
Because I got that error, I have a column that should be a string and every time I connect this sheet with bigQuery it's identified in the schema as Integer, however I made sure to modify the data type of this column in the original google sheet as text, but this didn't work.

Thanks sir 🙏

Very help full video how to get data Big Query to app script?.

is there any way to using importrange with the data source is the connected sheets? or we need to extract the connected first?

Thanks!

nice video! however i don't understand the point of importing/connecting a google sheet into bigquery if the loading speed is super slow as well. Do you know how i can synchronize a google sheet with bigquery? but the data has to actually be in bigquery because i want fast reports and not suuper super slow

Good day!, I'm having a hard time converting the datetime column to just date in bigquery. Can you teach me pls.

How do we get multiple tabs from a sheet?

Is there a possibility to add data from spreadsheets to big query using google app script

Thank you for sharing. I would also like to ask if you have a video where we can let multiple user toggle a "drop down" for a specific category, without it changing the data on other users end (same sheet)? I'm a beginner at this. I hope this is possible.

Have you considered doing a tutorial on the ChatGPT extension for Google Sheets and Docs? I have enabled the extension in my Google Sheets but I’m looking for some inspiration on good ways to use it. Thanks in advance.

can i contact you on telegram to asking about goigle sheet?

I wonder would using Apps Script with BigQuery will help with performance? I've been using Google Sheet to store data for webapp but in some cases, it was slow. I saw that App Script has API connecting to Bigquery but I have never tried it.

I used importxml to get data from web but some case the command error like ‘could not fetch url’. How to solve it. Thanks advance

Is there a cell limit when connecting Google Sheets to BigQuery?

Having worked in IT using SQL for more years than I care to remember, I've wanted something more than the QUERY function that Sheets offers. This tutorial shed light on a realistic approach to utilize the power of SQL with Sheets I plan to use. Thanks so much for all your training videos. I always look forward to notifications for new content. 😊

My lord and savior has done it again. Thankyou for your work master.

Is it possible to make more than 2 parameters in Google sheets ( list of elements) ?

Thank you! This is - as always - very helpful. I've been watching your tutorials religiously for the past 5-6 years and I'm not overstating when I say they've changed my whole (work) life.

As I understand, when i delete row in spreadsheet its also disappear in BigQuery?

Very useful , thanks for sharing, can I use a direct conection to load the table with a google webapp using a datatable ? or I need to link first to a spreadsheet the table ?

What will happen once the Google sheet is hit the limit space?