Install and configure the Winning Variant Snowflake Native App.
The Winning Variant app is “by request”, meaning that we must explicitly grant customers access to the app. If you’re interested in what we have to offer, please click “Request” in the marketplace listing or reach out directly.
An event table is where all app logs will be saved. It’s important to have this configured properly before installing the app to ensure logs are routed correctly.Follow the instructions on Snowflake’s site
The app will need to be made available to your account prior to installation. Once available, you can find the app Winning Variant Experimentation. Click the “Get” button to begin installation.Installation may take a few minutes. When complete, you’ll be able to see the app listed under Data Products > Apps in Snowsight.
Winning Variant creates a set of application roles that can be used to manage access to the app’s functionality. In order to use these, they must be mapped to roles that exist on your account. You can use an existing role or create a new one.The following example creates a new account role experiment_editor and maps it to the editor application role exposed by the app:
Copy
USE <application_name>;-- Create a new role on the accountCREATE ROLE experiment_editor;-- Map this role to the Winning Variant `editor` roleGRANT APPLICATION ROLE editor TO ROLE experiment_editor;
You can also map roles visually via the streamlit app by clicking into the app and clicking “Manage Access” in the top right of the page.
Behind the scenes, the app is creating a compute pool, warehouses, and services. The status will be displayed on the streamlit dashboard. This process will take at least a few minutes. Refresh the page to monitor status changes.When all services are ready, all will turn green and show the public URLs for each service.