December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
When to transform your data? Before or after loading to BigQuery?
There are a couple of phases in the ETL process when an analyst might want to transform their data. BigQuery is a very sophisticated data warehouse system. Because of this, BigQuery has already implemented a number of functions useful for transformation. With that said, BigQuery does not have every function that you might find in other data warehouses or programming languages. Also, BigQuery's automatic type detection sometimes might coerce a data type with unwanted results. Because of this, the analyst will need to make a decision as to how much transformation he or she wants to apply to the data prior to loading it in BigQuery.
Chapter 8 cover Google Cloud Dataprep which ...