analytics / priv /data_migrations /NumericIDs /sql /insert-into-tmp-events-v2.sql.eex
Leon4gr45's picture
Upload folder using huggingface_hub (part 4)
c27e67a verified
Raw
History Blame Contribute Delete
924 Bytes
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 %>')