![]() Wrote documentation for the end-user and for the ease of knowledge transfer using a Confluence Wiki.Assisted in the logic construction for the finance and data analytics teams through the Looker BI Tool.Prepared prior to the launch of the new 2.0 website then configured and updated as new development occured.Built, improved, and maintained the Virtual Data Warehouse following the Kimball method using Dim and fact tables in a star schema style.Worked closely with Data Virtuality support while the new tool continued to grow.Became the resident expert of two new tools (Data Virtuality and DBeaver).Learned proprietary SQL language by Data Virtuality modeled similarly to PostgreSQL.Determined how to parse JSON for ingestion of GA data.Utilized Data Virtuality ETL for a compilation of multiple data sources including Amazon Redshift, NetSuite, PostgreSQL, Google Analytics (GA), Facebook, and CSV files.Open Postman and send a POST request to Google OAuth Token endpoint to exchange your ClientID, Client Secret and Authorization Code for Access Token and Refresh Token.This is the last step before we can access data in Google BigQuery using Progress DataDirect BigQuery JDBC connector. With the Authorization Code in our hands, it’s time to get the Access and Refresh Tokens.We should now see a page with an authorization code in it as shown below.Now we should see another window asking for confirmation if we want to allow our OAuth Client access to our BigQuery data.Click on Advanced and you should see another option Go to. We should now see a warning if our app isn’t verified.As soon as you choose your account, you will see a pop up asking if you want to grant access.After you have replaced the ClientID in your URL, copy it and paste the URL into your browser.&redirect_uri=urn:ietf:wg:oauth:2.0:oob&state=GBQAUthTest&access_type=offline&scope= To do this, copy this URL to your notepad and replace clientid with the Client ID we got in the above step.With ClientID and Client Secret in hand, we are ready to make an authorization request to Google to get the Authorization code.We should now see a new popup with our ClientID and Client Secret.Choose Other, provide a name and click Create. Now we should see a screen like below asking for our application type.Go to Credentials tab, click on Create Credentials, choose OAuth Client ID.Below is an example of the consent screen for your reference –.Application Privacy Policy Link: Your Privacy policy.Application HomePage: Any public facing website.Authorized Domains: Any public facing website.Support Email: Your Email/ Support EmailĪdd Scope -> BigQuery API.Application Name: Your Application Name.Go to the tab OAuth Consent Screen, and fill in the details for your OAuth Client:.To Register a new OAuth ClientID, go to Google Developer Console and login.Exchange the Authorization Code to get the Access Token and Refresh Token by sending a Token request to Google.Send an Authorization request to Google to get the Authorization Code. ![]() ![]() Create an OAuth ClientID to get ClientID and Client Secret.To get the Access Token and Refresh token, we need to:.We need two pieces of information to access Google BigQuery data using the Progress DataDirect Google BigQuery JDBC Connector – Access Token and Refresh Token.OAuth2.0 is another authentication we can use to access our Google BigQuery data from Progress DataDirect Google BigQuery Connector. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |