> ## Documentation Index
> Fetch the complete documentation index at: https://docs.summand.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connectors

> Connectors are the typed interface between Summand and wherever your data lives.

A **connector** is the object that owns a connection to a data source. Every dataset belongs to exactly one connector. Connectors hold credentials (managed for you), schema metadata, and the list of tables Summand has discovered.

## Connector kinds

<CardGroup cols={2}>
  <Card title="CSV" icon="file-csv" href="/data-sources/csv-upload">
    A file you upload from your machine. The connector wraps a single file as a single-table source.
  </Card>

  <Card title="PostgreSQL / MySQL / Snowflake" icon="database" href="/data-sources/databases">
    Direct, read-only connections to your warehouse. Tables are discovered at create time and refreshed on demand.
  </Card>

  <Card title="Azure SQL" icon="cloud" href="/data-sources/azure-sql">
    Azure SQL Database and Managed Instance via the standard TDS protocol.
  </Card>

  <Card title="Delta Sharing" icon="diamond" href="/data-sources/delta-sharing">
    Databricks UniForm shares — Iceberg-backed for type-faithful, incremental refresh.
  </Card>

  <Card title="Fivetran" icon="bolt" href="/data-sources/fivetran">
    Managed connection to anything Fivetran supports (Databricks without UniForm, Redshift, Oracle, BigQuery, 300+ SaaS APIs). Summand reads Fivetran's Parquet output.
  </Card>
</CardGroup>

## What a connector stores

| Field                  | Description                                                                                             |
| ---------------------- | ------------------------------------------------------------------------------------------------------- |
| `id`                   | Stable identifier (`con_…`).                                                                            |
| `kind`                 | `csv`, `postgres`, `mysql`, `snowflake`, `fivetran`, or `s3`.                                           |
| `displayName`          | The name you see in the UI. Editable.                                                                   |
| `glueDb` / `glueTable` | Internal: the Glue catalog references for query routing.                                                |
| `visibility`           | `private` (default), `showcase`, or `public`. Inherited by datasets — see [Sharing](/concepts/sharing). |
| `userId`               | The owner. Sharing is granted on top of ownership.                                                      |

Credentials for database connectors live in AWS Secrets Manager — Summand never stores plaintext passwords or keys. For Fivetran, your source credentials never touch Summand servers at all (they go directly to Fivetran).

## Visibility inheritance

If a connector is set to `public` or `showcase`, every dataset under it is readable by anyone (subject to the visibility's content rules — `showcase` blocks raw rows, `public` allows them). Setting the connector back to `private` locks down all datasets at once, regardless of their individual visibility settings. Use this when you need to revoke anonymous access across an entire source quickly.

## When to create a new connector

* **One file per project** — upload as a new CSV connector for clean isolation.
* **One database** — one connector for the whole DB; Summand handles per-table datasets internally.
* **Different credentials** — if two parts of the same database need different access patterns, use two connectors.

## Limits

| Tier            | Connectors                                                                |
| --------------- | ------------------------------------------------------------------------- |
| Free            | CSV only                                                                  |
| Pro / Education | CSV only                                                                  |
| Enterprise      | All kinds — CSV plus the database, Delta Sharing, and Fivetran connectors |