Skip to content

Instantly share code, notes, and snippets.

@timhberry
Created January 17, 2023 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timhberry/210730625a86413da5c6f87373b74a97 to your computer and use it in GitHub Desktop.
Save timhberry/210730625a86413da5c6f87373b74a97 to your computer and use it in GitHub Desktop.
### BigQuery schema
country:STRING,
country_code:STRING,
region:STRING,
region_code:STRING,
city:STRING,
date:DATE,
download_kbps:FLOAT,
upload_kbps:FLOAT,
total_tests:INTEGER,
distance_miles:FLOAT
### Avro schema
{
"type" : "record",
"name" : "Avro",
"fields" : [
{
"name" : "country",
"type" : "string"
},
{
"name" : "country_code",
"type" : "string"
},
{
"name" : "region",
"type" : "string"
},
{
"name" : "region_code",
"type" : "string"
},
{
"name" : "city",
"type" : "string"
},
{
"name" : "date",
"type" : "string"
},
{
"name" : "download_kbps",
"type" : "float"
},
{
"name" : "upload_kbps",
"type" : "float"
},
{
"name" : "total_tests",
"type" : "int"
},
{
"name" : "distance_miles",
"type" : "float"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment