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.

Syntax

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

Parameters

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.

sql

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