SHOW SERVICES 和 DESCRIBE SERVICE 命令：服务的 DNS 名称的新格式¶

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:

该列中 DNS 名称的格式已更改为：

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

格式的主要变化是：

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.

要查找架构的唯一 ID，请调用 SYSTEM$GET_SERVICE_DNS_DOMAIN 函数。例如：

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

请注意以下事项：

如果您重命名一个架构，标识符保持不变。
如果您删除并重新创建一个具有相同名称的架构，标识符将会改变。
snowflakecomputing is replaced by svc.spcs to reduce the verbosity of the fully qualified DNS name of the service.

请注意以下事项：

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.
在启用 2024_06 捆绑包后部署的服务中，旧样式 DNS 名称将在一段时间内继续有效。Snowflake 建议您更新代码以使用新的 DNS 格式。

参考：1656