CREATE FACT or DIMENSION TABLE…AS SELECT

Creates a table and loads data into it based on the SELECT query. The table column names and types are automatically inferred based on the output columns of the SELECT. When specifying explicit column names those override the column names inferred from the SELECT.

Syntax

Fact table:

CREATE FACT TABLE [IF NOT EXISTS] <table_name>
[(<column_name>[, ...n] )]
PRIMARY INDEX <column_name>[, <column_name>[, ...n]]
[PARTITION BY <column_name>[, <column_name>[, ...n]]]
AS <select_query>

Dimension table:

CREATE DIMENSION TABLE [IF NOT EXISTS] <table_name>
[(<column_name>[, ...n] )]
[PRIMARY INDEX <column_name>[, <column_name>[, ...n]]]
AS <select_query>

Parameters

Remarks

Unlike a traditional CREATE statement, the primary index and partition definition must come before the AS clause.