Create a gist now

Instantly share code, notes, and snippets.

@o0h /new.json
Last active Jul 1, 2018

Embed
What would you like to do?
Firebase Scheme
{
"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"
}
]
}
}
{
"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