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

# Snowflake Connector

> Index Snowflake table metadata (DDL) in Hymalaia

## How it works

The Snowflake connector indexes **table metadata** for a given database and schema: it discovers tables via `INFORMATION_SCHEMA` and stores each table’s **DDL** (structure) as a searchable document. It does **not** index row-level table data.

On each run, tables whose definition has changed (based on Snowflake’s `LAST_DDL` in the configured schema) are refreshed. Like other connectors, indexing typically runs on a **daily** schedule.

## Setting up

### Authorization

Snowflake uses **username and password** authentication against your Snowflake account. Create a credential with:

* **Account** — your Snowflake [account identifier](https://docs.snowflake.com/en/user-guide/admin-account-identifier) (e.g. `xy12345` or `xy12345.us-east-1.aws`)
* **User** — Snowflake login name for the role you want to use
* **Password** — password for that user
* **Warehouse** — a warehouse the user is allowed to use (the connector runs metadata queries through it)

Use a dedicated user with least privilege (ability to read metadata and run `GET_DDL` / `INFORMATION_SCHEMA` in the target database and schema).

### Indexing

<Steps>
  <Step title="Open Snowflake connector">
    In the Hymalaia Admin Panel, open the **Snowflake** connector.
  </Step>

  <Step title="Configure authorization">
    In **Step 1**, set up credentials:

    * Select an existing Snowflake credential, or click **Create New**
    * Enter **Account**, **User**, **Password**, and **Warehouse**
  </Step>

  <Step title="Save configuration">
    Click **Create** (or equivalent) to save the credential configuration.
  </Step>

  <Step title="Continue with selected credential">
    Ensure the correct credential is selected, then click **Continue**.
  </Step>

  <Step title="Specify database and schema">
    In **Step 2**, specify:

    * **Connector Name** — a display name for this connector (e.g. `Analytics DWH`)
    * **Database** — the Snowflake database to index
    * **Schema** — the schema within that database (e.g. `PUBLIC` or your analytics schema)
    * **Access Type** — whether indexed content is **Public** or **Private** in Hymalaia
  </Step>

  <Step title="Create connector">
    Click **Create Connector** to start indexing.
  </Step>
</Steps>

The connector will index table DDL for the configured database and schema. Add another connector (or credential) if you need additional databases or schemas.

For more on Snowflake objects and identifiers, see the [Snowflake documentation](https://docs.snowflake.com/).