Manage

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

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

-- List all
USE <application_name>;

CALL experimentation.list_resources('lab');

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

USE <application_name>;

CALL experimentation.list_resources('subjecttype');

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

USE <application_name>;

CALL experimentation.list_resources('experiment');

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

-- List active or winner declared
CALL experimentation.list_resources('experiment', ['active','winner_declared']);

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.
$$);

Experimentation Convenience Methods

In addition to the above methods using raw YAML, you may also create/manage experiments with the following purpose-built convenience methods. All methods also have a *_preview variant is available that returns the YAML that would be applied without actually creating the experiment:

CALL experimentation.create_experiment_preview(
  'homepage-cta-test', 'Homepage CTA Test', NULL, NULL, NULL, 'USER',
  '[{"id":"control","name":"Blue Button","isControl":true}]', NULL
);