All Collections
Database Object and Feature Support
Snowflake Support Summary
Snowflake Support Summary

Snowflake object and data type support summary

S
Written by Serge Gershkovich
Updated over a week ago

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

Features

Objects and properties

  • Schemas

    • Transient

    • With managed access

    • Data retention time (days)

  • Tables

    • 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

    • Copy Options

      • On error

      • Skip file number

      • Skip file percent

      • Size limit

      • Purge

      • Return failed only

      • Truncate columns

      • Force

    • Comment/Description

    • Post Script

  • Columns

    • Data type (see summary of types below)

    • (NOT) NULL

    • Default

    • Identity

      • Start

      • Increment

    • Sequence

    • Collation

    • Snowflake Tags

    • Comment/Description

  • Views

  • Functions/UDFs

    • Overloading parameters

    • Comment/Description

  • Procedures

    • Overloading parameters

    • Comment/Description

  • File Formats

    • 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

    • Start

    • Increment

  • Snowflake Tags

    • 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

  • String & Binary Data Types

    • VARCHAR

    • CHAR

    • CHARACTER

    • STRING

    • TEXT

    • BINARY

    • VARBINARY

  • 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

See also:

Did this answer your question?