What is BigQuery Dataprep? 

“BigQuery dataprep” is a question asked of analysts that have transitioned to Google Cloud Platform and its serverless data warehouse, BigQuery, but for whom data quality remains a barrier to analytic success. In other words, how do you clean up data stored in BigQuery? Of the many strengths of Google BigQuery—incredible performance and scalability, to name a few—BigQuery dataprep is not one. To complete BigQuery dataprep, analysts leverage another Google Cloud service, Cloud Dataprep by Trifacta. 

Cloud Dataprep by Trifacta is an intelligent data service specifically designed to explore, clean, and prepare structured and unstructured data for analysis. As a native Google Platform service, Cloud Dataprep by Trifacta offers the same serverless benefits of BigQuery, removing the need for up-front software installation or ongoing operational overhead. Cloud Dataprep by Trifacta also integrates seamlessly with BigQuery, thereby allowing for BigQuery dataprep. Analysts can perform BigQuery dataprep with data stored in Google BigQuery, on Google Cloud Storage,  or with data stored on their desktop that can then be uploaded to BigQuery.