Virtual Schemas, Views, Procedures and Functions

id

biginteger

Virtual schema ID

name

string

Virtual schema name

deletable

boolean

Flag to signal whether virtual schema can be deleted or not

creationDate

timestamp

Timestamp when the virtual schema was created

lastModifiedDate

timestamp

Timestamp when the virtual schema was last modified

creator

string

Name of the user who created the schema

modifier

string

Name of the user who last modified the schema

name

string

View name

definition

string

SQL script defining how to create the view

creationDate

timestamp

Timestamp when the view was created

lastModifiedDate

timestamp

Timestamp when the view was last modified

state

string

State of the view (e.g. READY, WARNING, FAILED)

failureReason

string

Reason why the view has FAILED state

inSyncWithSource

boolean

Flag to signal whether the view is in sync with the source tables or not

notInSyncReason

string

Reason why a view is not in sync with the source

creator

string

Name of the user who created the view definition

modifier

string

Name of the user who last modified the view definition

name

string

Procedure name

definition

string

SQL script defining how to create the procedure

creationDate

timestamp

Timestamp when the procedure was created

lastModifiedDate

timestamp

Timestamp when the procedure was last modified

state

string

State of the procedure (e.g. READY, WARNING, FAILED)

failureReason

string

Reason why the procedure has FAILED state

creator

string

Name of the user who created the procedure

modifier

string

Name of the user who last modified the procedure

name

string

Function name

definition

string

SQL script defining how to create the function

creationDate

timestamp

Timestamp when the function was created

lastModifiedDate

timestamp

Timestamp when the function was last modified

state

string

State of the function (e.g. READY, WARNING, FAILED)

failureReason

string

Reason why the function has FAILED state

creator

string

Name of the user who created the function

modifier

string

Name of the user who last modified the function

translator

string

Translator name

version

string

Supported version

function

string

Function name with the parameters

script

string

Creation script