Connect Google Sheets & BigQuery - Connected Sheets
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
Пікірлер: 51
The "BigQuery Tutorial for Beginners" linked vid says "This video has been removed for violating KZread's policy on harassment and bullying"
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. 😊
@ExcelGoogleSheets
Жыл бұрын
👍
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.
@ExcelGoogleSheets
Жыл бұрын
Glad to help!
Bro, you're amazing! Thank you so much :DD
Thanks sir 🙏
Thanks!
@ExcelGoogleSheets
Жыл бұрын
Thank You!
is there any way to using importrange with the data source is the connected sheets? or we need to extract the connected first?
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?
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?
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.
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 ?
@ExcelGoogleSheets
Жыл бұрын
Yes, you can. You'll have to use BigQuery API.
Good day!, I'm having a hard time converting the datetime column to just date in bigquery. Can you teach me pls.
Big query video removed. .. can you share if new video available
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.
@ExcelGoogleSheets
Жыл бұрын
Assuming you're asking about dropdowns/datavalidation, It's not possible. It's only possible for filters/sort.
@lukeebulo8628
Жыл бұрын
@@ExcelGoogleSheets Thanks for the response! Maybe I'll think of another way, but I really do appreciate the response!
Very help full video how to get data Big Query to app script?.
❤❤❤
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
@nutshell5494
8 ай бұрын
Huh? The data that in the video is from bigquery, sheet is just like easier view of the data
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.
@ExcelGoogleSheets
Жыл бұрын
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.
How do we get multiple tabs from a sheet?
As I understand, when i delete row in spreadsheet its also disappear in BigQuery?
@ExcelGoogleSheets
Жыл бұрын
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
@ExcelGoogleSheets
Жыл бұрын
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.
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?
@FunkyFaulc
Ай бұрын
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 possibility to add data from spreadsheets to big query using google app script
@ExcelGoogleSheets
Жыл бұрын
Sure, if you have a billing account set up.
Is there a cell limit when connecting Google Sheets to BigQuery?
@ExcelGoogleSheets
Жыл бұрын
Not if you have a paid account.
The Big Query video is removed 😢
What will happen once the Google sheet is hit the limit space?
@ExcelGoogleSheets
Жыл бұрын
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.
Is it possible to make more than 2 parameters in Google sheets ( list of elements) ?
@ExcelGoogleSheets
Жыл бұрын
It won't accept a range, it only accepts a single cell.
@ExcelGoogleSheets
Жыл бұрын
You can do more than one parameter.
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"?
it is not working
The "BigQuery Tutorial for Beginners" linked video says "This video has been removed for violating KZread's policy on harassment and bullying"