Table prefix rules

Starting with version 12.0.11C (2020-12) certain table prefixes, such as DEPM or WB, cannot be used. This is to prevent interference between Staging tables and future Integration tables.

If existing tables have such prohibited prefixes, then they are indicated by a warning icon to prompt you to fix them. In the meantime, the tables and their load queries still function.

  1. For each indicated table, create a new Staging table with the required schema.
    You can use queries against the original tables to create the new tables.
  2. Use load queries against the original tables to retrieve their data.
  3. Copy and paste the SQL statements of the affected tables' load queries, from the original tables to the new Staging tables.
  4. Update any SQL scripts that reference the original Staging tables.
  5. Update any Non-SQL scripts that reference the original Staging tables and their load queries.
  6. Update workflows, data flows, and Application Engine processes that reference the load queries of the original Staging tables.
  7. Delete the original Staging tables.