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.

Sign in to connect Snowflake Basic

Sign in to connect an account and start using Snowflake Basic in your apps.

Example Use Cases

These are example ways Snow can use Snowflake Basic when building apps with you. This list is meant to show examples, not document every possible capability. Connecting an account does not make Snow run these automatically 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.