Skip to main content

Create Connection

Connect ekai to your data warehouse to begin the Schema Agents workflow. ekai establishes a secure, read-only connection to profile your data and generate ERDs.

Add a New Connection​

  1. Navigate to Schema Agents in the sidebar
  2. Click the + Add Data Connection button
Data connection type selector

Select Your Platform​

Choose your data warehouse platform:

PlatformStatusAuthentication
Snowflake✅ AvailableUser/Password, OAuth
Databricks✅ AvailablePersonal Access Token
Google BigQuery✅ AvailableService Account JSON
Azure Synapse✅ AvailableSQL Auth, Azure AD
PostgreSQL✅ AvailableUser/Password, SSL

Connection Details​

Snowflake connection form

Required Fields:

FieldDescription
NameFriendly name for this connection
Authentication TypeUser PAT or OAuth
User NameSnowflake username
PasswordSnowflake password
DATABASETarget database name
SCHEMAComma-separated list of schemas (case-sensitive)
RoleSnowflake role with read access

Optional Fields:

  • Account: Leave blank if connecting within Snowflake Native App
  • WAREHOUSE: Leave blank to use default EKAI_APP_WAREHOUSE
Schema Format

Enter schemas as a comma-separated list: schema1, schema2, schema3

Select Tables​

After entering connection details, ekai reads your schema and presents available tables:

Table selection dialog
  1. Select All — Include all tables in analysis
  2. Choose specific tables — Select individual tables
  3. Click Next to proceed to onboarding
Managing LLM Token Usage

LLM token consumption scales with the number of tables and columns in your connection. To reduce costs, consider limiting your selection to only the tables needed for your specific use case. For most workflows, under 100 tables provides optimal cost efficiency.

Connection Established​

Your connection appears in the Schema Agents list:

Connection list with established connection

The list shows:

  • Name — Connection identifier (click to open)
  • Type — Source platform
  • Last Updated — Most recent activity
  • Created At — When connection was created

Connection Security​

All connections are read-only with TLS 1.3 encryption. Raw data never leaves your warehouse—only statistical summaries are transferred.

See Security & Privacy for complete details.

Managing Connections​

Edit Connection​

Click on a connection name to view details. Update credentials or table selections as needed.

Delete Connection​

From the connection list, select the delete action to remove a connection. This does not delete generated ERDs.

Share Connection​

Use the Share button to give other users access to this connection.

Next Steps​