Professional Data Engineer

By Google · Question Mode

QuestionQ45

Maintaining and automating data workloads

You receive CSV data files every month from a third party. You need to cleanse this data, but the file schema changes every third month. Your requirements for implementing these transformations include:

  • Running the transformations on a schedule
  • Allowing non-developer analysts to modify transformations
  • Supplying a graphical tool to design transformations

What should you do?

Explanation

Dataprep by Trifacta supports visual, no-code creation and maintenance of reusable transformation recipes, enabling analysts to adapt recipes when source schemas change. Its flows can also be scheduled for recurring execution, satisfying both the operational scheduling and analyst-friendly graphical design requirements.

Learn more

Community Discussion

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