Multiple Schema Concept - codbex/codbex-kronos GitHub Wiki

When working with schemas currently there are 2 options:

1. Import all artifacts into one schema.
2. Import all artifacts into multiple schemas. In order for artifacts to be visible inside all schemas public synonyms will be created. (one synonym for each data structure)

Currently Kronos supports the second option.

For example: If we import a .hdbtable artifact that contains schemaName, the artifact will be created inside that schema and a public synonym will be created with the same name as the artifact.

table.schemaName = "MYSCHEMA";
table.tableType = COLUMNSTORE; 
table.columns = [
	{name = "ID"; sqlType = INTEGER; nullable = false;}];
table.primaryKey.pkcolumns = ["ID"];

This concept is supported for:

Operation	Artifact	First Option Supported	Second option Supported	Comment
Create/Delete/Update	Table	:x:	:heavy_check_mark:
Create/Delete/Update	View	:x:	:heavy_check_mark:	There is no update operation, the view is dropped and then recreated.
Create/Delete/Update	Procedure	:x:	:x:
Create/Delete/Update	Functions	:x:	:x: