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:
ColumnDescriptionData Type
kindThe resource kind.VARCHAR
idID of the resource.VARCHAR
nameName of the resource.VARCHAR
statusResource statusVARCHAR
descriptionResource descriptionVARCHAR
resource_versionCurrent resource versionINT
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']);

​
Get YAML for a single resource

USE <application_name>;

CALL experimentation.get_resource_yaml('<kind>', '<id>');
Returns a table with the following columns:
ColumnDescriptionData Type
kindThe resource kind.VARCHAR
idID of the resource.VARCHAR
yamlThe 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.
$$);