With Clause

Description

The WITH clause can specify storage parameters for tables, and indexes associated with a UNIQUE or PRIMARY constraint.

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

The With clause is not applicable.

Grammar Syntax

WITH ( <storage_parameter> [=<value>] [, ... ] ) 

Sample Source Patterns

Greenplum

CREATE TABLE TABLE1 (
    COL1 integer
)
WITH (appendonly=true, orientation=column, compresstype=zlib, compresslevel=9);

Snowflake

CREATE TABLE PUBLIC.TABLE1 (
    COL1 integer
)
-- ** MSC-WARNING - MSC-GP0000 - WITH STORAGE OPTIONS NOT APPLICABLE. DATA STORAGE IS AUTOMATICALLY HANDLED BY SNOWFLAKE **
--WITH (appendonly=true, orientation=column, compresstype=zlib, compresslevel=9)
                                                                              ;

Related EWIs

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