Connect Google Sheets & BigQuery - Connected Sheets
Вставка
- Опубліковано 4 лип 2024
- Support This Channel / chicagocomputerclasses
How to Connect Google Sheets and BigQuery?
In this tutorial we'll use Connected Sheets to get BigQuery data to Google Sheets and then we'll create a live link from BigQuery to access Google Sheets data directly.
00:00 Connect Google Sheets & BigQuery Tutorial
00:20 Pull BigQuery Data to Google Sheets with Connected Sheets
05:59 Use Spreadsheet Parameters in BigQuery SQL Statements
08:22 Use Google Sheets Data in BigQuery
11:52 Query Live Google Sheets Data in BigQuery
BigQuery Tutorial for Beginners • Video
#bigquery #googlesheets #tutorial
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.
Glad to help!
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. 😊
👍
Bro, you're amazing! Thank you so much :DD
The "BigQuery Tutorial for Beginners" linked vid says "This video has been removed for violating UA-cam's policy on harassment and bullying"
is there any way to using importrange with the data source is the connected sheets? or we need to extract the connected first?
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?
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 ?
Yes, you can. You'll have to use BigQuery API.
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 🙏
Good day!, I'm having a hard time converting the datetime column to just date in bigquery. Can you teach me pls.
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
Huh? The data that in the video is from bigquery, sheet is just like easier view of the data
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.
Assuming you're asking about dropdowns/datavalidation, It's not possible.
It's only possible for filters/sort.
@@ExcelGoogleSheets Thanks for the response! Maybe I'll think of another way, but I really do appreciate the response!
Thanks!
Thank You!
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 suppose that depends. The amount of data in BigQuery would definitely not be an issue. Weather you'll be satisfied with speed in general is something for you to decide.
Big query video removed. .. can you share if new video available
Very help full video how to get data Big Query to app script?.
How do we get multiple tabs from a sheet?
❤❤❤
As I understand, when i delete row in spreadsheet its also disappear in BigQuery?
Yes.
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
importxml only work with websites where page is loaded by the server. Unfortunately, more & more websites today move to loading the data on client side with javascript, which means it won't work on a lot of websites.
Is there a possibility to add data from spreadsheets to big query using google app script
Sure, if you have a billing account set up.
Every query to BG is costing money. Is there a way to preview how much data will return before connecting/pulling it into the sheet?
You have like 1TB of free. I'd just do the free trial for a month and see where you are at. Honestly unless you are HUGE, I wouldn't expect to surpass the free tier very quickly.
Is there a cell limit when connecting Google Sheets to BigQuery?
Not if you have a paid account.
What will happen once the Google sheet is hit the limit space?
It won't. It doesn't actually pull the data to Google Sheets, it just gives you a preview. When you do calculations & pivot tables, it does those directly in bigquery and loads only the results of those calculations to your spreadsheet.
The Big Query video is removed 😢
Is it possible to make more than 2 parameters in Google sheets ( list of elements) ?
It won't accept a range, it only accepts a single cell.
You can do more than one parameter.
Why do they allow such an overkill solution for data connectors, big query, and not other google solutions for "small data"?
Is Big Query free with Google?
😊
it is not working
The "BigQuery Tutorial for Beginners" linked video says "This video has been removed for violating UA-cam's policy on harassment and bullying"