When you connect to the Pricing Data Lake, you connect through Google BigQuery.

Google BigQuery offers many different ways to interact with the data, of which the quickest and most basic way is to explore the data using Google Sheets.

First, navigate to the relevant view under the "DataOcean" section of the pricing data mart. Click on the dataset you want to see, go the "Export" menu on the top and select "Explore with Sheets".



On the connection window that appears, press "Allow", then press "Get Started" to start working with the data.





A more advanced way for those who are familiar with SQL is to create an SQL Query. This approach also allows you to use any filters, joins or aggregations as you see fit.




From there, you can again export the results to various formats (including CSV and Google Sheets), or explore the data live through Google Sheets or Python.



  • No labels