A custom advanced engine setting, varcharLength.<yourDataPlatform> dictates the size of the VARCHAR.
In most dialects, the absence of the VARCHAR length leads to consuming its max size. This could impact performance.
Procedure
1. Select Settings > Engine under Organization Settings from the Design Center Homepage.
2. Scroll to the Custom Engine Setting section and select Show Custom Setting.
3. Enter one of the following settings, depending on the data platform you have configured:
- varcharLength.hive
- varcharLength.spark
- varcharLength.redshift
- varcharLength.postgres
4. Enter the desired size of the VARCHAR.
5. Scroll to the bottom of the page and select Save Settings.