---
url: 'https://docs.codatum.com/features/connection/overview.md'
description: >-
  Connection settings for your warehouse, and the unit for running SQL and
  syncing metadata
---

# Connection

A connection manages access to a data warehouse. It uses the credentials you register to run SQL and fetch table information. You can create and edit connections from [global nav](../../guide/screen-layout) > **Workspace settings** > **Data management** > **Connections**. To check synced tables, use the [catalog](../catalog/overview).

## Key features

* Running SQL: Notebooks, reports, and saved queries can all run SQL using the registered credentials.
* Aggregating metadata: [Table metadata sync](../catalog/metadata-sync) syncs table schemas and other metadata to the catalog.
* Permissions: [Access level](#access-level) and resource roles control who can run SQL and retrieve results. For resource role details, see [Connection permissions](../../permissions/resources/connection).
* Supported warehouses: [BigQuery](./warehouses/bigquery) / [Snowflake](./warehouses/snowflake) / [Redshift](./warehouses/redshift) / [Databricks](./warehouses/databricks).
  * Codatum is adding support for more warehouses over time. To request a connection to a warehouse not listed above, contact Codatum support.
* [Demo connection](#demo-connection): A sample connection you can use to try the product before setting up your own warehouse.
* [Job label](./job-label): Metadata that identifies where SQL was issued from (added automatically).

## Creating and managing connections

1. Open [global nav](../../guide/screen-layout) > **Workspace settings** > **Data management** > **Connections**.
2. Select a warehouse from **New connection**.
3. Enter **Connection name**, **Access level**, and the connection settings for the warehouse.
4. Run **Test connect** to verify connectivity, then select **Save**.

The list is split into the following sections.

* **Available connections**: Connections you can use.
* **Restricted Connections**: Connections you don't have access to. If you can edit permissions, select **Edit permissions** to grant access.

The maximum number of connections depends on your contract ([Limits](../../reference/limits#plan-limits)).

## Detail screen

The detail screen lets you check and operate the following.

* **View on catalog**: Opens the [catalog](../catalog/overview) filtered to this connection.
* **General**: Edit the name and connection options (not available for the demo connection).
* **Access level and permissions**: Check and edit the access level and resource roles (not available for the demo connection).
* **Query jobs**: The query job history for this connection (**View history** / **Last run**). This is a separate entry point from the **Query jobs** tab on the table/query detail in the catalog.
* **Table sync settings**: **Last sync job**, **Sync targets**, **Resync Immediately**, and **Sync history**. See [Table metadata sync](../catalog/metadata-sync) for details.
* **Danger zone**: **Delete connection** (also deletes related catalog data and saved queries; not available for the demo connection).

## Demo connection {#demo-connection}

The demo connection is a sample connection you can use to try out Codatum's features.

* You can experience Codatum's features before setting up your own warehouse.
* It includes typical business data (sales, customers, products, and so on).
* You can immediately run SQL against the demo connection when creating a notebook or report.

| Item {.nowrap} | Value |
| --- | --- |
| Connection name | `Demo Connection` |
| Type | BigQuery |
| Access level | Workspace |
| Editing | You can't edit the general settings, sync targets, or access level and permissions |
| Deletion | You can't delete it |

The sync targets are fixed (a sample dataset provided by Codatum and some public BigQuery datasets). You can't change the sync targets manually. You can still run **Resync Immediately**.

## Access level {#access-level}

You select the access level when you create a connection. The default is **Workspace**. **Protected** and **Private** might not be available, depending on your contract. For the meaning of each access level and the operations allowed for each resource role, see [Connection permissions](../../permissions/resources/connection#access-level). You can add up to 3 Connection Owners to a regular connection ([Limits](../../reference/limits#fixed-limits)).