> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# System Functions

## `get_query_operator_stats`

*Supported Signatures*

```sql theme={null}
function get_query_operator_stats(string) returns struct<query_id string, step_id bigint, operator_id bigint, parent_operators array, operator_type string, operator_statistics variant, execution_time_breakdown variant, operator_attributes variant>

```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/get_query_operator_stats)

## `system$abort_session`

Abort the specified open session
*Supported Signatures*

```sql theme={null}
function system$abort_session(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$abort_session)

## `system$abort_transaction`

Abort the specified transaction if it is running. If the transaction is already is committed/rolled back then the state of the transaction is not altered.
*Supported Signatures*

```sql theme={null}
function system$abort_transaction(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$abort_transaction)

## `system$behavior_change_bundle_status`

returned value
*Supported Signatures*

```sql theme={null}
function system$behavior_change_bundle_status(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$behavior_change_bundle_status)

## `system$cancel_all_queries`

cancel all the queries running in the specified session
*Supported Signatures*

```sql theme={null}
function system$cancel_all_queries() returns varchar
function system$cancel_all_queries(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$cancel_all_queries)

## `system$cancel_query`

cancel the specified running query
*Supported Signatures*

```sql theme={null}
function system$cancel_query(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$cancel_query)

## `system$clustering_depth`

Average depth of the table
*Supported Signatures*

```sql theme={null}
function system$clustering_depth(varchar, ...) returns double
function system$clustering_depth(varchar, varchar, ...) returns double
function system$clustering_depth(varchar, varchar, varchar, ...) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$clustering_depth)

## `system$clustering_information`

returns clustering information as json
*Supported Signatures*

```sql theme={null}
function system$clustering_information(varchar, ...) returns varchar
function system$clustering_information(varchar, varchar, ...) returns varchar
function system$clustering_information(varchar, varchar, varchar, ...) returns varchar
function system$clustering_information(varchar, decimal(38, 0), ...) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$clustering_information)

## `system$convert_pipes_sqs_to_sns`

returns true if all SQS pipes' metadata based on this bucket are successfully converted to new SNS topic-based pipes.
*Supported Signatures*

```sql theme={null}
function system$convert_pipes_sqs_to_sns(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$convert_pipes_sqs_to_sns)

## `system$disable_database_replication`

Returns success/fail message of the operation
*Supported Signatures*

```sql theme={null}
function system$disable_database_replication(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$disable_database_replication)

## `system$estimate_query_acceleration`

estimate query acceleration result
*Supported Signatures*

```sql theme={null}
function system$estimate_query_acceleration(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$estimate_query_acceleration)

## `system$estimate_search_optimization_costs`

result: the cost report result for search optimization on the given table
*Supported Signatures*

```sql theme={null}
function system$estimate_search_optimization_costs(varchar) returns varchar
function system$estimate_search_optimization_costs(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$estimate_search_optimization_costs)

## `system$explain_json_to_text`

text format explain plan from json
*Supported Signatures*

```sql theme={null}
function system$explain_json_to_text(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$explain_json_to_text)

## `system$explain_plan_json`

json of the explain plan result
*Supported Signatures*

```sql theme={null}
function system$explain_plan_json(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$explain_plan_json)

## `system$external_table_pipe_status`

returns pipe status as json
*Supported Signatures*

```sql theme={null}
function system$external_table_pipe_status(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$external_table_pipe_status)

## `system$generate_saml_csr`

returns the result of the operation.
*Supported Signatures*

```sql theme={null}
function system$generate_saml_csr() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$generate_saml_csr)

## `system$get_aws_sns_iam_policy`

returns IAM policy for the SNS topic
*Supported Signatures*

```sql theme={null}
function system$get_aws_sns_iam_policy(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_aws_sns_iam_policy)

## `system$get_directory_table_status`

returns the associated directory table status
*Supported Signatures*

```sql theme={null}
function system$get_directory_table_status() returns varchar
function system$get_directory_table_status(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_directory_table_status)

## `system$get_iceberg_table_information`

returns the latest Iceberg metadata information
*Supported Signatures*

```sql theme={null}
function system$get_iceberg_table_information(varchar) returns varchar
function system$get_iceberg_table_information(varchar, decimal(38, 0)) returns varchar
function system$get_iceberg_table_information(decimal(38, 0)) returns varchar
function system$get_iceberg_table_information(decimal(38, 0), decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_iceberg_table_information)

## `system$get_predecessor_return_value`

Return data
*Supported Signatures*

```sql theme={null}
function system$get_predecessor_return_value() returns varchar
function system$get_predecessor_return_value(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_predecessor_return_value)

## `system$get_service_logs`

return status of operation
*Supported Signatures*

```sql theme={null}
function system$get_service_logs(varchar, decimal(38, 0), varchar) returns varchar
function system$get_service_logs(varchar, decimal(38, 0), varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_service_logs)

## `system$get_service_status`

return service resource set status
*Supported Signatures*

```sql theme={null}
function system$get_service_status($1) returns varchar
function system$get_service_status($1, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_service_status)

## `system$get_tag`

Returns the associated tag value
*Supported Signatures*

```sql theme={null}
function system$get_tag() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_tag)

## `system$get_tag_allowed_values`

Returns the allowed values for a tag
*Supported Signatures*

```sql theme={null}
function system$get_tag_allowed_values() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_tag_allowed_values)

## `system$get_tag_on_current_column`

Returns the associated tag value
*Supported Signatures*

```sql theme={null}
function system$get_tag_on_current_column() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_tag_on_current_column)

## `system$get_tag_on_current_table`

Returns the associated tag value on the current table
*Supported Signatures*

```sql theme={null}
function system$get_tag_on_current_table() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_tag_on_current_table)

## `system$get_task_graph_config`

Result
*Supported Signatures*

```sql theme={null}
function system$get_task_graph_config() returns varchar
function system$get_task_graph_config(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$get_task_graph_config)

## `system$global_account_set_parameter`

param set result from the account
*Supported Signatures*

```sql theme={null}
function system$global_account_set_parameter(varchar, varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$global_account_set_parameter)

## `system$last_change_commit_time`

returns the largest commit time as a long.
*Supported Signatures*

```sql theme={null}
function system$last_change_commit_time(varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$last_change_commit_time)

## `system$migrate_saml_idp_registration`

Returns the result of the operation.
*Supported Signatures*

```sql theme={null}
function system$migrate_saml_idp_registration(varchar) returns varchar
function system$migrate_saml_idp_registration(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$migrate_saml_idp_registration)

## `system$pipe_force_resume`

returns result of operation
*Supported Signatures*

```sql theme={null}
function system$pipe_force_resume(varchar) returns varchar
function system$pipe_force_resume(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$pipe_force_resume)

## `system$pipe_rebinding_with_notification_channel`

returns true if the pipe successfully rebinds with its assigned notification channel
*Supported Signatures*

```sql theme={null}
function system$pipe_rebinding_with_notification_channel(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$pipe_rebinding_with_notification_channel)

## `system$pipe_status`

returns pipe status as json
*Supported Signatures*

```sql theme={null}
function system$pipe_status(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$pipe_status)

## `system$query_reference`

Returns the query reference identifier
*Supported Signatures*

```sql theme={null}
function system$query_reference(varchar) returns varchar
function system$query_reference(varchar, boolean) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$query_reference)

## `system$reference`

Returns the reference identifier
*Supported Signatures*

```sql theme={null}
function system$reference(varchar, varchar, ...) returns varchar
function system$reference(varchar, varchar, boolean, ...) returns varchar
function system$reference(varchar, varchar, boolean, varchar, ...) returns varchar
function system$reference(varchar, varchar, varchar, ...) returns varchar
function system$reference(varchar, varchar, varchar, varchar, ...) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$reference)

## `system$set_return_value`

Returns "OK" if succeeded
*Supported Signatures*

```sql theme={null}
function system$set_return_value(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$set_return_value)

## `system$show_active_behavior_change_bundles`

returned value
*Supported Signatures*

```sql theme={null}
function system$show_active_behavior_change_bundles() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$show_active_behavior_change_bundles)

## `system$snowpipe_streaming_update_channel_offset_token`

returns status of update
*Supported Signatures*

```sql theme={null}
function system$snowpipe_streaming_update_channel_offset_token(varchar, varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$snowpipe_streaming_update_channel_offset_token)

## `system$task_dependents_enable`

Returns "OK" if succeeded
*Supported Signatures*

```sql theme={null}
function system$task_dependents_enable(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$task_dependents_enable)

## `system$task_runtime_info`

result
*Supported Signatures*

```sql theme={null}
function system$task_runtime_info(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$task_runtime_info)

## `system$typeof`

*Supported Signatures*

```sql theme={null}
function system$typeof($1) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$typeof)

## `system$user_task_cancel_ongoing_executions`

Returns "OK" if succeeded
*Supported Signatures*

```sql theme={null}
function system$user_task_cancel_ongoing_executions(varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$user_task_cancel_ongoing_executions)

## `system$verify_external_oauth_token`

The OAuth Access Token.
*Supported Signatures*

```sql theme={null}
function system$verify_external_oauth_token() returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$verify_external_oauth_token)

## `system$wait`

Wait for a finite amount of time
*Supported Signatures*

```sql theme={null}
function system$wait(decimal(38, 0)) returns varchar
function system$wait(decimal(38, 0), varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/system\$wait)