Skip to main content
The SQL integration allows you to connect directly to SQL databases, enabling you to fetch data from tables or custom queries, and perform CRUD operations on your data.

​
Authentication

SQL connections are configured through your warehouse connections (Snowflake, BigQuery, or Redshift). No additional authentication is required.

​
SQL actions

​
Search records

Retrieve multiple records from a table with filtering and sorting. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
FilterDefine filter conditions
SortSort results
LimitMaximum records to retrieve (default: 100)

​
Insert record

Insert a new record into a table. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
MappingsMap column values

​
Update records

Update existing records in a table. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
Matching ValueValue to match against
Matching columnColumn to match on
MappingsMap columns to update

​
Upsert records

Insert or update records based on a matching column. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
Matching ValueValue to match against
Matching columnColumn to match on
MappingsMap column values

​
Delete records

Delete records from a table. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
Matching ValueValue to match against
Matching columnColumn to match on
Delete operations are permanent. Ensure you have proper filters configured.

​
Data models

​
Fetch table

Create data models directly from database tables. Configuration
FieldDescription
DatabaseThe database name
SchemaThe schema name
TableThe table name
IDColumn containing unique record IDs
TitleColumn containing record display titles

​
Fetch query

Create data models from custom SQL queries. Configuration
FieldDescription
SQLThe SQL query to execute
IDColumn containing unique record IDs
TitleColumn containing record display titles
Use fetch query for complex joins, aggregations, or filtered views of your data.

​
Best practices

  1. Index your columns - Ensure columns used in filters and joins are properly indexed
  2. Limit result sets - Always use appropriate limits to avoid pulling excessive data
  3. Use views for complex queries - Consider creating database views for frequently used complex queries