Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/show-objects-owned-by-application below:

Website Navigation

• Reference
• SQL command reference
• Native Apps Framework

SHOW OBJECTS OWNED BY APPLICATION

Preview Feature — Open

Available to all accounts.

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

See also:

SHOW APPLICATIONS

SHOW OBJECTS OWNED BY APPLICATION <app_name>

Copy

app_name

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

Privilege

Object

Notes

OWNERSHIP or MANAGE GRANTS

App

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

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.

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        |
+---------------------------------+----------------------+---------------------+

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4