> ## Documentation index
> Fetch the complete documentation index at: https://docs.prescientai.com/llms.txt
> Use this file to discover all available pages before exploring further. Add `.md` to any page URL to get that page as Markdown.

# Connect a channel

> How an Admin connects the data of a channel in Data Center, with the steps for each connection method and the checks that run on data that you supply.

To connect a channel, open the menu at the end of its row on the **Channels** tab and select **Edit connection**. A dialog opens with setup instructions on the left and the form for the connection method on the right. Follow the form for your method below.

You must be an Admin to connect a channel. The channel must be in the table first. See [Add a channel](https://docs.prescientai.com/data-center/add-a-channel).

## How do you open the setup dialog?

1. Open **Data Center** and stay on the **Channels** tab.

2. Find the channel. A channel that you have not connected has the status **Not connected**.

3. Select the menu at the end of the row, then select **Edit connection**.

The title of the dialog is **Edit** and the name of the channel. A line below the title names the integration that carries the data. Read the setup instructions in the dialog before you fill in the form. The instructions are specific to the channel.

## Which form do you see?

The form depends on the connection method of the channel. You see one of these forms.

**Hosted connect card**

1. Select **Connect**.

   A hosted connect card opens. The card belongs to the service that carries the data, and the **Powered by** column names that service.

2. Sign in to the platform and approve access.

3. Finish the card. You return to Data Center.

For a channel that has a connection, the form shows **Manage**. See [How do you manage a live connection](https://docs.prescientai.com/data-center/connect-a-channel#how-do-you-manage-a-live-connection). For a connection that needs attention, the form shows **Reconnect**.

**Sign in with the provider**

1. Fill in each field that the form shows. Some channels have no field.

2. Select **Connect with&#x20;**. The button has the name of the provider.

3. Sign in at the provider and approve access. You return to Data Center.

For a live connection, the button reads **Reconnect with&#x20;**. For a connection that lost its authorization, the button reads **Reauthorize with&#x20;**.

**Google Sheets**

1. Share the sheet as the setup instructions in the dialog tell you.

2. In the sheet, make a named range that covers your data, with the header row.

3. Paste the address of the sheet in **Google Sheet URL**.

4. Select **Find ranges**.

5. Select the range in **Named range**.

6. Select **Connect**.

Three checks then run on your data. See [What are the checks](https://docs.prescientai.com/data-center/connect-a-channel#what-are-the-checks-on-data-that-you-supply). For a channel with a live connection, the button reads **Update sheet**.

**Warehouse or file location**

BigQuery, Snowflake, SFTP, and Azure Blob Storage use one shared credential for your workspace. An Admin enters the credential one time on the **Integrations** tab. See [Set up shared credentials](https://docs.prescientai.com/data-center/set-up-shared-credentials).

If the integration has no credential yet, the form asks you to connect it first and shows a button such as **Connect BigQuery**. After the credential is connected, give the location of the data of this channel.

1. Open the setup dialog of the channel.

2. Fill in the location fields. The table below lists the fields of each integration.

3. If your workspace has two or more connected accounts, select the account in **Credential**.

4. Select the button of the form: **Save dataset** for BigQuery, **Save table** for Snowflake, or **Save base path** for SFTP and Azure Blob Storage.

Three checks then run on your data. When the channel already has a location, the button reads **Update dataset**, **Update table**, or **Update base path**.

**Snowflake data share**

A Snowflake data share has no shared credential. You give the share in the setup dialog of the channel.

1. Follow the setup instructions in the dialog.

2. Fill in **Account identifier**, **Share name**, **Schema**, and **Table**.

3. Select **Connect**.

Data Center shows **Share connected.** To change the values later, open the dialog again and select **Update share**.

**API key or other credential**

1. Fill in each field that the form shows. The fields depend on the source, and the setup instructions say where to find each value.

2. Select **Connect**.

To change the credential later, open the dialog again and select **Update credentials**. A secret field that you leave blank keeps its stored value.

Some sources need no credentials from you. The dialog then says that your Prescient team will finish the setup.

### Fields for one channel of a shared credential

| Field          | Integration                 | What to enter                                                                                            |
| -------------- | --------------------------- | -------------------------------------------------------------------------------------------------------- |
| **Dataset ID** | BigQuery                    | The dataset that holds the table of this channel.                                                        |
| **Table ID**   | BigQuery                    | The table of this channel.                                                                               |
| **Database**   | Snowflake                   | The database of this channel.                                                                            |
| **Schema**     | Snowflake                   | The schema of this channel.                                                                              |
| **Table**      | Snowflake                   | The table of this channel.                                                                               |
| **Base path**  | SFTP and Azure Blob Storage | The path that holds the files of this channel.                                                           |
| **Credential** | Each shared credential      | Shows when your workspace has two or more connected accounts. Select the account that this channel uses. |

## What are the checks on data that you supply?

When you supply the data from Google Sheets, a warehouse, or a file location, Data Center runs three checks before the channel is connected.

| Step                               | What it checks                                                                                                  |
| ---------------------------------- | --------------------------------------------------------------------------------------------------------------- |
| **Reading your data…**             | Prescient reads the data. The step then reads **Read your data**.                                               |
| **Matching columns…**              | Prescient matches your columns to the columns that the category needs. The step then reads **Columns matched**. |
| **Checking uniqueness & quality…** | Prescient checks for duplicate rows and for values that it cannot use. The step then reads **Data looks good**. |

When each check passes, the dialog shows **Channel validated** and the channel is connected. Select **Done**.

## What if a check does not pass?

- **Your columns have different names.** The dialog shows a mapping form. For each required field, select the column of your data that holds it, then select **Validate with this mapping**. The form fills in its best guess.
- **The data has a problem.** The dialog lists each problem: a value of the wrong type, a blank value in a required column, a duplicate row, or a number with a currency symbol. Correct the source, then select **Re-validate**.
- **The source is empty.** Add data, then validate again.
- **The dialog shows Saved, but not connected.** Your details are saved, but Data Center has no column check for this type of channel from this source, so the channel is not connected. The dialog gives the reason.

For the columns that each type of channel needs, see [Data requirements](https://docs.prescientai.com/reference/data-center/data-requirements).

For the steps in the account of a specific platform, such as how to make a service account or how to share a dataset, see the setup dialog of the channel. The [earlier help center](https://help.prescientai.com/docs/41-connector-setup) also has a page for each platform. For the columns of data that you supply, use [Data requirements](https://docs.prescientai.com/reference/data-center/data-requirements), not the earlier pages. If an earlier page and the setup dialog differ, follow the dialog.

> **You cannot upload a data file:** Data Center has no control to upload a data file. To supply your own data, use Google Sheets, a warehouse, SFTP, or Azure Blob Storage. The only upload control is for the key file of a warehouse credential.

## How do you manage a live connection?

A channel that a hosted connect card carries has a **Manage** menu in its setup dialog after you connect it. Only an Admin can use the items.

The capture shows the **Edit** dialog of a channel with the **Manage** menu open.

![The Edit dialog of a channel with the Manage menu: Edit Settings, Sync now, Re-sync all history, Pause, and Disconnect.](https://docs.prescientai.com/_astro/edit-connection-manage.BiCi5T9V_Z1p9FBT.webp)

| Item                    | What it does                                                                                                                                                                                                                                                                                              |
| ----------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Edit Settings**       | Opens the hosted connect card again, so that you can change the sign-in or the accounts that sync.                                                                                                                                                                                                        |
| **Sync now**            | Starts a sync. Data Center shows **Sync started**, and the status changes to **Syncing**.                                                                                                                                                                                                                 |
| **Re-sync all history** | Reads the full history of the channel again. Data Center shows **Historical resync started**, and the status changes to **Backfilling**.                                                                                                                                                                  |
| **Pause**               | Stops the syncs of the channel until you resume them. Data Center shows **Connection paused**, and the status changes to **Paused**. The item shows for a channel that is not paused.                                                                                                                     |
| **Resume**              | Starts the syncs of a paused channel again. Data Center shows **Connection resumed**, and the status changes to **Connected**. The item shows only for a paused channel.                                                                                                                                  |
| **Disconnect**          | The browser asks you to confirm. The action then deletes the connection at the service that carries the data. Data that is already synced is kept, and syncing stops. Data Center shows **Disconnected**. The channel stays in your list with the status **Not connected**, and you can connect it again. |

A paused channel has the status **Paused** and does not sync. To start the syncs again, open **Edit connection**, select **Manage**, then select **Resume**.

**Disconnect** keeps the channel in your list. To take the channel out of your list, see [Remove a channel](https://docs.prescientai.com/data-center/remove-a-channel).

## How do you send the setup to a colleague?

If a different person holds the login for a platform, send that person a link to the setup dialog. In the menu of the channel row, select **Copy setup link**, then send the link. The person must be an Admin of your workspace to connect the channel.
