Google_analytics_parquet_schema.md

DESCRIBE TABLE gcs('https://storage.googleapis.com/clickhouse-website/ga-*.parquet', '<access key>', '<secret>')
FORMAT TSV

event_date    Nullable(String)
event_timestamp    Nullable(Int64)
event_name    Nullable(String)
event_params    Array(Tuple(key Nullable(String), value Tuple(string_value Nullable(String), int_value Nullable(Int64), float_value Nullable(Float64), double_value Nullable(Float64))))
event_previous_timestamp    Nullable(Int64)
event_value_in_usd    Nullable(Float64)
event_bundle_sequence_id    Nullable(Int64)
event_server_timestamp_offset    Nullable(Int64)
user_id    Nullable(String)
user_pseudo_id    Nullable(String)
privacy_info    Tuple(analytics_storage Nullable(String), ads_storage Nullable(String), uses_transient_token Nullable(String))
user_properties    Array(Tuple(key Nullable(String), value Tuple(string_value Nullable(String), int_value Nullable(Int64), float_value Nullable(Float64), double_value Nullable(Float64), set_timestamp_micros Nullable(Int64))))
user_first_touch_timestamp    Nullable(Int64)
user_ltv    Tuple(revenue Nullable(Float64), currency Nullable(String))
device    Tuple(category Nullable(String), mobile_brand_name Nullable(String), mobile_model_name Nullable(String), mobile_marketing_name Nullable(String), mobile_os_hardware_model Nullable(String), operating_system Nullable(String), operating_system_version Nullable(String), vendor_id Nullable(String), advertising_id Nullable(String), language Nullable(String), is_limited_ad_tracking Nullable(String), time_zone_offset_seconds Nullable(Int64), browser Nullable(String), browser_version Nullable(String), web_info Tuple(browser Nullable(String), browser_version Nullable(String), hostname Nullable(String)))
geo    Tuple(city Nullable(String), country Nullable(String), continent Nullable(String), region Nullable(String), sub_continent Nullable(String), metro Nullable(String))
app_info    Tuple(id Nullable(String), version Nullable(String), install_store Nullable(String), firebase_app_id Nullable(String), install_source Nullable(String))
traffic_source    Tuple(name Nullable(String), medium Nullable(String), source Nullable(String))
stream_id    Nullable(String)
platform    Nullable(String)
event_dimensions    Tuple(hostname Nullable(String))
ecommerce    Tuple(total_item_quantity Nullable(Int64), purchase_revenue_in_usd Nullable(Float64), purchase_revenue Nullable(Float64), refund_value_in_usd Nullable(Float64), refund_value Nullable(Float64), shipping_value_in_usd Nullable(Float64), shipping_value Nullable(Float64), tax_value_in_usd Nullable(Float64), tax_value Nullable(Float64), unique_items Nullable(Int64), transaction_id Nullable(String))
items    Array(Tuple(item_id Nullable(String), item_name Nullable(String), item_brand Nullable(String), item_variant Nullable(String), item_category Nullable(String), item_category2 Nullable(String), item_category3 Nullable(String), item_category4 Nullable(String), item_category5 Nullable(String), price_in_usd Nullable(Float64), price Nullable(Float64), quantity Nullable(Int64), item_revenue_in_usd Nullable(Float64), item_revenue Nullable(Float64), item_refund_in_usd Nullable(Float64), item_refund Nullable(Float64), coupon Nullable(String), affiliation Nullable(String), location_id Nullable(String), item_list_id Nullable(String), item_list_name Nullable(String), item_list_index Nullable(String), promotion_id Nullable(String), promotion_name Nullable(String), creative_name Nullable(String), creative_slot Nullable(String)))
collected_traffic_source    Tuple(manual_campaign_id Nullable(String), manual_campaign_name Nullable(String), manual_source Nullable(String), manual_medium Nullable(String), manual_term Nullable(String), manual_content Nullable(String), gclid Nullable(String), dclid Nullable(String), srsltid Nullable(String))
is_active_user    Nullable(Bool)