Encoding Clause

Description

For a column, the optional ENCODING clause specifies the type of compression and block size for the column data.

Click here to navigate to the Greenplum documentation page for this syntax.

The Encoding clause is not supported in Snowflake

Grammar Syntax

ENCODING ( storage_directive [, ...] )

Sample Source Patterns

Greenplum

CREATE TABLE TABLE1 (
   COL1 integer CONSTRAINT Cons1 UNIQUE ENCODING (compresstype = quicklz, blocksize = 65536)
);

Snowflake

CREATE TABLE TABLE1 (
   COL1 integer CONSTRAINT Cons1 UNIQUE
-- ** MSC-WARNING - MSC-GP0000 - ENCODING OPTION NOT SUPPORTED. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--                                        ENCODING (compresstype = quicklz, blocksize = 65536)
);

Related EWIs

1. MSC-GP0000: Data storage is automatically handled by Snowflake