汎用 SQL をナレッジベースに接続する

汎用 SQL コネクタを使用すると、接続文字列を使用して Snowflake、Postgres、Redshift、およびその他の SQL データベースに接続できます。データベースに専用のコネクタ タイルがない場合は、このコネクタを使用します。

汎用 SQL への接続

1. Open Project Settings

   In your EKB project, navigate to Settings in the sidebar.

2. Go to Connections

   Select the Connections tab and find the Generic SQL tile under Databases.

3. 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.

4. Fill in the connection form

   Enter the following details:

   Server

   Field	Required	Description
   Connection Name	Yes	A display name for this connection (e.g. PLACEHOLDER_0).
   Connect String	Yes	The connection string for your database (e.g. PLACEHOLDER_1).

   Database

   Field	Required	Description
   Tables	Yes	The tables to index. Enter each table name separated by a comma.

5. 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.

✓You're now ready to use your database in the Knowledge Base!