Skip to main content
This page describes the schema used for data source connections, including all fields, types, and enums.

Connection

id
ID!
required
Unique identifier for the connection.
details
ConnectionDetails!
required
Configuration and metadata for the connection. See ConnectionDetails.
status
JobHistory!
required
Job execution history for connection operations like metadata refresh. See JobStatus.
createdAt
DateTime!
required
Timestamp when the connection was created.

ConnectionDetails

name
String!
required
Human-readable name for the connection.
description
String!
required
Description of the connection and its purpose.
dataSourceType
DataSourceType!
required
The category of data source. See DataSourceType.
connectionType
ConnectionType!
required
The specific type of data source connection. See ConnectionType.
dialect
String!
required
The SQL dialect used by this connection.

Enums

DataSourceType

The category of data source. It accepts the following values:
Data Source TypeDescription
DATA_SOURCE_TYPE_UNSPECIFIEDType not specified
WAREHOUSEData warehouse (Snowflake, BigQuery, Redshift, etc.)
BI_TOOLBusiness intelligence tool (Tableau, etc.)
FILEFile-based data source (S3, Azure Blob Storage, etc.)
DATA_SOURCE_MCP_SERVERMCP server data source

ConnectionType

The specific type of data source connection. It accepts the following values:
Connection TypeDescription
CONNECTION_TYPE_UNSPECIFIEDType not specified
REDSHIFTAmazon Redshift data warehouse
SNOWFLAKESnowflake data warehouse
TABLEAUTableau business intelligence platform
BIGQUERYGoogle BigQuery data warehouse
POSTGRESPostgreSQL database
SQL_SERVERMicrosoft SQL Server database
DATABRICKSDatabricks analytics platform
MYSQLMySQL database
CLICKHOUSEClickHouse database
ATHENAAmazon Athena query service
S3Amazon S3 file storage
MCP_SERVERMCP server connection
AZURE_SYNAPSEAzure Synapse Analytics
AZURE_BLOB_STORAGEAzure Blob Storage
TRINOTrino distributed SQL query engine
AZURE_SYNAPSE_SERVERLESSAzure Synapse Analytics Serverless
SHAREPOINTMicrosoft SharePoint
SPANNERGoogle Cloud Spanner
TERADATATeradata database
DUCKDBDuckDB embedded database

Connection Queries

Query connection information and status

JobStatus Schema

Learn about job execution status tracking

Refresh Connection

Trigger connection metadata refresh

Domain Objects

Understand domain and table management