Airtable is an AI-native app platform that enables users to build custom business applications through conversational interactions with its AI assistant, Omni. The platform combines structured data management with AI-powered app generation, allowing users to create production-ready applications by describing what they need in natural language
This sync can be used to upload data in table form with the specified fields from a user specified data warehouse to the Airtable Platform.
Amazon Redshift to Airtable
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a Redshift Warehouse.
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.
*You can fetch data directly from any table / view existing in your warehouse if you don’t want to set up a data model. In that case you can skip this step and directly move to configuring your destination.
3. Configure your Data Destination - Navigate to Reverse ETL tab, click on "All Destinations" and select Airtable.
.png)
.webp)
.svg)
.svg)
