Steps for Configuring a BigQuery Data Pipeline
To configure a BigQuery data pipeline with Intentwise Analytics Cloud, follow these steps:
Sign in to your Google console at https://console.cloud.google.com
In the top-left corner, click Menu > IAM & Admin > Create a Project
Now, enter the project name, choose the organization & location, and click Create. Project Name and Location can be of your choice
In the newly created project, under IAM & Admin > IAM, click on Grant Access to add a new user
Note: Please ensure that you are selecting the newly created project from the top dropdown
Provide grant access to the project by adding the following as shown in the screenshot below:
Principal (User):
869780223921-fkm5hu2ev8la67tqrntm6b5tjm6c6sgl@developer.gserviceaccount.com
The roles can be found under By Product or Service > BigQuery in the role dropdown
โNavigate to the BigQuery page. Choose the newly created project and create datasets as mentioned below:
amazon_source_data
intentwise_ecommerce_graph
amazon_marketing_cloud (recommended if you are currently using or intend to use Amazon Marketing Cloud)
criteo_source_data (recommended if you are currently using or intend to use Criteo)
instacart_source_data (recommended if you are currently using or intend to use Instacart)
walmart_source_data (recommended if you are currently using or intend to use Walmart)
You can add the datasets under Explorer and clicking on the three vertical dots icon against the newly created project
Now, login to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on "+ Add Destination", choose Big Query as the destination and click Next.
Enter the Project ID and the Location in the next window and click on Save.
You can get the Project ID and Location from the Explorer, by clicking on the three vertical dots icon against the dataset and then choosing the option "Open"
On successful completion, you will see this message:
For any further questions on the pipeline setup, please reach out to us on chat or at [email protected].