Skip to content

Instantly share code, notes, and snippets.

View opencarlos's full-sized avatar

opencarlos

0 followers · 1 following
View GitHub Profile
@opencarlos
opencarlos / component-product-form.js
Last active November 25, 2024 21:41
if ( typeof ProductVariants !== 'function' ) {
class ProductVariants extends HTMLElement {
constructor() {
super();
this.init();
}
init() {
@opencarlos
opencarlos / update.sql
Created July 11, 2023 15:59
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
@opencarlos
opencarlos / 1.23.sql
Created June 12, 2023 17:51
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
@opencarlos
opencarlos / 1.23.sql
Created June 7, 2023 19:25
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
@opencarlos
opencarlos / 1.22.sql
Created June 7, 2023 14:57
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
@opencarlos
opencarlos / 1.21.sql
Created June 6, 2023 18:33
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
@opencarlos
opencarlos / v1.2.sql
Last active June 5, 2023 19:32
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
@opencarlos
opencarlos / v1.00001.sql
Created May 31, 2023 19:46
with MERCHANT AS (
SELECT
m.OS_MERCHANT MERCHANT,
ROW_NUMBER() OVER(ORDER BY m.dt_closed ASC) AS Rownum,
c.OS_SOURCE_SCHEMA SOURCE_SCHEMA,
m.OS_STORE_ID STORE_ID,
m.os_store_url STORE_URL
FROM ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants m ON m.OS_STORE_ID = c.OS_STORE_ID
WHERE OS_CONNECTOR_TYPE in ('shopify_bulk')
@opencarlos
opencarlos / update.sql
Created May 31, 2023 18:26
with MERCHANT AS (
SELECT
m.OS_MERCHANT MERCHANT,
ROW_NUMBER() OVER(ORDER BY m.dt_closed ASC) AS Rownum,
c.OS_SOURCE_SCHEMA SOURCE_SCHEMA,
m.OS_STORE_ID STORE_ID,
m.os_store_url STORE_URL
FROM ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants m ON m.OS_STORE_ID = c.OS_STORE_ID
WHERE OS_CONNECTOR_TYPE in ('shopify_bulk')
@opencarlos
opencarlos / fulfillment qa.sql
Last active May 31, 2023 17:20
with MERCHANT AS (
SELECT
m.OS_MERCHANT MERCHANT,
ROW_NUMBER() OVER(ORDER BY m.dt_closed ASC) AS Rownum,
c.OS_SOURCE_SCHEMA SOURCE_SCHEMA,
m.OS_STORE_ID STORE_ID,
m.os_store_url STORE_URL
FROM ANALYTICS.PROD_INTAKE_DB_PUBLIC.CONNECTOR c
JOIN analytics.main.os_merchants m ON m.OS_STORE_ID = c.OS_STORE_ID
WHERE OS_CONNECTOR_TYPE in ('shopify_bulk')