Overriding the default data types used for dynamically created tables

The Interact runtime environment dynamically creates tables under two scenarios: during a test run of a flowchart and during the running of a Snapshot process that writes to a table that doesn't already exist. To create these tables, Interact relies on hardcoded data types for each supported database type.

You can override the default data types by creating a table of alternate data types, named uaci_column_types, in the testRunDataSource or prodUserDataSource. This additional table allows Interact to accommodate rare cases that aren’t covered by the hardcoded data types.

When the uaci_column_types table is defined, Interact uses the metadata for the columns as the data types to be used for any table generation. If the uaci_column_types table is not defined, or if there are any exceptions encountered while trying to read the table, the default data types are used.

At startup, the runtime system first checks the testRunDataSource for the uaci_column_types table. If the uaci_column_types table does not exist in the testDataSource, or if the prodUserDataSource is of a different database type, Interact then checks the prodUserDataSource for the table.