Creates a Magpie table that references a SQL query from a database data source. Tables created using this command are read-only.
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.
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.
String. The SQL query that will be executed locally at the database to use as the source data for the table.
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).