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>
system$abort_session
Abort the specified open session Supported Signatures
function system$abort_session(decimal(38, 0)) returns varchar
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
system$behavior_change_bundle_status
returned value Supported Signatures
function system$behavior_change_bundle_status(varchar) returns varchar
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
system$cancel_query
cancel the specified running query Supported Signatures
function system$cancel_query(varchar) returns varchar
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
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, ...) returns varchar
function system$clustering_information(varchar, decimal(38, 0), ...) returns varchar
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
system$disable_database_replication
Returns success/fail message of the operation Supported Signatures
function system$disable_database_replication(varchar) returns varchar
system$estimate_query_acceleration
estimate query acceleration result Supported Signatures
function system$estimate_query_acceleration(varchar) returns varchar
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
system$explain_json_to_text
text format explain plan from json Supported Signatures
function system$explain_json_to_text(varchar) returns varchar
system$explain_plan_json
json of the explain plan result Supported Signatures
function system$explain_plan_json(varchar) returns varchar
system$external_table_pipe_status
returns pipe status as json Supported Signatures
function system$external_table_pipe_status(varchar) returns varchar
system$generate_saml_csr
returns the result of the operation. Supported Signatures
function system$generate_saml_csr() returns varchar
system$get_aws_sns_iam_policy
returns IAM policy for the SNS topic Supported Signatures
function system$get_aws_sns_iam_policy(varchar) returns varchar
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
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
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
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
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
system$get_tag
Returns the associated tag value Supported Signatures
function system$get_tag() returns varchar
system$get_tag_allowed_values
Returns the allowed values for a tag Supported Signatures
function system$get_tag_allowed_values() returns varchar
system$get_tag_on_current_column
Returns the associated tag value Supported Signatures
function system$get_tag_on_current_column() returns varchar
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
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
system$global_account_set_parameter
param set result from the account Supported Signatures
function system$global_account_set_parameter(varchar, varchar, varchar) returns varchar
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)
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
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
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
system$pipe_status
returns pipe status as json Supported Signatures
function system$pipe_status(varchar) returns varchar
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
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, ...) returns varchar
function system$reference(varchar, varchar, varchar, ...) returns varchar
function system$reference(varchar, varchar, varchar, varchar, ...) returns varchar
system$set_return_value
Returns “OK” if succeeded Supported Signatures
function system$set_return_value(varchar) returns varchar
system$show_active_behavior_change_bundles
returned value Supported Signatures
function system$show_active_behavior_change_bundles() returns varchar
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
system$task_dependents_enable
Returns “OK” if succeeded Supported Signatures
function system$task_dependents_enable(varchar) returns varchar
system$task_runtime_info
result Supported Signatures
function system$task_runtime_info(varchar) returns varchar
system$typeof
Supported Signatures
function system$typeof($1) returns varchar
system$user_task_cancel_ongoing_executions
Returns “OK” if succeeded Supported Signatures
function system$user_task_cancel_ongoing_executions(varchar) returns varchar
system$verify_external_oauth_token
The OAuth Access Token. Supported Signatures
function system$verify_external_oauth_token() returns varchar
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