Create Table From SQL

Creates a Magpie table that displays data from a SQL query. Equivalent to a view in a traditional database. To copy data from the result of a SQL query into a new table, use the save result command instead.


create [temp | temporary] table { <table spec> | <table name> } [in schema <schema reference>] from sql(<sql>)


table spec

JSON. A specification for saving the table. Note that persistence mapping and fields are not used when creating a table from a SQL query.

table name

String. The name of the table to save the data as.

schema reference

String. The name of the schema to create the table in. Defaults to the current schema.


String. SQL query to use as the definition of the table.

Was this article helpful?
0 out of 0 found this helpful