Skip to main content
Creates an alias for a table, allowing you to ensure Omni content that uses the table doesn’t break when the table is renamed.

Syntax

aliases: [ OLD_TABLE_NAME ]

Properties

aliases
array
An array of old table names that should map to this view.

Examples

In this example, the OLD_ORDER_ITEMS_NAME table was renamed to ORDER_ITEMS in the database. Adding the original table name to the aliases parameter in the ORDER_ITEMS.view file in Omni prevents broken content and model validation errors.
ORDER_ITEMS.view file
schema: PUBLIC
table_name: ORDER_ITEMS
primary_key_sql: [ "${order_items.id}" ]
aliases: [OLD_ORDER_ITEMS_NAME]