Query: Get the latest execution status of tasks

Description

This query retrieves the latest execution status for each task, including the state, trigger, and any messages associated with the last job execution.

Query

Tables used in this query:

• gcp_dataplex_task

SQL