IMPORTANT
This article is no longer being maintained/updated and will be archived at a future date (TBD).
For up-to-date information about this behavior change, see
2023_04 Bundle (in the Snowflake Documentation)
This behavior change is in the 2023_04 bundle. In the 7.19 release, the bundle is disabled by default.
In a future release, you will be able to use the SYSTEM$CLUSTERING_INFORMATION function to view Automatic Clustering errors that have occurred in the last 14 days.
|
Currently:
|
Users cannot obtain descriptive messages for errors encountered during Automatic Clustering.
|
|
Pending:
|
The JSON output of the SYSTEM$CLUSTERING_INFORMATION function includes a new field clustering_errors, which contains an array of errors. Each error contains a timestamp and descriptive message.
For example, the new output of the function might be:
{
"cluster_by_keys" : "LINEAR(i)",
"notes" : "Clustering key columns contain high cardinality key I which
might result in expensive re-clustering. Consider reducing the
cardinality of clustering keys. Please refer to
https://docs.snowflake.net/manuals/user-guide/tables-clustering-keys.html
for more information.",
"total_partition_count" : 0,
"total_constant_partition_count" : 0,
"average_overlaps" : 0.0,
"average_depth" : 0.0,
"partition_depth_histogram" : {
"00000" : 0,
// omitted for brevity
},
"clustering_errors" : [ {
"timestamp" : "2023-04-03 17:50:42 +0000",
"error" : "(003325) Clustering service has been disabled.\n"
} ]
}
By default, the 10 most recent messages are returned by the function. A new function syntax allows you to specify an integer as the optional second argument in order to return more or fewer messages. For example, the following returns the 25 most recent errors:
SYSTEM$CLUSTERING_INFORMATION( 'my_table' , 25)
|
Ref: 985
