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.
0 Comments
Leave a Reply. |