CREATE TABLE
statement creates a table and fills it with a subselect query output. It is usually used to materialize prediction results as tables.
CREATE TABLE
statement:
CREATE OR REPLACE TABLE
statement:
CREATE OR REPLACE TABLE
statement, the
integration_name.table_name
table is dropped before recreating it.integration_name.table_name
table inside the
integration_name
integration.INSERT INTO
statement to insert the
output of the (SELECT ...)
query into the
integration_name.table_name
.int1.tbl1
table.
Here is the schema structure used throughout this example:
Name | Description |
---|---|
int1 | Integration where the table that stores prediction results resides. |
tbl1 | Table that stores prediction results. |
predictor_name | Name of the model. |
int2 | Integration where the data source table used in the inner SELECT statement resides. |
tbl2 | Data source table used in the inner SELECT statement. |