Publishing schema from multi-instance SCP to ION Data Catalog

The scv_datalake_schema_prefix new application variable is now available.

When publishing the schema to ION Data Catalog, this application variable is used by each SCV instance to determine the name of the table being published. The specified schema prefix can have a maximum length of 10 characters. The table names published to ION Data Catalog have the SCP_<Schema Prefix>_<SCV Table Name> format.

Using the application variable for schema prefix, both shared and separate schemas in Data Lake are supported for SCV instances. All SCV instances with the same schema prefix value shares the schema in Data Lake. An SCV instance with a distinct schema prefix value has specific schema in Data Lake. The scv_datalake_schema_prefix application variable has Null as default value. This guarantees that the published schemas remain unchanged until a non-null value is explicitly specified for the application variable.

When the schema prefix application variable is modified, you must verify that the ibp_ims connection point and the IBP-DataLake-Flow is pre-configured. If the ibp_ims connection point is inactive, you must activate it. To add newly published documents, you must update the ibp_ims connection point and the IBP-DataLake-Flow.