Skip to content

Instantly share code, notes, and snippets.

View mynameisvinn's full-sized avatar

v mynameisvinn

69 followers · 54 following
View GitHub Profile
@mynameisvinn
mynameisvinn / Giftable_trigger.md
Last active January 22, 2025 20:17 
WITH
  -- userId, candidateId, attribution (eg click, purchase)
  -- candidateid is listingId https://etsy.slack.com/archives/C01T5STE7DH/p1726850552184059?thread_ts=1726850305.245089&cid=C01T5STE7DH
  attribution_tab AS (
  SELECT
    CAST(userId AS int) AS userId,
    candidateId AS listingId
  FROM
    `etsy-sr-etl-prod.etl_data.search_attribution_hourly`