Snowflake Data Types¶

Snowflake data types.

Date & Time Data

Reference information and examples for working with dates, times and timestamps, and time zones in Snowflake:

• Date and Time Input / Output

• Using Dates and Timestamps

Semi-structured Data

Key concepts and tasks for working with JSON and other types of semi-structured data:

• Introduction to Semi-structured Data

• Supported Formats for Semi-structured Data

• Considerations for Semi-structured Data Stored in VARIANT

• Tutorial: JSON Basics

Unstructured Data

Key concepts and tasks for working with unstructured data:

• Introduction to Unstructured Data Support

• Directory Tables

• REST API for Unstructured Data Support

• Sharing unstructured Data with a secure view

• Troubleshooting Processing of Unstructured Data

Binary Data

Reference information and examples for working with binary data in Snowflake:

• Binary Input and Output

• Using Binary Data

Snowflake Time Travel & Fail-safe

Key concepts and tasks for understanding how Snowflake maintains access to deleted and modified data, and also how Snowflake enables data recovery in the event of loss:

• Understanding & Using Time Travel

• Understanding & Viewing Fail-safe

• Storage Costs for Time Travel and Fail-safe

Continuous Data Pipelines

Key concepts and tasks for transforming and optimizing loaded data for analysis:

• Change Tracking Using Table Streams

• Executing SQL Statements on a Schedule Using Tasks

Introduction to Business Continuity & Disaster Recovery

Key concepts and tasks for replicating and failing over databases across multiple Snowflake accounts, as well as redirecting client connections, for business continuity and disaster recovery:

• Introduction to Replication and Failover

• Redirecting Client Connections