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.


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>]


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

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