Datasource Setup Guides ​

Detailed guides for connecting your data sources to Kyomi.

Cloud Data Warehouses ​

DatasourceAuth MethodsKey Features
Google BigQueryOAuth, Service Account, Enterprise OAuthGoogle Cloud, petabyte-scale analytics
SnowflakePassword, OAuth, Key PairMulti-cloud, data sharing
Amazon RedshiftPasswordAWS native, Spectrum for S3
DatabricksPersonal Access TokenUnity Catalog, Delta Lake
Azure SynapseSQL AuthDedicated & serverless pools

Relational Databases ​

DatasourceDefault PortKey Features
PostgreSQL5432Open source, extensive SQL support
MySQL3306Widely used, MariaDB compatible
SQL Server1433Microsoft, Azure SQL compatible
ClickHouse8123Column-oriented, real-time analytics

Quick Comparison ​

Authentication Methods ​

DatasourcePasswordOAuthTokenKey PairService Account
BigQuery-✓--✓
Snowflake✓✓-✓-
PostgreSQL✓----
MySQL✓----
ClickHouse✓----
SQL Server✓----
Redshift✓----
Databricks--✓--
Synapse✓----

Features ​

DatasourceSSH TunnelShared CredentialsCatalog Discovery
BigQuery-✓ (Service Account)✓
Snowflake-✓✓
PostgreSQL✓✓✓
MySQL✓✓✓
ClickHouse✓✓✓
SQL Server✓✓✓
Redshift✓✓✓
Databricks-✓✓
Synapse-✓✓

Common Setup Steps ​

All datasources follow a similar setup pattern:

  1. Add Datasource: Go to Settings → Datasources → Add Datasource
  2. Select Type: Choose your datasource type from the dropdown
  3. Configure Connection: Enter host, port, and connection details
  4. Test Connection: Click Connect to verify connectivity
  5. Set Credentials: Enter authentication credentials
  6. Configure Catalog: Select which databases/schemas to index
  7. Save: Save the configuration

Need Help? ​

← Back to Docs