Virtual Schemas, Views, and Procedures

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