Download priv/data_migrations/NumericIDs/sql/insert-into-tmp-events-v2.sql.eex from Leon4gr45/analytics: direct link, hf CLI and curl.
- Browser
- Download file 924 Bytes
-
https://huggingface.co/spaces/Leon4gr45/analytics/resolve/main/priv/data_migrations/NumericIDs/sql/insert-into-tmp-events-v2.sql.eex
- Command line
-
hf download hf://spaces/Leon4gr45/analytics/priv/data_migrations/NumericIDs/sql/insert-into-tmp-events-v2.sql.eex
-
curl -L -o insert-into-tmp-events-v2.sql.eex https://huggingface.co/spaces/Leon4gr45/analytics/resolve/main/priv/data_migrations/NumericIDs/sql/insert-into-tmp-events-v2.sql.eex
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 %>') | |