CREATE TABLE AS

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

Creates and loads a table from the results of a query. (Vertica SQL Language Reference Create Table).

This syntax is partially supported in Snowflake. Translation pending for the following clauses:

[ /*+ LABEL */ ]
[ AT epoch ]
[ ENCODED BY column-ref-list ]
[ ENCODING encoding-type ]
[ ACCESSRANK integer ]
[ GROUPED ( column-reference[,...] ) ]

Grammar Syntax

CREATE TABLE [ IF NOT EXISTS ] [[database.]schema.]table
[ ( column-name-list ) ]
[ {INCLUDE | EXCLUDE} [SCHEMA] PRIVILEGES ]
AS  [ /*+ LABEL */ ] [ AT epoch ] query [ ENCODED BY column-ref-list ] [ segmentation-spec ]

<column-name-list> ::=
column-name-list
    [ ENCODING encoding-type ]
    [ ACCESSRANK integer ]
    [ GROUPED ( column-reference[,...] ) ]

Tables Options

Segmentation Clause

This syntax isn't required in Snowflake and is removed from the original code. For more information, please refer to Projections Clauses.

This syntax is not required in Snowflake.

Inherited Schema Privileges Clause

INCLUDE SCHEMA PRIVILEGES is a Vertica-specific feature that governs how privileges are inherited, in this case, potentially from the schema level. Snowflake does not have a direct equivalent for this clause within its CREATE TABLE syntax. For more information please refer to Inherited Schema Privileges Clause.

This syntax is not supported in Snowflake.

Related EWIs

1. SSC-EWI-VT0001: Inherited privileges clause is not supported in Snowflake.