Skip to main content

Create Schema From Database

Creates a Magpie schema in the current repository that references a schema in a JDBC persistence source, including all tables within it.

Syntax​

create schema <target schema reference> from data source <data source reference>
  [using schema <source schema reference>]
  [with ignore failed tables]
  [with bulk access]
  [with fetch size <fetch size>]
  [with writable]

Parameters​

target schema reference​

String — The name of the schema to create.

data source reference​

String — The name of the data source that the database schema resides in.

source schema reference​

String — The optional name of the source database schema to reference. Default is the default schema for the JDBC connection.

ignore failed tables​

None. If present, continue creating tables from database after encountering a failure on any table(s). Default behavior halts on failures.

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).

with writable​

None. If present, create the new table as writable. By default database tables are read-only. Not supported on BigQuery tables.