Sign up
All data sources

Snowflake

Bearer tokensnowflake

Snowflake SQL API for query execution and metadata discovery. RULES: 1. Warehouse REQUIRED: { warehouse: "COMPUTE_WH" } or set SNOWFLAKE_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.

Get this contract as JSONConnect this source →

Provenance

PublisherSnowflake
API basehttps://api.snowflake.com/

Freshness & coverage

FreshnessFreshness not declared
GeographicNot declared
TemporalNot declared
AuthenticationCredentials required (Bearer token)

Methods (4)

  • executeSQL

    unknown

    Execute ad-hoc SQL queries through the Snowflake SQL API.

    Required paramssql

    Warehouse required unless SNOWFLAKE_WAREHOUSE is set.

  • listDatabases

    read

    List databases visible to the current credentials.

    Filter: { pattern: "PROD_%" }. Warehouse required unless env set.

  • listTables

    read

    List tables within a database/schema combination.

    Required paramsdatabaseschema

  • describeTable

    read

    Return column metadata for a specific table.

    Required paramsdatabaseschematable