Snowflake Basic icon

Snowflake Basic

Cloud data warehouse service for SQL queries, databases, schemas, table descriptions, and column sampling.

Supports analytics workflows that run SQL queries in Snowflake, list databases and schemas, and explore column-level samples.

Example Use Cases

These are the Snowflake Basic actions Snow can use when building apps with you. Connecting an account does not make Snow run these on its own.

Describe table

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.

Explore Columns

Retrieves a sample of distinct values for specified columns from a Snowflake table.

Run Query

Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Show databases

Retrieves a list of all databases available in the Snowflake account.

Show schemas

Retrieves a list of all schemas within a specified Snowflake database.

Show Tables

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.