SQL parameters: Disallow setting date and time output formats to AUTO (Preview)¶

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, you can’t set date and time output formats to AUTO:

Before the change:

Date and time output formats could be set to AUTO.

After the change:

Date and time output formats can’t be set to AUTO.

The following parameters define the formats for date and time output from Snowflake:

• DATE_OUTPUT_FORMAT

• TIME_OUTPUT_FORMAT

• CSV_TIMESTAMP_FORMAT

• TIMESTAMP_OUTPUT_FORMAT

• TIMESTAMP_LTZ_OUTPUT_FORMAT

• TIMESTAMP_NTZ_OUTPUT_FORMAT

• TIMESTAMP_TZ_OUTPUT_FORMAT

Before this change, setting these parameters to AUTO was undocumented but allowed.

After this change, the AUTO setting is no longer allowed for these parameters.

If you use this undocumented and unsupported parameter setting, complete the following actions:

1. Remove all parameter overrides that set the date and time output parameters to AUTO.

   The setting is case insensitive.

2. Check your scripts and other code for the setting, and if any of your scripts or code sets the date and time output parameters to AUTO, remove the setting or replace it with a valid setting.

   After the change, attempting to set a date and time output parameter to this value returns the following error:

   SQL compilation error: invalid value [auto] for parameter '<parameter_name>'
   

Ref: 2115