1. Preparation
Have activated the BigQuery service on the Google Cloud platform and have the corresponding Google account.
2. Share dataset
Please contact us for the link to the shared dataset.
Receive and click on the sharing link. For example, I have shared the dataset (108132) from the project (dealmap-298306).
In BigQuery Studio, you will be able to view the shared dataset, as shown in the following figure, which includes tables (all-channel-channel).
3. Preview tables
Click on the three vertical dots on the table (all-channel-channel) to expand the detailed information of the table. Here, you can view the structure of the table and preview the data of the table.
4. View table query template
Please contact us for the link to the shared table query template. Receive and click on the sharing link.
In BigQuery Studio, you will be able to view the shared table query template, as shown in the following figure.
After modifying the relevant parameters, execute to query the contents of the dataset table.For example, time range for querying data。