Skip to content

Instantly share code, notes, and snippets.

@wub

wub/schema.txt

Created September 3, 2019 10:19
Show Gist options
  • Save wub/9d4b9d27f15f8e7c87906e55cb913f68 to your computer and use it in GitHub Desktop.
Save wub/9d4b9d27f15f8e7c87906e55cb913f68 to your computer and use it in GitHub Desktop.
Download ZIP
BQ Schema (Sparse)
Raw
schema.txt
----------------- ----------------------------------------------------------------------------------------------- ------------ ------------- ------------ ----------------------------- ------------------ --------
03 Sep 22:03:02 |- app_id: string 248096 333340368 DAY (field: derived_tstamp)
|- platform: string
|- etl_tstamp: timestamp
|- collector_tstamp: timestamp (required)
|- dvce_created_tstamp: timestamp
|- event: string
|- event_id: string (required)
|- txn_id: integer
|- name_tracker: string
|- v_tracker: string
|- v_collector: string (required)
|- v_etl: string (required)
|- user_id: string
|- user_ipaddress: string
|- user_fingerprint: string
|- domain_userid: string
|- domain_sessionidx: integer
|- network_userid: string
|- geo_country: string
|- geo_region: string
|- geo_city: string
|- geo_zipcode: string
|- geo_latitude: float
|- geo_longitude: float
|- geo_region_name: string
|- ip_isp: string
|- ip_organization: string
|- ip_domain: string
|- ip_netspeed: string
|- page_url: string
|- page_title: string
|- page_referrer: string
|- page_urlscheme: string
|- page_urlhost: string
|- page_urlport: integer
|- page_urlpath: string
|- page_urlquery: string
|- page_urlfragment: string
|- refr_urlscheme: string
|- refr_urlhost: string
|- refr_urlport: integer
|- refr_urlpath: string
|- refr_urlquery: string
|- refr_urlfragment: string
|- refr_medium: string
|- refr_source: string
|- refr_term: string
|- mkt_medium: string
|- mkt_source: string
|- mkt_term: string
|- mkt_content: string
|- mkt_campaign: string
|- se_category: string
|- se_action: string
|- se_label: string
|- se_property: string
|- se_value: float
|- tr_orderid: string
|- tr_affiliation: string
|- tr_total: float
|- tr_tax: float
|- tr_shipping: float
|- tr_city: string
|- tr_state: string
|- tr_country: string
|- ti_orderid: string
|- ti_sku: string
|- ti_name: string
|- ti_category: string
|- ti_price: float
|- ti_quantity: integer
|- pp_xoffset_min: integer
|- pp_xoffset_max: integer
|- pp_yoffset_min: integer
|- pp_yoffset_max: integer
|- useragent: string
|- br_name: string
|- br_family: string
|- br_version: string
|- br_type: string
|- br_renderengine: string
|- br_lang: string
|- br_features_pdf: boolean
|- br_features_flash: boolean
|- br_features_java: boolean
|- br_features_director: boolean
|- br_features_quicktime: boolean
|- br_features_realplayer: boolean
|- br_features_windowsmedia: boolean
|- br_features_gears: boolean
|- br_features_silverlight: boolean
|- br_cookies: boolean
|- br_colordepth: string
|- br_viewwidth: integer
|- br_viewheight: integer
|- os_name: string
|- os_family: string
|- os_manufacturer: string
|- os_timezone: string
|- dvce_type: string
|- dvce_ismobile: boolean
|- dvce_screenwidth: integer
|- dvce_screenheight: integer
|- doc_charset: string
|- doc_width: integer
|- doc_height: integer
|- tr_currency: string
|- tr_total_base: float
|- tr_tax_base: float
|- tr_shipping_base: float
|- ti_currency: string
|- ti_price_base: float
|- base_currency: string
|- geo_timezone: string
|- mkt_clickid: string
|- mkt_network: string
|- etl_tags: string
|- dvce_sent_tstamp: timestamp
|- refr_domain_userid: string
|- refr_dvce_tstamp: timestamp
|- domain_sessionid: string
|- derived_tstamp: timestamp
|- event_vendor: string
|- event_name: string
|- event_format: string
|- event_version: string
|- event_fingerprint: string
|- true_tstamp: timestamp
+- contexts_com_google_analytics_measurement_protocol_hit_1_0_0: record (repeated)
| |- non_interaction_hit: boolean
| |- type: string
+- contexts_com_google_analytics_private_1_0_0: record (repeated)
| |- gid: string
| |- r: integer
| |- s: integer
| |- u: string
| |- v: string
+- contexts_com_google_analytics_measurement_protocol_system_info_1_0_0: record (repeated)
| |- document_encoding: string
| |- flash_version: string
| |- java_enabled: boolean
| |- screen_colors: string
| |- screen_resolution: string
| |- user_language: string
| |- viewport_size: string
+- unstruct_event_com_google_analytics_measurement_protocol_page_view_1_0_0: record
| |- document_host_name: string
| |- document_location_url: string
| |- document_path: string
| |- document_title: string
+- contexts_com_google_analytics_measurement_protocol_general_1_0_0: record (repeated)
| |- protocol_version: string (required)
| |- tracking_id: string (required)
| |- anonymize_ip: boolean
| |- cache_buster: string
| |- data_source: string
| |- queue_time: integer
+- contexts_com_google_analytics_measurement_protocol_traffic_source_1_0_0: record (repeated)
| |- campaign_content: string
| |- campaign_id: string
| |- campaign_keyword: string
| |- campaign_medium: string
| |- campaign_name: string
| |- campaign_source: string
| |- document_referrer: string
| |- google_adwords_id: string
| |- google_display_ads_id: string
+- contexts_com_google_analytics_measurement_protocol_user_1_0_0: record (repeated)
| |- client_id: string
| |- user_id: string
+- contexts_com_google_analytics_undocumented_1_0_0: record (repeated)
| |- a: string
| |- gjid: string
| |- jid: string
+- unstruct_event_com_google_analytics_measurement_protocol_event_1_0_0: record
| |- action: string (required)
| |- category: string (required)
| |- label: string
| |- value: integer
+- contexts_com_google_analytics_measurement_protocol_page_view_1_0_0: record (repeated)
| |- document_host_name: string
| |- document_location_url: string
| |- document_path: string
| |- document_title: string
+- unstruct_event_com_google_analytics_measurement_protocol_transaction_1_0_0: record
| |- id: string (required)
| |- affiliation: string
| |- coupon_code: string
| |- currency_code: string
| |- revenue: float
| |- shipping: float
| |- tax: float
+- unstruct_event_com_google_analytics_measurement_protocol_item_1_0_0: record
| |- name: string (required)
| |- transaction_id: string (required)
| |- category: string
| |- code: string
| |- currency_code: string
| |- price: float
| |- quantity: integer
+- unstruct_event_com_google_analytics_measurement_protocol_timing_1_0_0: record
| |- content_load_time: integer
| |- dns_time: integer
| |- dom_interactive_time: integer
| |- page_download_time: integer
| |- page_load_time: integer
| |- redirect_response_time: integer
| |- server_response_time: integer
| |- tcp_connect_time: integer
| |- user_timing_category: string
| |- user_timing_label: string
| |- user_timing_time: integer
| |- user_timing_variable_name: string
+- contexts_nl_basjes_yauaa_context_1_0_0: record (repeated)
| |- device_class: string (required)
| |- agent_build: string
| |- agent_class: string
| |- agent_information_email: string
| |- agent_information_url: string
| |- agent_language: string
| |- agent_language_code: string
| |- agent_name: string
| |- agent_name_version: string
| |- agent_name_version_major: string
| |- agent_security: string
| |- agent_uuid: string
| |- agent_version: string
| |- agent_version_major: string
| |- anonymized: string
| |- carrier: string
| |- device_brand: string
| |- device_cpu: string
| |- device_cpu_bits: string
| |- device_firmware_version: string
| |- device_name: string
| |- device_version: string
| |- facebook_carrier: string
| |- facebook_device_class: string
| |- facebook_device_name: string
| |- facebook_device_version: string
| |- facebook_fbop: string
| |- facebook_fbss: string
| |- facebook_operating_system_name: string
| |- facebook_operating_system_version: string
| |- g_sa_installation_id: string
| |- hacker_attack_vector: string
| |- hacker_toolkit: string
| |- i_e_compatibility_name_version: string
| |- i_e_compatibility_name_version_major: string
| |- i_e_compatibility_version: string
| |- i_e_compatibility_version_major: string
| |- kobo_affiliate: string
| |- kobo_platform_id: string
| |- layout_engine_build: string
| |- layout_engine_class: string
| |- layout_engine_name: string
| |- layout_engine_name_version: string
| |- layout_engine_name_version_major: string
| |- layout_engine_version: string
| |- layout_engine_version_major: string
| |- network_type: string
| |- operating_system_class: string
| |- operating_system_name: string
| |- operating_system_name_version: string
| |- operating_system_version: string
| |- operating_system_version_build: string
| |- webview_app_name: string
| |- webview_app_name_version_major: string
| |- webview_app_version: string
| |- webview_app_version_major: string
+- contexts_org_w3_performance_timing_1_0_0: record (repeated)
| |- chrome_first_paint: integer
| |- connect_end: integer
| |- connect_start: integer
| |- dom_complete: integer
| |- dom_content_loaded_event_end: integer
| |- dom_content_loaded_event_start: integer
| |- dom_interactive: integer
| |- dom_loading: integer
| |- domain_lookup_end: integer
| |- domain_lookup_start: integer
| |- fetch_start: integer
| |- load_event_end: integer
| |- load_event_start: integer
| |- ms_first_paint: integer
| |- navigation_start: integer
| |- proxy_end: integer
| |- proxy_start: integer
| |- redirect_end: integer
| |- redirect_start: integer
| |- request_end: integer
| |- request_start: integer
| |- response_end: integer
| |- response_start: integer
| |- secure_connection_start: integer
| |- unload_event_end: integer
| |- unload_event_start: integer
+- contexts_com_google_analytics_cookies_1_0_0: record (repeated)
| |- __utma: string
| |- __utmb: string
| |- __utmc: string
| |- __utmv: string
| |- __utmz: string
| |- _ga: string
+- contexts_com_snowplowanalytics_snowplow_web_page_1_0_0: record (repeated)
| |- id: string (required)
+- unstruct_event_com_snowplowanalytics_snowplow_link_click_1_0_1: record
| |- target_url: string (required)
| |- element_classes: string (repeated)
| |- element_content: string
| |- element_id: string
| |- element_target: string
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment