Set the Teradata default schema (default database) on Azure Synapse Analytics

Teradata database names translate to schema names on the target cloud data warehouse. Teradata allows you to configure a custom, default database name for users, which is used when looking up unqualified objects. Hyper-Q supports the Azure SQL Data Warehouse (SQL DW) DEFAULT_SCHEMA property for users to provide the same functionality and allow legacy applications to run unchanged.

To set a user's DEFAULT_SCHEMA property, run the following SQL statement on Azure Synapse Analytics:

ALTER USER <username> WITH DEFAULT_SCHEMA = <new_default_schema>;

To query a user's DEFAULT_SCHEMA property, run the following statement on Azure Synapse Analytics:

SELECT default_schema_name FROM sys.database_principals WHERE type = 'S' AND name = '<username>';

To learn more, see ALTER USER in the Microsoft Azure Synapse Analytics documentation.