Virtual Schemas, Views, and Procedures

You are looking at an older version of the documentation. The latest version is found here.

This table supplies information on virtual schemas.

Column Name	Type	Description
`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

This table supplies information on view definitions.

Column Name	Type	Description
`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

This table supplies information on procedure definitions.

Column Name	Type	Description
`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