The CREATE TABLE
statement creates a table and fills it with a subselect query output. It is usually used to materialize prediction results as tables.
You can use the usual CREATE TABLE
statement:
Or the CREATE OR REPLACE TABLE
statement:
Here are the steps followed by the syntax:
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
.On execution, we get:
We want to save the prediction results into the int1.tbl1
table.
Here is the schema structure used throughout this example:
Where:
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. |
Let’s execute the query.
On execution, we get: