Overview of Key Features

This topic lists the notable/significant features supported in the current release. Note that it does not list every feature provided by Snowflake.

In this Topic:

Security, Governance, and Data Protection

Standard and Extended SQL Support

Tools and Interfaces


Data Import and Export

  • Support for bulk loading and unloading data into/out of tables, including:

    • Load any data that uses a supported character encoding.

    • Load data from compressed files.

    • Load most flat, delimited data files (CSV, TSV, etc.).

    • Load data files in JSON, Avro, ORC, Parquet, and XML format.

    • Load from files in cloud storage or local files using the Snowflake web interface or command line client.

  • Support for continuous data loading from files:

    • Use Snowpipe to load data in micro-batches from internal (i.e. Snowflake) stages or external (Amazon S3, Google Cloud Storage, or Microsoft Azure) stages.

Data Sharing

  • Support for securely sharing data with other Snowflake accounts:

    • Provide data to other accounts to consume.

    • Consume data provided by other accounts.

Database Replication and Failover

  • Support for replicating and syncing databases across multiple Snowflake accounts in different regions:

    • Replicate databases between Snowflake accounts (within the same organization) and keep the database objects and stored data synchronized.

    • Configure database failover to one or more Snowflake accounts for business continuity and disaster recovery.