Supported databases
This setting is only available for databases that support multiple catalogs: Athena, Databricks, Databricks Lakebase, Postgres, Redshift, Snowflake, and Trino.How view naming works
Without this setting enabled, Omni generates view names differently depending on whether a table is in the default catalog and schema:| Setup | View name in Omni |
|---|---|
| default catalog + default schema | <table> |
| default catalog + non-default schema | <schema>__<table> |
| non-default catalog + any schema | <catalog_schema>__<table> |
| Setup | View name in Omni |
|---|---|
| default catalog + default schema | <catalog_schema>__<table> |
| default catalog + non-default schema | <catalog_schema>__<table> |
| non-default catalog + any schema | <catalog_schema>__<table> |
When to use this setting
Enable this setting when you want:- Consistent naming across all views, regardless of catalog or schema location
- Predictable references when working with multiple catalogs or schemas
Enabling or disabling the setting
Connection Admin permissions are required to modify connection settings.
New connections
Connections created after the setting was introduced (April 30, 2026) have the setting enabled by default. You can disable it while setting up the connection, if needed.Existing connections
Connections created before this setting was introduced (April 30, 2026) have it disabled by default to preserve backward compatibility. To enable the setting for an existing connection:1
Open the connection details
- Navigate to Settings > Connections.
- Click a connection.
- Locate the Always Scope View Names toggle in the connection settings.
2
Toggle the setting
- Click the Always Scope View Names toggle to enable the setting.
- When prompted, confirm the change.
3
Save & apply the changes
- When finished, click Update and Test connection.
- Trigger a schema refresh to apply the changes to your Omni model.
4
Update model references
After the schema refresh completes, you’ll need to update references to the views in the shared model and any content built on the shared model.Use the Content Validator to identify and fix broken references in your documents and workbooks.
Next steps
- Learn how to refresh your schema to apply connection changes
- Understand how view names work in Omni’s model
- Use the Content Validator to identify broken model references in your content