QuestionQ61

Maintaining and automating data workloads

Your company generates reports from data stored in BigQuery. You have found that some fields in the weekly executive reports do not conform to company formatting standards. For example, errors include differing telephone-number formats and country-code identifiers. Because this occurs frequently, you need to create a recurring job that normalizes the data. You want a quick, no-code solution. What should you do?

Explanation

Cloud Data Fusion Wrangler is a visual data-preparation tool for cleaning and transforming data, including applying transformation recipes in ETL pipelines. Cloud Data Fusion supports schedules for deployed pipelines, enabling the normalization to run repeatedly without writing code.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!