ENCODE

Description

Enables Amazon Redshift to automatically adjust the encoding type for all columns in the table to optimize query performance

Click here to navigate to the Amazon Redshift docs page for this syntax.

Grammar Syntax

ENCODE AUTO

Sample Source Patterns

Amazon Redshift

CREATE TABLE TABLE1 (
COL1 INTEGER,
COL2 VARCHAR(30)) 
ENCODE AUTO;

Snowflake

CREATE TABLE TABLE1 (
COL1 INTEGER,
COL2 VARCHAR(30))
----** MSC-WARNING - MSC-RS0005 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE. **
--ENCODE AUTO
           ;
  1. MCS-RS0005: ENCODING option not supported. Data storage is automatically handled by Snowflake.

Last updated

Was this helpful?