Version 2021

Max Metric Alias Size

Max Metric Alias Size is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

Max Metric Alias Size allows you to set the maximum size of the metric alias string. This is useful for databases that only accept a limited number of characters for column names.

Set the Max Metric Alias Size VLDB property for the following gateways:

Gateway Max Metric Alias Size

SQL Server 2012

SQL Server 2014

SQL Server 2016

SQL Server 2017

SQL Server 2019

128

Azure Synapse

128

Db2

128

PostgreSQL

63

Oracle 12c 30

Oracle 12cR2

Oracle 18c

Oracle 19c

Oracle 21c

128

Redshift

127

Teradata 15.x

Teradata 16.x

Teradata 17

128

Google BigQuery 128

Snowflake

256

 

Levels at Which You Can Set This

Database instance only