Knowledge Base

Introduction

This knowledge base article guides you through the process of installing the "Narrative Data Collaboration powered by Rosetta Stone" application from the Snowflake Marketplace. This app enables powerful data collaboration and integration capabilities within your Snowflake environment.

Prerequisites

• You must be an ACCOUNTADMIN or have equivalent privileges in your Snowflake account to complete this installation.
• You must create an account on the Narrative Platform UI.
• You must configure a long-lived Narrative Platform API Token. You can find instructions here: How to create an API Token.
• You must have configured a Snowflake Virtual Warehouse to be used for serving the Native App UI via Streamlit, and a warehouse for executing queries configured in the Snowflake Native App.
• You must have accessed the Narrative Native App Listing and clicked "Install".
• You must have one table or view that you wish to grant access to the Snowflake Native App.

Note: If you encounter any issues during the installation process, please contact our support team at support@narrative.io.

Installation Steps

When you launch the app installation, you will be greeted with a screen like the following:

This wizard will guide you through the completion of the following steps:

Step 1: Grant Narrative Snowflake App Required Compute & Execution Privileges

Narrative needs the following privileges:

• EXECUTE TASK
• CREATE COMPUTE POOL
• BIND SERVICE ENDPOINT

You can grant these privileges to the Narrative Snowflake Native App simply by clicking "Grant Privileges" and following the pop-up that is displayed.

Step 2: Setup Compute Warehouse

Choose a Snowflake warehouse to execute queries on. Any query that you execute in this Data Plane using the Narrative Platform will run on this warehouse.

It is suggested that you select a sufficiently large warehouse to execute queries on based on the size of the data and the types of queries you will run. This can be changed at any time once the app has been installed by returning to this screen to configure your compute warehouse.

Step 3: Setup External Access Integration

The app requires access to an external endpoint (the Narrative API) and a secret (an API token) for accessing the Narrative Platform API.

1. Sign up or log in at the Narrative Platform.
2. Follow the guide on the Narrative Platform to "Create a Long-Lived Access Token".
3. Create an API token with the appropriate permissions mentioned below. Be sure to write down your token when it is displayed as it will only be displayed once! Ensure your API token has the following permissions:
   • Data Planes: Read and Write
   • Data Plane Logs: Read, Write
   • Datasets: Read and Write
   • Jobs: Read and Write
4. Once you have your API key, return to the Snowflake Native App to click "Setup External Access Integration". Click "Next" and then under "Secret value" paste your API Token.

Step 4: Setup Target Table or View

Select a Snowflake table or view to serve as the target for your queries. This table will be registered as a Dataset on the Narrative Platform, and queries will be executed against it within your Snowflake account. Narrative will have READ-ONLY access to this object.

The configured Snowflake tables and views can be changed at any time once the app has been installed by returning to this screen to configure your tables or views.

Step 5: Configure Source Tables or Views

After selecting the object, you will have a chance to give it an alias or name within the Narrative Platform. This is the DATASET UNIQUE NAME that will be displayed within the Narrative platform. Note that this name can contain only upper-case alphanumeric characters and underscores.

Step 6: Upload Sample (Optional)

Optionally, upload a sample of your source object's data to Narrative for display within the Narrative Platform UI. This is for convenience and to make it easier to interact with your data in the Narrative UI, and is entirely optional.

Note if you choose not to perform this action now, it can be performed later from within the Narrative Platform UI.

Step 7: Upload Stats (Optional)

Optionally, upload a set of statistics of your source object's data to Narrative for display within the Narrative Platform UI. This is for convenience and to make it easier to interact with your data in the Narrative UI, and is entirely optional.

Note if you choose not to perform this action now, it can be performed later from within the Narrative Platform UI.