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.