.png)
Amazon Redshift is one of the most popular, scalable, easy to manage data warehouse options for those wanting to setup a Data Warehouse on the cloud. Read more about the features and how to get started with the popular platform from AWS here.
This sync can be used to load data from your data warehouse into Redshift platform.
BigQuery to Amazon Redshift
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a BigQuery Warehouse.
*To understand how to add a BigQuery Data Warehouse check out this video.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
3. Configure your Data Destination - Navigate to Destinations tab and select Amazon Redshift.
.svg)
