Query requirements for setting up a data pipeline to Google BigQuery

For the pipeline to work correctly, the schema of the data you get as a query result must correspond to the data schema of the dataset used for data upload (read more about the types of datasets).

For example, in the dataset schema for "About product" data:

• the productSku field is required
• additionally, you can specify any variations of the following fields: productBrand, productVariant, productCategoryHierarchy, productName, productPrice

Data schema requires to specify keys and imported dimensions and metrics:

All Google Analytics dimensions and metrics have to be written without the ga: prefix in a query:

To import data from Google BigQuery, your query should look as follows:

SELECT productSKU,dimension23,dimension24
FROM ...