Skip to content

Instantly share code, notes, and snippets.

with MERCHANT AS (
SELECT
c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA,
om.OS_MERCHANT AS MERCHANT,
om.OS_STORE_ID AS STORE_ID,
om.os_store_url AS STORE_URL
FROM
ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID
WHERE
with MERCHANT AS (
SELECT
c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA,
om.OS_MERCHANT AS MERCHANT,
om.OS_STORE_ID AS STORE_ID,
om.os_store_url AS STORE_URL
FROM
ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID
WHERE
with MERCHANT AS (
SELECT
c.OS_SOURCE_SCHEMA AS SOURCE_SCHEMA,
om.OS_MERCHANT AS MERCHANT,
om.OS_STORE_ID AS STORE_ID,
om.os_store_url AS STORE_URL
FROM
ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants om ON om.OS_STORE_ID = c.OS_STORE_ID
WHERE
if ( typeof ProductVariants !== 'function' ) {
class ProductVariants extends HTMLElement {
constructor() {
super();
this.init();
}
init() {