SHOW SERVICES and DESCRIBE SERVICE commands: New format for the DNS name of a service

Attention

This behavior change is in the 2024_06 bundle.

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

The SHOW SERVICES and DESCRIBE SERVICE commands behave as follows:

Before the change:

The dns_name column in the output of these commands contains the Snowflake-assigned DNS name of a service in the following format:

service-name.schema-name.db-name.snowflakecomputing.internal

After the change:

The format of the DNS name in the column has changed to:

service-name.unique-id.svc.spcs.internal

The major changes in the format are:

  • unique-id replaces the schema-name.db-name and is a 4-8 character long alphanumeric identifier that is unique to a particular instance of a database schema.

    To find the unique ID for a schema, call the SYSTEM$GET_SERVICE_DNS_DOMAIN function. For example:

    SELECT SYSTEM$GET_SERVICE_DNS_DOMAIN('mydb.myschema');
    
    Copy

    Note the following:

    • If you rename a schema, the identifier remains unchanged.

    • If you drop and recreate a schema with the same name, the identifier will change.

  • snowflakecomputing is replaced by svc.spcs to reduce the verbosity of the fully qualified DNS name of the service.

Note the following:

  • This is a change in the behavior of the CREATE SERVICE command. When a service is created, Snowflake assigns the DNS name to a service.

    However, the effects of this behavior change are visible when you use the SHOW SERVICES and DESCRIBE SERVICE commands, which include the DNS name in the output.

  • For services deployed after the 2024_06 bundle is enabled, the old style DNS names will continue to work for some time. Snowflake recommends that you update your code to use the new DNS format.

Ref: 1656