Manage

Configure Winning Variant resources directly in Snowflake

The Winning Variant Native App allows users to manage experimentation resources directly inside of Snowflake by use of stored procedures created during installation.

Roles

A user must be assigned of the following application roles to execute any of the procedures described on this page:

• admin
• editor

Resource Kinds

All references to kind below must be one of:

• lab
• subjecttype
• experiment

Read more about Resource Kinds.

List Resources

Each of the following “list” commands returns a table with the following columns:

Column	Description	Data Type
kind	The resource kind.	VARCHAR
id	ID of the resource.	VARCHAR
name	Name of the resource.	VARCHAR
status	Resource status	VARCHAR
description	Resource description	VARCHAR
resource_version	Current resource version	INT

USE <application_name>;

CALL experimentation.list_resources('<kind>' [, <status>, ...]);

Returns a list of all resources of the given kind. status must be one of ResourceStatus.

Examples

Labs

-- List all
USE <application_name>;

CALL experimentation.list_resources('lab');

-- List active
CALL experimentation.list_resources('lab', ['active']);

Get YAML for a single resource

USE <application_name>;

CALL experimentation.get_resource_yaml('<kind>', '<id>');

Returns a table with the following columns:

Column	Description	Data Type
kind	The resource kind.	VARCHAR
id	ID of the resource.	VARCHAR
yaml	The full configuration (YAML) for a single resource.	VARCHAR

Examples

USE <application_name>;

CALL experimentation.get_resource_yaml('experiment', 'my-experiment');

Create or update resource

USE <application_name>;

CALL experimentation.apply_resource('<yaml>');

If the resource with the id specified exists, it gets updated, otherwise it will be created.

Examples

USE <application_name>;

-- Create a new lab with id `marketing`
CALL experimentation.apply_resource($$schemaVersion: 1
kind: lab
metadata:
  id: marketing
  status: active
  name: Marketing
  description: All marketing and top-of-funnel experiments.
$$);

-- Update the name of the lab we just created
CALL experimentation.apply_resource($$schemaVersion: 1
kind: lab
metadata:
  id: marketing
  status: active
  name: Marketing Organization
  description: All marketing and top-of-funnel experiments.
$$);