Getting Started With Google BigQuery API In Python

[@jiejenn]

📎 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

[@ika2686]

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!❤

[@이호준플랫폼기획본부]

Thank you from South Korea.

[@prakash123kumar]

It is a very easy and best example.. thanks for sharing
I am looing for another way where auth login use to login and download data.. can you share the knowlege if you have any

[@omarfessi2761]

Thanks! I am really interested in how you run only the selected code ! can you show me how please?

[@omarfessi2761]

well I found your tutorial on the matter :) thanks again

[@AleeEnt863]

Love your content...
Keep doing what you are doing...

[@classictablet9149]

you did a fantastic job. Thank you

[@agby14]

How do you output the column names and all the values into google sheet?

[@prasannasalicham8878]

Hi, could you please show how to authenticate using oauth token rather service account in same code?

[@jiejenn]

Thank you for your feedback, I will look into it.

[@jmsolorzano13]

@@jiejenn Thks.. If you have some video or documentation to create json oauth token for BigQuery, this help us, very much.

[@NabeelButt]

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?

[@connor-shorten]

Thank you Jie!

[@jiejenn]

👍

[@prakash123kumar]

Could you please also suggest how to allow login user using authenticate login

[@TaylorShort-c4s]

When I run the code I get `ModuleNotFoundError: No module named 'google'`

[@Notigam]

very useful, thanks a lot!

[@pizzepeli]

What's the process if I want to use an API key instead of the .json?

[@jiejenn]

I don't think that's possible using API key. If you know, do keep us posted.

[@vino_09]

Is the line os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = '...' relevant and what is the outcome/purpose of this line?

[@jiejenn]

This is needed for the API to load the client file.

[@javierlarramona5923]

Thanks a lot. It works

[@jiejenn]

👍👍👍

[@akshanshbhandari7619]

Can u make a video on how to mock BQ connection in python ?

[@jiejenn]

Not sure if I follow. Can you be more specific?

[@akshanshbhandari7619]

@@jiejenn I mean mocking BQ connection for testing

[@jiejenn]

I see. In that case just create a new project or a new account with a new project.

[@akshanshbhandari7619]

@@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

[@indroda2..uniqueinnovative900]

thanks very much