System Functions

`get_query_operator_stats`

Supported Signatures

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

`system$abort_session`

Abort the specified open session Supported Signatures

function system$abort_session(decimal(38, 0)) returns varchar

🔗 Official Documentation

`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

function system$abort_transaction(decimal(38, 0)) returns varchar

🔗 Official Documentation

`system$behavior_change_bundle_status`

returned value Supported Signatures

function system$behavior_change_bundle_status(varchar) returns varchar

🔗 Official Documentation

`system$cancel_all_queries`

cancel all the queries running in the specified session Supported Signatures

function system$cancel_all_queries() returns varchar
function system$cancel_all_queries(decimal(38, 0)) returns varchar

🔗 Official Documentation

`system$cancel_query`

cancel the specified running query Supported Signatures

function system$cancel_query(varchar) returns varchar

🔗 Official Documentation

`system$clustering_depth`

Average depth of the table Supported Signatures

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

`system$clustering_information`

returns clustering information as json Supported Signatures

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

`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

function system$convert_pipes_sqs_to_sns(varchar, varchar) returns varchar

🔗 Official Documentation

`system$disable_database_replication`

Returns success/fail message of the operation Supported Signatures

function system$disable_database_replication(varchar) returns varchar

🔗 Official Documentation

`system$estimate_query_acceleration`

estimate query acceleration result Supported Signatures

function system$estimate_query_acceleration(varchar) returns varchar

🔗 Official Documentation

`system$estimate_search_optimization_costs`

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

function system$estimate_search_optimization_costs(varchar) returns varchar
function system$estimate_search_optimization_costs(varchar, varchar) returns varchar

🔗 Official Documentation

`system$explain_json_to_text`

text format explain plan from json Supported Signatures

function system$explain_json_to_text(varchar) returns varchar

🔗 Official Documentation

`system$explain_plan_json`

json of the explain plan result Supported Signatures

function system$explain_plan_json(varchar) returns varchar

🔗 Official Documentation

`system$external_table_pipe_status`

returns pipe status as json Supported Signatures

function system$external_table_pipe_status(varchar) returns varchar

🔗 Official Documentation

`system$generate_saml_csr`

returns the result of the operation. Supported Signatures

function system$generate_saml_csr() returns varchar

🔗 Official Documentation returns IAM policy for the SNS topic Supported Signatures

function system$get_aws_sns_iam_policy(varchar) returns varchar

🔗 Official Documentation

`system$get_directory_table_status`

returns the associated directory table status Supported Signatures

function system$get_directory_table_status() returns varchar
function system$get_directory_table_status(varchar) returns varchar

🔗 Official Documentation

`system$get_iceberg_table_information`

returns the latest Iceberg metadata information Supported Signatures

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

`system$get_predecessor_return_value`

Return data Supported Signatures

function system$get_predecessor_return_value() returns varchar
function system$get_predecessor_return_value(varchar) returns varchar

🔗 Official Documentation

`system$get_service_logs`

return status of operation Supported Signatures

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

`system$get_service_status`

return service resource set status Supported Signatures

function system$get_service_status($1) returns varchar
function system$get_service_status($1, decimal(38, 0)) returns varchar

🔗 Official Documentation

`system$get_tag`

Returns the associated tag value Supported Signatures

function system$get_tag() returns varchar

🔗 Official Documentation

`system$get_tag_allowed_values`

Returns the allowed values for a tag Supported Signatures

function system$get_tag_allowed_values() returns varchar

🔗 Official Documentation

`system$get_tag_on_current_column`

Returns the associated tag value Supported Signatures

function system$get_tag_on_current_column() returns varchar

🔗 Official Documentation

`system$get_tag_on_current_table`

Returns the associated tag value on the current table Supported Signatures

function system$get_tag_on_current_table() returns varchar

🔗 Official Documentation

`system$get_task_graph_config`

Result Supported Signatures

function system$get_task_graph_config() returns varchar
function system$get_task_graph_config(varchar) returns varchar

🔗 Official Documentation

`system$global_account_set_parameter`

param set result from the account Supported Signatures

function system$global_account_set_parameter(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

`system$last_change_commit_time`

returns the largest commit time as a long. Supported Signatures

function system$last_change_commit_time(varchar) returns decimal(38, 0)

🔗 Official Documentation

`system$migrate_saml_idp_registration`

Returns the result of the operation. Supported Signatures

function system$migrate_saml_idp_registration(varchar) returns varchar
function system$migrate_saml_idp_registration(varchar, varchar) returns varchar

🔗 Official Documentation

`system$pipe_force_resume`

returns result of operation Supported Signatures

function system$pipe_force_resume(varchar) returns varchar
function system$pipe_force_resume(varchar, varchar) returns varchar

🔗 Official Documentation

`system$pipe_rebinding_with_notification_channel`

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

function system$pipe_rebinding_with_notification_channel(varchar) returns varchar

🔗 Official Documentation

`system$pipe_status`

returns pipe status as json Supported Signatures

function system$pipe_status(varchar) returns varchar

🔗 Official Documentation

`system$query_reference`

Returns the query reference identifier Supported Signatures

function system$query_reference(varchar) returns varchar
function system$query_reference(varchar, boolean) returns varchar

🔗 Official Documentation

`system$reference`

Returns the reference identifier Supported Signatures

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

`system$set_return_value`

Returns “OK” if succeeded Supported Signatures

function system$set_return_value(varchar) returns varchar

🔗 Official Documentation

`system$show_active_behavior_change_bundles`

returned value Supported Signatures

function system$show_active_behavior_change_bundles() returns varchar

🔗 Official Documentation

`system$snowpipe_streaming_update_channel_offset_token`

returns status of update Supported Signatures

function system$snowpipe_streaming_update_channel_offset_token(varchar, varchar, varchar) returns varchar

🔗 Official Documentation

`system$task_dependents_enable`

Returns “OK” if succeeded Supported Signatures

function system$task_dependents_enable(varchar) returns varchar

🔗 Official Documentation

`system$task_runtime_info`

result Supported Signatures

function system$task_runtime_info(varchar) returns varchar

🔗 Official Documentation

`system$typeof`

Supported Signatures

function system$typeof($1) returns varchar

🔗 Official Documentation

`system$user_task_cancel_ongoing_executions`

Returns “OK” if succeeded Supported Signatures

function system$user_task_cancel_ongoing_executions(varchar) returns varchar

🔗 Official Documentation

`system$verify_external_oauth_token`

The OAuth Access Token. Supported Signatures

function system$verify_external_oauth_token() returns varchar

🔗 Official Documentation

`system$wait`

Wait for a finite amount of time Supported Signatures

function system$wait(decimal(38, 0)) returns varchar
function system$wait(decimal(38, 0), varchar) returns varchar

🔗 Official Documentation

Reference

SQL Functions

​get_query_operator_stats

​system$abort_session

​system$abort_transaction

​system$behavior_change_bundle_status

​system$cancel_all_queries

​system$cancel_query

​system$clustering_depth

​system$clustering_information

​system$convert_pipes_sqs_to_sns

​system$disable_database_replication

​system$estimate_query_acceleration

​system$estimate_search_optimization_costs

​system$explain_json_to_text

​system$explain_plan_json

​system$external_table_pipe_status

​system$generate_saml_csr

​system$get_aws_sns_iam_policy

​system$get_directory_table_status

​system$get_iceberg_table_information

​system$get_predecessor_return_value

​system$get_service_logs

​system$get_service_status

​system$get_tag

​system$get_tag_allowed_values

​system$get_tag_on_current_column

​system$get_tag_on_current_table

​system$get_task_graph_config

​system$global_account_set_parameter

​system$last_change_commit_time

​system$migrate_saml_idp_registration

​system$pipe_force_resume

​system$pipe_rebinding_with_notification_channel

​system$pipe_status

​system$query_reference

​system$reference

​system$set_return_value

​system$show_active_behavior_change_bundles

​system$snowpipe_streaming_update_channel_offset_token

​system$task_dependents_enable

​system$task_runtime_info

​system$typeof

​system$user_task_cancel_ongoing_executions

​system$verify_external_oauth_token

​system$wait

`get_query_operator_stats`

`system$abort_session`

`system$abort_transaction`

`system$behavior_change_bundle_status`

`system$cancel_all_queries`

`system$cancel_query`

`system$clustering_depth`

`system$clustering_information`

`system$convert_pipes_sqs_to_sns`

`system$disable_database_replication`

`system$estimate_query_acceleration`

`system$estimate_search_optimization_costs`

`system$explain_json_to_text`

`system$explain_plan_json`

`system$external_table_pipe_status`

`system$generate_saml_csr`

`system$get_aws_sns_iam_policy`

`system$get_directory_table_status`

`system$get_iceberg_table_information`

`system$get_predecessor_return_value`

`system$get_service_logs`

`system$get_service_status`

`system$get_tag`

`system$get_tag_allowed_values`

`system$get_tag_on_current_column`

`system$get_tag_on_current_table`

`system$get_task_graph_config`

`system$global_account_set_parameter`

`system$last_change_commit_time`

`system$migrate_saml_idp_registration`

`system$pipe_force_resume`

`system$pipe_rebinding_with_notification_channel`

`system$pipe_status`

`system$query_reference`

`system$reference`

`system$set_return_value`

`system$show_active_behavior_change_bundles`

`system$snowpipe_streaming_update_channel_offset_token`

`system$task_dependents_enable`

`system$task_runtime_info`

`system$typeof`

`system$user_task_cancel_ongoing_executions`

`system$verify_external_oauth_token`

`system$wait`