Access content in a Declarative Native App¶

If you have installed a Snowflake Declarative Native App, or have had a Declarative Native App shared with you by a member of your organization, you can access the data and functionality through Snowsight or Snowflake CLI.

Access app content from Snowsight¶

Sign in to Snowsight with your Snowflake account.
In the navigation menu, select Data Products » Apps.
Select the app you want to access.
Browse the app’s content, which includes:
- Notebooks: If the app includes notebooks, you can run them to see visualizations and other content.
- Tables and views: You can query the tables and views that are part of the app.
Note

Notebooks in Declarative Native Apps are read-only. You can run the cells in a notebook, or run entire notebook, but you can’t modify it.

Access app notebooks¶

You can access the app’s notebooks, either through Snowsight or through Snowflake CLI.

Find and open notebooks available to your role using Snowsight¶

Sign in to Snowsight
In the navigation menu, select Data Products » Apps.
Select the app you want to access. A side panel appears with information about the app and its notebooks.
Select Open. If notebooks are available to your role, they appear in the drop-down list. If no notebooks are available, the Open button opens the worksheet directly.
If a list of notebooks appears, select a notebook from the list. The notebook opens, and is listed as a part of the app.
You can run individual cells in the notebook, or run the entire notebook by selecting Run » Run all cells.
Selecting the notebook name opens a menu with the following items:
- Other notebooks in the same app that you can navigate to.
- A link to the listing for this application.
The “<” (left chevron) button takes you to the notebook list page. The notebook list page has two tabs:
- All Notebooks: Lists all notebooks available to your role.
- Shared with me: Lists notebooks for which you aren’t the owner.

Find and open notebooks available to your role using SQL commands¶

Sign in to Snowsight, and select Write SQL queries.
Use the SHOW APPLICATIONS command to see what apps are installed in your account.
```
SHOW APPLICATIONS;
```
Copy
Use the application name (for example, market_data_app) to access the app’s content.
See what notebooks are in the app with the command: SHOW NOTEBOOKS IN APPLICATION.
```
SHOW NOTEBOOKS IN APPLICATION market_data_app;
```
Copy
For example, the command might return a notebook called MARKETING_NB.

Optional: Use the DESC NOTEBOOK command to see more information about the notebook.
```
DESC NOTEBOOK market_data_app.APP$UI.MARKETING_NB;
```
Copy

Run the notebook with the command: EXECUTE NOTEBOOK.

EXECUTE NOTEBOOK market_data_app.APP$UI.MARKETING_NB();

Copy

In the navigation menu, select Projects » Notebooks.

The notebook should appear in your list of available notebooks.
Open the notebook by selecting it from the list.

The notebook opens, and is listed as a part of the app.

Access tables and views in the app¶

Tables and views are available in the app’s schema. You can access them using SQL commands.

See what schemas are in the app using SHOW SCHEMAS IN APPLICATION.
SHOW SCHEMAS IN APPLICATION <app_name>;
Copy
See tables and views in a schema using the SHOW TABLES IN SCHEMA and SHOW VIEWS IN SCHEMA commands.
SHOW TABLES IN SCHEMA <app_name>.<schema>; SHOW VIEWS IN SCHEMA <app_name>.<schema>;
Copy

Select items in a view or table, for example:

SELECT * from <app_name>.<schema>.<view>;
SELECT * from <app_name>.<schema>.<table>;

Copy

Considerations¶

Notebooks in Declarative Native Apps are interactive, but are read-only. They can’t be modified, copied, or cloned.

To view past notebook executions, select Schedule notebook run » View run history.