Snowflake data contract | PatchOps Knowledge

What you can ask

“What does Snowflake have for the area or asset I'm working on?”
“Pull the most recent Snowflake records and put them in a table.”
“What does Snowflake cover, and how fresh is the data?”

About this source

Read-only Snowflake SQL API connector for model-authored queries and exact metadata discovery. RULES: 1. Supply warehouse when the Snowflake user has no DEFAULT_WAREHOUSE. 2. Discovery flow: listDatabases → executeSQL (schemas) → listTables → describeTable → executeSQL (data). 3. Use describeTable to verify column names before querying. 4. Use DB.SCHEMA.TABLE when not setting database/schema context. 5. executeSQL returns at most maxRows (default 100, maximum 1000) and reports truncation.

Connector ID snowflake

Provenance

PublisherSnowflake

API basehttps://account_identifier.snowflakecomputing.com/api/v2

Freshness & coverage

FreshnessFreshness not declared

GeographicNot declared

TemporalNot declared

AuthenticationCredentials required (Bearer token)

› Methods (4)

Technical detail for developers: parameters, pagination, units, and freshness per method.

executeSQL
unknown
Execute ad-hoc SQL queries through the Snowflake SQL API.
Required paramssql
Entitiesquery
Warehouse required unless configured. Accepts one read-only SQL statement.
listDatabases
read
List databases visible to the current credentials.
Entitiesdatabase
Use pattern for filtering. Warehouse is required only when no default exists.
listTables
read
List tables within a database/schema combination.
Required paramsdatabaseschema
Entitiestable
describeTable
read
Return column metadata for a specific table (Snowflake).
Required paramsdatabaseschematable
Entitiestable, column