data.sql

-- customer IDs and ID types
DELETE FROM dm_b2c_marketing.customer_b2c;
INSERT INTO dm_b2c_marketing.customer_b2c (
  customer_id,
  id_domain,
  dp_customer_id
) VALUES (
  'shogun-alice',
  'shogun',
  'dp-inner-alice'
),
(
  'kayak-bob',
  'kayak',
  'dp-inner-bob'
),
(
  'cdm-charlie',
  'cdm',
  'dp-inner-charlie'
),
(
  'shogun-charlie',
  'shogun',
  'dp-inner-charlie'
)
;

-- emails
DELETE FROM dm_b2c_marketing.customer_b2c_email;
INSERT INTO dm_b2c_marketing.customer_b2c_email (
  customer_id,
  s_email,
  dp_customer_id
) VALUES (
  'shogun-alice',
  '[email protected]',
  'dp-inner-alice'
),
(
  'kayak-bob',
  '[email protected]',
  'dp-inner-bob'
),
(
  'cmd-charlie',
  '[email protected]',
  'dp-inner-charlie'
),
(
  'shogun-charlie',
  '[email protected]',
  'dp-inner-charlie'
);

-- master customer ID
DELETE FROM dm_b2c_marketing.master_customer2customer_b2c;
INSERT INTO dm_b2c_marketing.master_customer2customer_b2c (
  dp_master_customer_id,
  dp_customer_id
) VALUES (
  'dp-alice',
  'dp-inner-alice'
),
(
  'dp-bob',
  'dp-inner-bob'
),
(
  'dp-charlie',
  'dp-inner-charlie'
);

-- name
DELETE FROM dm_b2c_marketing.master_customer_b2c;
INSERT INTO dm_b2c_marketing.master_customer_b2c (
  dp_master_customer_id,
  s_first_name,
  s_last_name
) VALUES (
  'dp-alice',
  'Alice',
  'Kingsleigh'
),
(
  'dp-bob',
  'Bob',
  'Panley'
),
(
  'dp-charlie',
  'Charles',
  'Kofi'
);