When you connect to the Pricing Data Lake, you connect through Google BigQuery.In order to see what's in a particular dataset, you need to query
the datasetGoogle 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 dataset view under the "DataOcean" section of the pricing data mart and create a new Query, either in a new tab or in split tab.
. 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.
Next, complete the SQL query to consult the dataset.
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.
...