Adding a database connection to a project

Database connections require an Enterprise license.

Your external database must allow connections from the Fabricate IP addresses.

A Live Connect database connection is a live connection to an external database. After you establish the connection, to add data to the database, you prompt the Data Agent.

Supported database platforms

Database connections can connect to the following databases:

• Amazon Redshift
• Google BigQuery
• Microsoft Fabric
• MySQL
• Oracle
• PostgreSQL
• Snowflake
• SQL Server

Defining a database connection

To add a database connection to a project, in the navigation panel, click Connect external database.

Option to connect to an external database

Selecting or creating the server connection

From the Server dropdown list, select the server connection option. You can add a new server connection, or select an existing workspace server connection.

Server dropdown to select whether to create a new server connection

The default option is Enter connection details. With this option, you provide the server connection information directly on the database connection panel. When you use this option to configure the server connection, the server connection is only used for the database connection. It is not added to the workspace list of server connections.

To create a new server connection that is added to the workspace list, select Add a new workspace server. Fabricate displays the New Server Connection panel to define the new workspace server connection.

For information about the configuration fields for server connections, go to Configuring available server connections for a workspace.

To use an existing workspace server connection, select it from the list.

Identifying the database

After you select the server connection, you identify the specific database to connect to on the server connection.

Platforms other than Google BigQuery or Microsoft Fabric

For platforms other than Google BigQuery or Microsoft Fabric, in the Database field, provide the name of the database.

Google BigQuery

For Google BigQuery, in the Dataset field, provide the name of the dataset to connect to.

Microsoft Fabric

For Microsoft Fabric:

1. From the Lakehouse dropdown list, select the lakehouse that contains the data.
2. Optionally, in the Schema field, provide the schema to use.

   If the lakehouse contains a schema, then Fabricate automatically detects it and populates the field.

   If the lakehouse data does not contain a schema, then leave the field empty.

Providing a name to use to refer to the database connection

In the Name in Fabricate field, provide a name to use to refer to the database in the Data Agent chat.

Testing and saving the connection

1. To test the connection to the database, click Test Connection.
2. To save the database connection, click Connect database.