Categories:

System functions (System Information)

SYSTEM$APPLICATION_GET_TRACE_LEVEL

Returns the trace level for the specified object. The following objects are supported:

  • Functions
  • Schemas
  • Stored procedures
  • Versioned schemas

Syntax

SYSTEM$APPLICATION_GET_TRACE_LEVEL( '<schema_name>.<object_name>' )

Arguments

'schema_name.object_name'

The name of schema (or versioned schema) and object you want to determine the log level for.

Usage notes

  • This function can only be called by a Snowflake Native App and must be run as the APP_PRIMARY role.

Examples

SELECT SYSTEM$APPLICATION_GET_TRACE_LEVEL('my_schema');