Connect Generic SQL to the Knowledge Base
With the Generic SQL connector, you can connect to Snowflake, Postgres, Redshift, and other SQL databases using a connection string. Use this connector when there is no dedicated connector tile for your database.
For Snowflake, including sign-in with Microsoft Entra ID, see Connect Snowflake to the Knowledge Base.
Authentication is part of the connection string. For most databases, such as Postgres and Redshift, include the username and password in the string. Snowflake can also use OAuth (client credentials), with the OAuth parameters set in the connection string.
Connecting to Generic SQL
Open Project Settings
In your EKB project, navigate to Settings in the sidebar.
Go to Connections
Select the Connections tab and find the Generic SQL tile under Databases.
Open the Generic SQL popup
Click the Generic SQL tile. A popup appears with the option to connect to Snowflake or other SQL databases. Click + Add Connection.
Fill in the connection form
Enter the following details:
Server
Field Required Description Connection Name Yes A display name for this connection (e.g. My Generic Connection).Connect String Yes The connection string for your database (e.g. sqlite:///:memory:). For Snowflake formats, see Connect Snowflake.Database
Field Required Description Tables Yes The tables to index. Enter each table name separated by a comma. Save the connection
Click Save. EKB will authenticate using the details provided. If successful, the Generic SQL tile on the Connections page will display a green dot and a count of your active Generic SQL connections.