Skip to content

Open source, privacy-first web analytics. Lightweight, cookie-free Google Analytics alternative. Self-hosted or cloud.

924 B
Raw Blame
INSERT INTO tmp_events_v2 (
  site_id, timestamp, name, user_id,
  session_id, hostname, pathname, referrer,
  referrer_source, country_code, screen_size,
  operating_system, browser, utm_medium,
  utm_source, utm_campaign, meta.key,
  meta.value, browser_version, operating_system_version,
  subdivision1_code, subdivision2_code,
  city_geoname_id, utm_content, utm_term,
  transferred_from
)
SELECT
  site_id,
  timestamp,
  name,
  user_id,
  session_id,
  hostname,
  pathname,
  referrer,
  referrer_source,
  country_code,
  screen_size,
  operating_system,
  browser,
  utm_medium,
  utm_source,
  utm_campaign,
  meta.key,
  meta.value,
  browser_version,
  operating_system_version,
  subdivision1_code,
  subdivision2_code,
  city_geoname_id,
  utm_content,
  utm_term,
  transferred_from
FROM
  events
INNER JOIN domains_lookup ON domains_lookup.domain = events.domain
WHERE (_partition_id = '<%= @partition %>')