COMMENT = '<string_literal>'

AUTO_RESUME = { TRUE | FALSE }

AUTO_SUSPEND_SECS = <num>

WAREHOUSE = <warehouse_name>

PACKAGES = ( '<package_name_and_version>' [ , ... ] )

COPY GRANTS

[ [ WITH ] TAG ( <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' , ... ] ) ]

EXTERNAL_ACCESS_INTEGRATIONS = ( <name_of_integration> [ , ... ] )

Universal Resource Name An address scheme for uniquely identifying resources within a Snowflake account. Format ------

Description: Represents a grant of a role to another role or user in Snowflake. Snowflake Docs: https://docs.snowflake.com/e

Description: Represents a grant of privileges on a resource to a role in Snowflake. Snowflake Docs: https://docs.snowflake.c

Description: Represents a future grant of privileges on a resource to a role in Snowflake. Snowflake Docs: https://docs.snow

Description: Represents a grant of privileges on all resources of a specified type to a role in Snowflake. Snowflake Docs: h

FILE_FORMAT = ( { FORMAT_NAME = '<file_format_name>' | TYPE = { CSV | JSON | AVRO | ORC | PARQUET | XML | CUSTOM } )

{ AT | BEFORE } ( { TIMESTAMP => <timestamp> | OFFSET => <time_difference> | STATEMENT => <id> | STREAM => '<name

Description: Represents a database in Snowflake. Snowflake Docs: https://docs.snowflake.com/en/sql-reference/sql/create-data

RETURNS VARIANT RETURNS VARCHAR NOT NULL RETURNS NUMBER(38,0) RETURNS TABLE (event_date DATE, city VARCHAR, temperature NUMBER)

Description: Represents a schema in Snowflake, which is a logical grouping of database objects such as tables, views, and stored procedur

Description: A compute pool is a group of compute resources in Snowflake that can be used to execute SQL queries. Snowflake Docs:

HEADERS = ( '<header_1>' = '<value_1>' [ , '<header_2>' = '<value_2>' ... ] )

Description: An image repository in Snowflake is a storage unit within a schema that allows for the management of OCIv2-compliant contain

STORAGE_LOCATIONS = ( ( NAME = '<storage_location_name>' STORAGE_BASE_URL = '<protocol>://<bucket>[/<path>/]'

Description: A role in Snowflake defines a set of access controls and permissions. Snowflake Docs: https://docs.snowflake.co

( NAME = '<storage_location_name>' STORAGE_BASE_URL = '<protocol>://<bucket>[/<path>/]' ... )

Description: A user in Snowflake. Snowflake Docs: https://docs.snowflake.com/en/sql-reference/sql/create-user Fields:

Description: A virtual warehouse, often referred to simply as a "warehouse", is a cluster of compute resources in Snowflake. It provides

Represents the size options for a warehouse. Available sizes: - XSMALL - SMALL - MEDIUM - LARGE - XLARGE - XXLARGE