Skip to content

Add experiments and experiment_users tables

Alex Buijs requested to merge experiments-table into master

What does this MR do?

This MR adds 2 tables for tracking which users are enrolled for which experiments conducted by the Growth team. This makes for easier analysis when we want to measure eg. stage adoption for users who have been subjected to a particular experiment.

In addition, in the current MR an event for the onboarding_issues experiment is recorded when the experiment is enabled and a user selects continue on this page https://gitlab.com/users/sign_up/welcome.

The following tables are added:

experiments
id
name
Migration output

== 20200731085019 CreateExperiment: migrating =================================
-- table_exists?(:experiments)
   -> 0.0004s
-- create_table(:experiments)
   -> 0.0138s
-- transaction_open?()
   -> 0.0000s
-- execute("ALTER TABLE experiments\nADD CONSTRAINT check_e2dda25ed0\nCHECK ( char_length(name) <= 255 )\nNOT VALID;\n")
   -> 0.0008s
-- execute("ALTER TABLE experiments VALIDATE CONSTRAINT check_e2dda25ed0;")
   -> 0.0005s
== 20200731085019 CreateExperiment: migrated (0.0185s) ========================
experiment_users
id
experiment_id
user_id
group
created_at
updated_at
Migration output

== 20200731090553 CreateExperimentUser: migrating =============================
-- create_table(:experiment_users)
   -> 0.0029s
-- add_index(:experiment_users, :experiment_id)
   -> 0.0018s
-- add_index(:experiment_users, :user_id)
   -> 0.0017s
== 20200731090553 CreateExperimentUser: migrated (0.0065s) ====================
== 20200731201408 AddForeignKeyToExperimentOnExperimentUsers: migrating =======
-- add_foreign_key(:experiment_users, :experiments, {:column=>:experiment_id, :on_delete=>:cascade})
-> 0.0030s
== 20200731201408 AddForeignKeyToExperimentOnExperimentUsers: migrated (0.0044s)
== 20200731201834 AddForeignKeyToUserOnExperimentUsers: migrating =============
-- add_foreign_key(:experiment_users, :users, {:column=>:user_id, :on_delete=>:cascade})
-> 0.0117s
== 20200731201834 AddForeignKeyToUserOnExperimentUsers: migrated (0.0131s) ====

Issue: #230469 (closed) and #229057 (closed)

Edited by Nicolas Dular

Merge request reports