Encoding Clause

Description

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

Click herearrow-up-right to navigate to the Greenplum documentation page for this syntax.

circle-exclamation

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)
);
  1. MSC-GP0000arrow-up-right: Data storage is automatically handled by Snowflake

Last updated

Was this helpful?