Skip to main content

Create Table From Data Source

Creates a Magpie table from a generic data source.

Syntax​

create [temp | temporary] table { <table spec> | <table name> } [in schema <schema reference>]
  from data source <data source reference>
  [at path "<path>"]
  [with options <options>]

Parameters​

table spec​

JSON — A specification for saving the table. Note that the persistence mapping and fields are not used when creating a table from data source.

table name​

String — The name of the table to create.

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 data resides in.

path​

String — The optional path of the data in the data source. Default: none.

options​

JSON — A simple JSON object, consisting of a set of key value pair options to use when connecting to the data source for this table.