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>' )
Copy

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');
Copy
Language: English