This article summarizes the features, objects, properties, and data types that are available for Snowflake projects.
Features
Objects and properties
-
Use quotes
Transient
With managed access
Data retention time (days)
-
Use quotes
-
Types:
Standard
Transient
-
Constraints
-
RELY
Comment/Description
-
RELY
Comment/Description
-
RELY
Comment/Description
-
-
Columns
Expression
Comment/Description
-
Properties:
Data retention time (days)
-
Additional properties (policies)
Row access policy
Aggregation policy
Join policy
Comment/Description
Post Script
-
Use quotes
Data type (see summary of types below)
(NOT) NULL
Default
-
Start
Increment
Sequence
Collation
-
Additional properties (policies)
Masking policy
Projection policy
Comment/Description
-
Dynamic tables
- Use quotes
- Transient
- Constraints
-
Clustering
- Columns
- Expression
- Comment/Description
-
Clustering
- Properties:
- Target Lag
- Warehouse
- Refresh mode
- Initialize
- Data retention time (days)
- File Format
-
Additional properties (policies)
Row access policy
Aggregation policy
Join policy
Comment/Description
Post Script
-
Hybrid Tables
- Use quotes
- Constraints
-
RELY
Comment/Description
-
RELY
Comment/Description
-
RELY
Comment/Description
-
Index Key
Comment/Description
-
- Properties:
- Data retention time (days)
- File Format
- Snowflake Tags
- Additional properties (policies)
- Row access policy
- Aggregation policy
- Join policy
- Comment/Description
- Post Script
-
Columns
Use quotes
Data type (see summary of types below)
(NOT) NULL
Default
-
Start
Increment
Sequence
Collation
-
Additional properties (policies)
Masking policy
Projection policy
Comment/Description
-
Iceberg Tables
- Use quotes
- Transient
- Properties for all catalogues:
- Catalog
- External volume
- Snowflake Tags
- Comment/Description
- Post Script
- Specific options for Snowflake Catalog
- Constraints
-
RELY
Comment/Description
-
RELY
Comment/Description
-
RELY
Comment/Description
-
- Properties:
- Base Location
- Catalog Sync
- Storage serialization policy
- Data retention time (days)
- Max data extension times (days)
- Change tracking
- Copy grants
- Additional properties (policies)
- Row access policy
- Aggregation policy
- Join policy
-
Columns
Use quotes
Data type (see summary of types below)
(NOT) NULL
Default
-
Start
Increment
Sequence
Collation
-
Additional properties (policies)
Masking policy
Projection policy
Comment/Description
- Specific options for AWS Glue Catalog
- Properties:
- Catalog table name
- Catalog namespace
- Catalog integration name
- Replace invalid characters
- Auto refresh
- Properties:
- Specific options for Iceberg files
- Properties:
- Metadata file path
- Catalog integration name
- Replace invalid characters
- Properties:
- Specific options for Delta files
- Properties:
- Base Location
- Catalog integration name
- Replace invalid characters
- Auto refresh
- Properties:
- Specific options for Iceberg REST Catalog
- Properties:
- Catalog table name
- Catalog namespace
- Catalog integration name
- Max data extension times (days)
- Copy grants
- Replace invalid characters
- Auto refresh
-
Columns
Use quotes
Data type (see summary of types below)
(NOT) NULL
Default
-
Start
Increment
Sequence
Collation
-
Additional properties (policies)
Masking policy
Projection policy
Comment/Description
- Properties:
- Constraints
-
-
Types:
Secure
Materialized
Recursive
- Additional properties (policies)
- Row access policy
- Aggregation policy
- Join policy
Comment/Description
-
-
Overloading parameters
Comment/Description
-
Overloading parameters
Comment/Description
-
Use quotes
-
Format type
Avro
-
Csv
Record delimiter
Field delimiter
File extension
Skip header
Date format
Time format
Timestamp format
-
Binary format
Base64
Hex
Utf8
Escape
Escape unenclosed field
Field optionally enclosed by
NullIf
Encoding
Trim space
Error on column count mismatch
Validate Utf8
Empty field as null
Skip byte order mark
-
Json
File extension
Enable octal
Allow duplicate
Strip outer array
Strip null values
Ignore Utf8 Errors
Skip byte order mark
Orc
-
Parquet
Binary as text
Snappy compression
-
Xml
Ignore Utf8 errors
Preserve space
Strip outer element
Disable Snowflake data
Disable auto convert
Skip byte order mark
-
Compression
Auto
Brotly
Bz2
Deflate
Gzip
None
RowDeflate
Zstd
-
Use quotes
Start with
Increment by
-
Use quotes
Allowed values
Comment/Description
Data types
-
Numeric Data Types
NUMBER
DECIMAL
NUMERIC
INT
INTEGER
BIGINT
SMALLINT
TINYINT
BYTEINT
FLOAT
FLOAT4
FLOAT8
DOUBLE
DOUBLE PRECISION
REAL
DECFLOAT
-
String & Binary Data Types
VARCHAR
CHAR
CHARACTER
STRING
TEXT
BINARY
VARBINARY
VARCHAR2
UUID
-
Logical Data Types
BOOLEAN
-
Date & Time Data Types
DATE
DATETIME
TIME
TIMESTAMP
TIMESTAMP_LTZ
TIMESTAMP_NTZ
TIMESTAMP_TZ
-
Semi-structured Data Types
VARIANT
OBJECT
ARRAY
-
Geospatial Data Types
GEOGRAPHY
GEOMETRY