Data Security Platform Recognized as Leader for AI-Powered Capabilities,Coverage, and Automated Remediation. Read More.

What is DSPM?

FEATURED

Gartner® Innovation Insight: Data Security Posture Management
Get Report
PLATFORM
The Normalyze Platform
Supported Environments
Platform Benefits
USE CASES

Reduce Data Access Risks

Enforce Data Governance
Eliminate Abandoned Data

Secure PaaS Data

Enable Use of AI

DSPM for Snowflake

MARKETS

Healthcare
Retail
Technology
Media
M&A

FEATURED

DSPM-chat-Richard Stiennon-Ravi-Ithal-Normalyze
DSPM for Dummies:

Your guide to Data Security Posture Management

Get Your Copy

FEATURED

CYBER 60: The fastest-growing startups in cybersecurity
Get Report

Snowflake Native App

Details to enable Snowflake Native App for Normalyze

The Snowflake Native App Framework allows you to create data applications that leverage core Snowflake functionality. This capability is leveraged by Normalyze to facilitate the visualization of security scan results generated by the corresponding Normalyze connected app.

For more details on Snowflake Native App, review the Snowflake documentation.

Pre-Requisite

Snowflake Connected App feature should be enabled and configured on Normalyze platform to be able to use the Native App feature. Verify that as part the connected app configuration steps, database objects are created successfully.

Discover Normalyze App on Snowflake Marketplace:

  1. Login to Snowflake account as a user which has Accountadmin role.
  2. From the left side navigation panel select Data Products – Marketplace.
  3. Type Normalyze from the Search panel and select the corresponding result displayed under Providers section.

4. Select “Normalyze DSPM Connector for Snowflake” option.

5. Select “Get” from the right side panel to install the app on the Snowflake account.

6. This will launch the section to provide the Warehouse information for installation of the App to begin.

7. On selecting “Get”, the installation is begun and the progress is displayed.

8. Once the installation is completed, the following pop-up message is displayed.

9. Once the App is installed, navigate to Data Products – Apps and the Normalyze DSPM app will be listed.

Setting up Normalyze Native App:

  1. Navigate to Data Products – Apps – Normalyze DSPM.
  2. From the 3-dots menu – select View Details.

3. This will show the section for configuring the Normalyze App. The native app needs to be granted the SELECT privilege to the tables created in earlier section and in the connected app section. Select “Add” against each of the tables listed and select the following objects:

NORMALYZEAPPDATA – NORMALYZEAPPDATASCHEMA – <table name>

4. Complete the above step for all the 5 tables listed.

This completes the steps for configuring Normalyze App on Snowflake account.

Run the Data scan for the Snowflake account (onboarded) from Normalyze, where the above configuration is done and once it is completed metadata of the scan results will be displayed by the Normalyze App.

To review the results from the app, navigate to Data Products – App and select Normalyze DSPM. This will redirect to Streamlit application which will launch the Normalyze App.


The underlying scan results metadata can be used to build out custom Streamlit apps and visualized in more business specific manner by the end users on Snowflake acocunt.

Troubleshooting:

In the event that the Normalyze app crashes during launch or at any stage of data display, below screen will be displayed:
Note down the SESSION_ID from the message and execute the below query.

SELECT * from NORMALYZEAPPDATA.NORMALYZEAPPDATASCHEMA.DEBUG_INFO where SESSION_ID=”;

Share the query results with Normalyze for reviewing the details and addressing the root cause of the app crash.