JSON in Google BigQuery — Finally

Still in preview, the feature is promising but has limitations when it comes to data engineering production use cases.

Big(Query) News for Data Engineering Teams

Last week, Google quietly revealed a preview of a JSON data type that is compatible with BigQuery. For data engineering teams working with messy and unstructured columns, this is a big deal. In exploring BigQuery’s compatibility (or lack thereof) with JSON I stumbled upon…




Offering original and aggregated data engineering content for working and aspiring data professionals. Content posted here generally falls into one of three categories: Technical tutorials, industry news and visualization projects fueled by data engineering.

Recommended from Medium

RPA — Do organizations Accept It?

Microservices Certification Course

Install Hortonworks HDP 3.1.0 on A Cluster of VMWare Virtual Machines

Hackathon spotlight: My chat with WebHacks winner Milky 🙌🎊🌌

Of e164, SIP, CDRs and Splunk

BurpUnlimited — Just extends BurpLoader’s license

Quick-guide on Software Pre-Cert Program (2) — Excellence Appraisal

Try Kill batch processing with unified log stream processing...

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Zach Quinn

Zach Quinn

DE @ Forbes. Pipeline: A Data Engineering Resource. Editor: Learning SQL. Opinions are my own.

More from Medium

BigQuery Hack: How to Quickly Populate a Table Without INSERT()

Black wireframe glasses looking at code.

#6 Data Engineering — EXTRACT DATA using APIs

Simple Steps to Create ETL Tool by Using Apache Airflow and Loading to BigQuery

Airflow — External Sensor