Creates a Magpie table that references a SQL query from a database data source. Tables created using this command are read-only.

Syntax

create [temporary | temp] table { <target table name> | <target table spec> } [in schema <schema reference>]
from data source <data source reference> sql(<sql>)
  [with bulk access]
  [with fetch size <fetch size>]

Parameters

target table name

String. The name of the table to create.

target table spec

JSON. A specification for the new table. Note that the persistence mapping and fields are not used when creating a table with this command.

schema reference

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

data source reference

String. The name of the data source that the database query will be executed in.

sql

String. The SQL query that will be executed locally at the database to use as the source data for the table.

fetch size

Integer. The number of rows to fetch at once from a JDBC connection when reading from the table. Default 50,000.

with bulk access

None. If present, create table using bulk access connector rather than a traditional JDBC connector. Only valid for data sources that support bulk access (e.g., Redshift, Postgres).