Getting Started With Google BigQuery API In Python

[@jiejenn]

📎 More BigQuery API Tutorial Videos: kzbin.info/aero/PL3JVwFmb_BnRKqcbtl2hHL5GIQOHX-sC5 📼 Getting Started With Google BigQuery API: kzbin.info/www/bejne/on2zlYWIrpyXnKc 📼 Create a Google Cloud Service Account: kzbin.info/www/bejne/nZOTk6yqiqx3pLM

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

[@AleeEnt863]

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

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

Thank you from South Korea.

[@classictablet9149]

you did a fantastic job. Thank you

[@connor-shorten]

Thank you Jie!

[@jiejenn]

👍

[@Notigam]

very useful, thanks a lot!

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

[@agby14]

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

[@javierlarramona5923]

Thanks a lot. It works

[@jiejenn]

👍👍👍

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

[@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'`

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

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

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

[@indroda2..uniqueinnovative900]

thanks very much

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