Skip to main content

​
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 (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

1

Open Snowflake connector

In the Hymalaia Admin Panel, open the Snowflake connector.
2

Configure authorization

In Step 1, set up credentials:
  • Select an existing Snowflake credential, or click Create New
  • Enter Account, User, Password, and Warehouse
3

Save configuration

Click Create (or equivalent) to save the credential configuration.
4

Continue with selected credential

Ensure the correct credential is selected, then click Continue.
5

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
6

Create connector

Click Create Connector to start indexing.
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.