Ultimate access to all questions.
As a Google Professional Data Engineer, you regularly receive CSV files from a third-party vendor on a monthly basis. However, the schema of these files changes every third month, creating a need for a dynamic data cleansing process. Your primary requirements for handling and transforming this data include automating the execution of these transformations on a set schedule, allowing non-developer analysts to easily modify the transformations, and offering a graphical interface for designing these transformations. What should you do?