Skip to main content

Snowflake Support Summary

SqlDBM Support
Updated

This article summarizes the features, objects, properties, and data types that are available for Snowflake projects.

 

Features

 

Objects and properties

  • Schemas

    • Use quotes

    • Transient

    • With managed access

    • Data retention time (days)

  • Tables

    • Use quotes

    • Types:

      • Standard

      • Transient

    • Constraints

      • PK

        • RELY

        • Comment/Description

      • FK

        • RELY

        • Comment/Description

      • AK (UNIQUE)

        • RELY

        • Comment/Description

    • Clustering

      • Columns

      • Expression

      • Comment/Description

    • Properties:

    • 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

    • Identity

      • Start

      • Increment

    • Sequence

    • Collation

    • Snowflake Tags

    • Additional properties (policies)

      • Masking policy

      • Projection policy

    • Comment/Description

  • Dynamic tables
    • Use quotes
    • Transient
    • Constraints
      • Clustering
        • Columns
        • Expression
        • Comment/Description
    • Properties:
      • Target Lag
      • Warehouse
      • Refresh mode
      • Initialize
      • Data retention time (days)
      • File Format

    • Snowflake Tags

    • Additional properties (policies)

      • Row access policy

      • Aggregation policy

      • Join policy

    • Comment/Description

    • Post Script

  • Hybrid Tables
    • Use quotes
    • Constraints

      • PK

        • RELY

        • Comment/Description

      • FK

        • RELY

        • Comment/Description

      • AK (UNIQUE)

        • RELY

        • Comment/Description

      • Index Key

        • Comment/Description

    • Properties:
    • 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

      • Identity

        • Start

        • Increment

      • Sequence

      • Collation

      • Snowflake Tags

      • 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

        • PK

          • RELY

          • Comment/Description

        • FK

          • RELY

          • Comment/Description

        • AK (UNIQUE)

          • 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

        • Identity

          • Start

          • Increment

        • Sequence

        • Collation

        • Snowflake Tags

        • 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
      • Specific options for Iceberg files
        • Properties:
          • Metadata file path
          • Catalog integration name
          • Replace invalid characters
      • Specific options for Delta files
        • Properties:
          • Base Location
          • Catalog integration name
          • Replace invalid characters
          • Auto refresh
      • 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

          • Identity

            • Start

            • Increment

          • Sequence

          • Collation

          • Snowflake Tags

          • Additional properties (policies)

            • Masking policy

            • Projection policy

          • Comment/Description

    • Views

      • Types:

        • Secure

        • Materialized

        • Recursive

      • Snowflake Tags

      • Additional properties (policies)
        • Row access policy
        • Aggregation policy
        • Join policy

      • Comment/Description

  • Functions/UDFs

    • Overloading parameters

    • Comment/Description

  • Procedures

    • Overloading parameters

    • Comment/Description

  • File Formats

    • 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

  • Sequences

    • Use quotes

    • Start with

    • Increment by

  • Snowflake Tags

    • 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

 

See also:

Related articles