Fetch generated SQL queries for the checks configured in context about soda-core

[jmarien]

SODA-1786

[scchengaiah]

SODA-1786
@jmarien Could you please share the respective link or elaborate ? Is there an issue already opened for this.

[benjamin-pirotte]

Hi @scchengaiah, thank you for reaching out!

The previous message was an automatic message triggered by the integration with our ticketing system.

I will reach out to the engineering team to see if there is a current workaround to achieve what you are describing.

Out of curiosity, could you let me know why you want to extract the generated SQL?

Thanks a lot!

[scchengaiah]

@benjamin-pirotte :
Thank you for the response.

We want to use SQL parsers to detect the tables and the columns involved from the generated SQL query and link to the failed checks.

We believe that this can help our data analysts to quickly get the relevant information on a particular check in case of complex SQL statements. Also, the generated SQL shall be executed manually which can help to decide the next set of actions.

[scchengaiah]

@benjamin-pirotte : Do we have any update from the engineering team ?