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.


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