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

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

🔗 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