But during my time in Rackspace, where I encountered some of the use cases in my project by which maybe I have forgotten the official \u201cdefinition\u201d, but I will remember the actual use of this<\/p>\n
So where we can use BigQuery:<\/strong><\/p>\n Those two things I learned in terms of our project perspective and this list will continue.<\/p>\n Let’s see what options we can explore in terms of querying the data outside the GCP environment.<\/strong> \u201cIntelligence is the ability to adapt to change.\u201d <\/strong>\u2013 Stephen Hawking<\/strong><\/p>\n REST API Method<\/strong><\/p>\n This is a very popular method and the main advantage of this method is, you don\u2019t need to give admin\/owner level access.<\/p>\n Let’s see it\u2019s implementation and testing. We need only a postman application for the testing.<\/p>\n Create OAuth Credentials<\/strong><\/p>\n We will use Google uses OAuth 2.0 protocol for authentication and authorization. You will need a valid or approved key to access to the system and send requests to the BigQuery streaming endpoints. We need to avail the OAuth authorization framework 2.0 and retrieve the credentials of the client from the Google Cloud API.<\/p>\n Login to the GCP console and after that navigate to APIs & Services. Then enable the BigQuery API.<\/p>\n Then go to \u201cCredential\u201d option and Create an OAuth 2.0 Client IDs<\/p>\n Please see the below configuration.<\/p>\n Source URL<\/a><\/p>\n This will create OAuth ID. Save these credentials (JSON) in your machine. We will use these credentials in Postman to generate a token for every request to the BigQuery streaming API.<\/p>\n Now our task is done in GCP Console. Let’s open the Postman application<\/p>\n Generating Token in Postman<\/strong><\/p>\n In the authorization section, click on \u201ctype\u201d and select OAuth 2.0<\/p>\n Now Configure the following parameters: <\/p>\n Then click the \u201cGet New Access Token\u201d<\/p>\n This will take you to Google cloud console page for login and authentication. Enter your credentials. An access token will be generated and you will be redirected to the Postman. Click on \u201cuse token\u201d<\/p>\n Navigate to \u201cHeaders\u201d section and enter \u201cContent-Type\u201d in Key and \u201capplication\/json\u201d in Value.<\/p>\n Navigate to \u201cBody\u201d section and enter the JSON request body. You will construct the body with the data to be sent to BigQuery.<\/p>\n Result in BigQuery<\/p>\n Now Let\u2019s talk about method 2:<\/strong><\/p>\n Python BigQuery Library:<\/strong><\/p>\n Prerequisite \u2013 Before setting the environment you need to install the following package in the python environment.<\/strong><\/p>\n pip install –upgrade google-cloud-bigquery<\/em><\/p>\n The first step is to set up authentication to run client library.One way to do that is to create a service account and set an environment variable. Create a service account key<\/strong>:<\/p>\n 1. Now go to the GCP console and select email address that you registered for service account you created. You can store this key in GCS Bucket or Passwordsafe Project. It will be needed for authentication.<\/em><\/p>\n For Example :<\/em><\/p>\n I created one table in BigQuery for testing<\/p>\n Now please find the below python code for reference.<\/p>\n Result :<\/p>\n Pros and Cons of Three Methods<\/strong><\/p>\n REST API<\/strong><\/p>\n Python Client<\/strong><\/p>\n Conclusion<\/strong><\/p>\n Those methods have their pros and cons, and it is perfectly synchronized with their use cases.<\/p>\n JDBC and ODBC Driver<\/em><\/p>\n This discussion is out of this scope, as this method is mainly used to connect any application like Tableau, QlikSense, etc. to BigQuery.<\/p>\n","protected":false},"excerpt":{"rendered":" BigQuery APIs Reference<\/p>\n","protected":false},"author":2,"featured_media":7085,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26249","content_type":"blog","created_by":"10130","authored_on":"2023-11-16T17:22:18+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rahul Chatterjee, Site Reliability Engineer, Rackspace Technology","seo_description":"Explore data querying beyond GCP with three methods: REST API, Python BigQuery Library, and ODBC\/JDBC Driver for BigQuery.","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26249-insights_image-google-cloud-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Google Cloud Data","product":"","publisheddate":"2022-09-28T16:22:18","rxt_solutions":"Multicloud","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"BigQuery APIs Reference | Rackspace Technology","field_topics":"","field_slug":"bigquery-apis-reference","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7083","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=7083"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7083\/revisions"}],"predecessor-version":[{"id":8936,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7083\/revisions\/8936"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/7085"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=7083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=7083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=7083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
\nThere are three methods to do that:<\/p>\n\n
![\"BigQuery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture2_12.png\")
<\/p>\n![\"Big](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture2_11.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture3_13.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture4_12.png\")
<\/p>\n\n
![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture5_12.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture6_7.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture7_7.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture8_6.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture9_6.png\")
<\/p>\n
\n1. In the cloud console, navigate to the \u201cCreate service account\u201d page In the GCP Console option , go to the Create service account page.
\n2. Select the project on which you are working.
\n3. Enter a logical name in the Service account name field. Basically the Service account ID field is populated by Google Cloud Console.
\n4. There will a field named \u201cservice account description\u201d, enter your required description there.
\n5. For example, \u201cService account\u201d.
\n6. Then click Create and continue.
\n7. We need to provide access to the project. So, you need to grant the following role(s) to the mentioned \u201cservice account\u201d such as Project > Owner.
\n8. There will be a field named \u201cselect a role\u201d, you can carry out your selection of roles from there.
\n9. For adding roles to the list, click on \u201cAdd another role\u201d.
\n10. Click \u201cDone\u201d button to finish creating the service account.
\n11. Do not hit the close button of your Browser\u2019s window, we will be needing this in the next step. Now create a \u201cService account key\u201d<\/p>\n
\n2. Click on \u201ckeys\u201d, then \u201cadd key\u201d and then select the \u201cCreate new key\u201d option.
\n3. Now select the \u201ccreate\u201d option and this will lead to the download of JSON key file in your computer or local machine.
\n4. Click Close.<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture10_5.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture11_5.png\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture12_0.PNG\")
<\/p>\n![\"bigquery](\"\/wp-content\/uploads\/2026\/blog_article_images\/26249-body-Picture13_4.png\")
<\/p>\n\n
\n