SHOW OBJECTS OWNED BY APPLICATIONΒΆ

Lists the objects owned by an app that exists outside the app.

See also:

SHOW APPLICATIONS

SyntaxΒΆ

SHOW OBJECTS OWNED BY APPLICATION <app_name>
Copy

ParametersΒΆ

app_name

The name of the app whose objects you want to list.

Access control requirementsΒΆ

Privilege

Object

Notes

OWNERSHIP or MANAGE GRANTS

App

One of these privileges is required to view the objects owned by the app.

OutputΒΆ

Column

Description

created_on

The timestamp when the object was created.

name

The name of the object owned by the app

type

The type of object, for example COMPUTE_POOL.

ExamplesΒΆ

SHOW OBJECTS OWNED BY APPLICATION hello_snowflake_app;
Copy
+---------------------------------+----------------------+---------------------+
| created_on                      | name                 | object_type         |
|---------------------------------|----------------------|---------------------|
| 2024-11-20 17:56:08.887 -0800   | HELLO_SNOWFLAKE_APP  | COMPUTE_POOL        |
+---------------------------------+----------------------+---------------------+