Skip to content

Instantly share code, notes, and snippets.

@o0h

o0h/new.json

Last active July 1, 2018 06:43
Show Gist options
  • Save o0h/c0047490a3d5891eebcda0d8cd4fd6db to your computer and use it in GitHub Desktop.
Save o0h/c0047490a3d5891eebcda0d8cd4fd6db to your computer and use it in GitHub Desktop.
Download ZIP
Firebase Scheme
Raw
new.json
{
"schema":{
"fields":[
{
"mode":"NULLABLE",
"name":"event_date",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"event_timestamp",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"event_name",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"key",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"string_value",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"int_value",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"float_value",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"double_value",
"type":"FLOAT"
}
],
"mode":"NULLABLE",
"name":"value",
"type":"RECORD"
}
],
"mode":"REPEATED",
"name":"event_params",
"type":"RECORD"
},
{
"mode":"NULLABLE",
"name":"event_previous_timestamp",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"event_value_in_usd",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"user_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"user_pseudo_id",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"key",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"string_value",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"int_value",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"float_value",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"double_value",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"set_timestamp_micros",
"type":"INTEGER"
}
],
"mode":"NULLABLE",
"name":"value",
"type":"RECORD"
}
],
"mode":"REPEATED",
"name":"user_properties",
"type":"RECORD"
},
{
"mode":"NULLABLE",
"name":"user_first_touch_timestamp",
"type":"INTEGER"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"revenue",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"currency",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"user_ltv",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"category",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_brand_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_model_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_marketing_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_os_hardware_model",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"operating_system",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"operating_system_version",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"vendor_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"advertising_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"language",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"is_limited_ad_tracking",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"time_zone_offset_seconds",
"type":"INTEGER"
}
],
"mode":"NULLABLE",
"name":"device",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"continent",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"country",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"region",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"city",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"geo",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"version",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"install_store",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"firebase_app_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"install_source",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"app_info",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"medium",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"source",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"traffic_source",
"type":"RECORD"
},
{
"mode":"NULLABLE",
"name":"stream_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"platform",
"type":"STRING"
}
]
}
}
Raw
old.json
{
"schema":{
"fields":[
{
"fields":[
{
"mode":"NULLABLE",
"name":"user_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"first_open_timestamp_micros",
"type":"INTEGER"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"key",
"type":"STRING"
},
{
"fields":[
{
"fields":[
{
"mode":"NULLABLE",
"name":"string_value",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"int_value",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"float_value",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"double_value",
"type":"FLOAT"
}
],
"mode":"NULLABLE",
"name":"value",
"type":"RECORD"
},
{
"mode":"NULLABLE",
"name":"set_timestamp_usec",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"index",
"type":"INTEGER"
}
],
"mode":"NULLABLE",
"name":"value",
"type":"RECORD"
}
],
"mode":"REPEATED",
"name":"user_properties",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"device_category",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_brand_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_model_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"mobile_marketing_name",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"device_model",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"platform_version",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"device_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"resettable_device_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"user_default_language",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"device_time_zone_offset_seconds",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"limited_ad_tracking",
"type":"BOOLEAN"
}
],
"mode":"NULLABLE",
"name":"device_info",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"continent",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"country",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"region",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"city",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"geo_info",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"app_version",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"app_instance_id",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"app_store",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"app_platform",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"app_id",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"app_info",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"user_acquired_campaign",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"user_acquired_source",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"user_acquired_medium",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"traffic_source",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"bundle_sequence_id",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"server_timestamp_offset_micros",
"type":"INTEGER"
}
],
"mode":"NULLABLE",
"name":"bundle_info",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"revenue",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"currency",
"type":"STRING"
}
],
"mode":"NULLABLE",
"name":"ltv_info",
"type":"RECORD"
}
],
"mode":"NULLABLE",
"name":"user_dim",
"type":"RECORD"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"date",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"name",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"key",
"type":"STRING"
},
{
"fields":[
{
"mode":"NULLABLE",
"name":"string_value",
"type":"STRING"
},
{
"mode":"NULLABLE",
"name":"int_value",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"float_value",
"type":"FLOAT"
},
{
"mode":"NULLABLE",
"name":"double_value",
"type":"FLOAT"
}
],
"mode":"NULLABLE",
"name":"value",
"type":"RECORD"
}
],
"mode":"REPEATED",
"name":"params",
"type":"RECORD"
},
{
"mode":"NULLABLE",
"name":"timestamp_micros",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"previous_timestamp_micros",
"type":"INTEGER"
},
{
"mode":"NULLABLE",
"name":"value_in_usd",
"type":"FLOAT"
}
],
"mode":"REPEATED",
"name":"event_dim",
"type":"RECORD"
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment