SHOW SHARED CONTENT IN APPLICATION PACKAGE¶

Shows all of the objects for which you have access privileges that have been shared from a Declarative Native App application package.

Syntax¶

SHOW SHARED CONTENT IN APPLICATION PACKAGE <pkg_name>

Copy

Parameters¶

PACKAGE pkg_name: Returns shared content for the specified package (pkg_name).

Output¶

The output of the command includes the following columns, which describe the properties and metadata of the object:

Column	Description
`version_name`	The automatically generated version name for the shared object. If the object is part of the live version, the value is `LIVE`.
`database_name`	The name of the database containing the shared object.
`schema_name`	The name of the schema containing the shared object.
`entity_name`	The name of the shared object.
`entity_type`	The type of the shared object, for example, TABLE, VIEW, or NOTEBOOK.

Access control requirements¶

This command requires a role with the relevant privilege on the entities returned. For example, if the application package contains a shared table, the role must have the USAGE privilege on the database and schema containing the table, and the SELECT privilege on the table.

Examples¶

The following example shows how to use the SHOW SHARED CONTENT IN APPLICATION PACKAGE command to list all of the objects in a Declarative Native App application package.

SHOW SHARED CONTENT IN APPLICATION PACKAGE decl_share_app_pkg;

Copy

+-------------------------------------------------------------------------------+
| version_name | database_name | schema_name     | entity_name    | entity_type |
|--------------+---------------+-----------------+----------------+-------------|
| LIVE         | DB_TO_SHARE   | SCHEMA_TO_SHARE | TABLE_TO_SHARE | TABLE       |
| VERSION$2    | DB_TO_SHARE   | SCHEMA_TO_SHARE | TABLE_TO_SHARE | TABLE       |
| VERSION$3    | DB_TO_SHARE   | SCHEMA_TO_SHARE | TABLE_TO_SHARE | TABLE       |
+-------------------------------------------------------------------------------+