📎 More BigQuery API Tutorial Videos: th-cam.com/play/PL3JVwFmb_BnRKqcbtl2hHL5GIQOHX-sC5.html 📼 Getting Started With Google BigQuery API: th-cam.com/video/lLPdRRy7dfE/w-d-xo.html 📼 Create a Google Cloud Service Account: th-cam.com/video/gb0bytUGDnQ/w-d-xo.html
I looked for lots of tutorials, but they are not very easy to understand. Your tutorials are very intuitive. It solved my problem right away. Thanks a lot!❤
@@jiejenn I was actually looking for video on "mocking BQ connection in python for testing" and got your video on BQ api ...I thought u might be knowing about mocking ...NP
📎 More BigQuery API Tutorial Videos: th-cam.com/play/PL3JVwFmb_BnRKqcbtl2hHL5GIQOHX-sC5.html
📼 Getting Started With Google BigQuery API: th-cam.com/video/lLPdRRy7dfE/w-d-xo.html
📼 Create a Google Cloud Service Account: th-cam.com/video/gb0bytUGDnQ/w-d-xo.html
I looked for lots of tutorials,
but they are not very easy to understand.
Your tutorials are very intuitive.
It solved my problem right away.
Thanks a lot!❤
How do you output the column names and all the values into google sheet?
It runs blank if the SQL query contains a WHERE date statement. WHERE data_date = '2023-06-19'
How to make it run with a date?
Thank you from South Korea.
Hi, could you please show how to authenticate using oauth token rather service account in same code?
Thank you for your feedback, I will look into it.
@@jiejenn Thks.. If you have some video or documentation to create json oauth token for BigQuery, this help us, very much.
Thanks! I am really interested in how you run only the selected code ! can you show me how please?
well I found your tutorial on the matter :) thanks again
Thank you Jie!
👍
you did a fantastic job. Thank you
What's the process if I want to use an API key instead of the .json?
I don't think that's possible using API key. If you know, do keep us posted.
Love your content...
Keep doing what you are doing...
Is the line os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = '...' relevant and what is the outcome/purpose of this line?
This is needed for the API to load the client file.
very useful, thanks a lot!
Thanks a lot. It works
👍👍👍
thanks very much
Can u make a video on how to mock BQ connection in python ?
Not sure if I follow. Can you be more specific?
@@jiejenn I mean mocking BQ connection for testing
I see. In that case just create a new project or a new account with a new project.
@@jiejenn I was actually looking for video on "mocking BQ connection in python for testing" and got your video on BQ api ...I thought u might be knowing about mocking ...NP