Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
require some effort to learn how to query it properly, and many metadata tools (data catalogs, data diff, etc.) don’t support nested structures very well yet. But enough digressing. That subject alone would deserve a whole article, so let’s go back to the task at hand. Step 2: Merging the Two