How to link Checks to their SQL Queries in scan results?

[moucode]

Hello,

I'm using Soda Core 3.5.2 with the Soda Library Python API to implement data quality monitoring. We use the scan.get_scan_results() method which returns a dictionary containing:

checks[] - our data quality check results
queries[] - the SQL queries executed during the scan
metrics[] - the metric values

Our Challenge
We need to establish a relationship between checks and their corresponding queries to store them in a relational database structure. We want to be able to query which SQL was executed for a specific check, especially for failed checks.

What we've observed

1. Each check in checks[] has various metadata (identity, name, type, outcome, etc.)
2. The queries[] array contains SQL queries with names, durations, and SQL text
3. We need to understand how these two arrays relate to each other

My Questions

1. What is the correct way to link a check to its executed SQL queries? Is there a specific field or pattern i should use?
2. How can I determine which query (or queries) were executed for a specific check?

Any guidance on how to establish this relationship would be greatly appreciated!

[tools-soda]

CLOUD-9202