Investigating a Failing DBT Test Part 1: Find the compiled SQL

video1.0<iframe src="https://www.loom.com/embed/0bf1eaa6d3374be782eb18859f24e08f" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/0bf1eaa6d3374be782eb18859f24e08f-00001.gif227Investigating a Failing DBT Test Part 1: Find the compiled SQLIn this video, I will guide you through investigating a failing DBT test. We received a notification in Sentry about a uniqueness test failure on the effect monthly routes table's key column. I will show you how to find the compiled SQL for this failing test so that you can investigate it. You will need to open a terminal in JupyterLab, navigate to the data info repo, and run "poetry, run dbt compile" to compile all the SQL. Once completed, you can locate the compiled SQL in the data info repo. Stay tuned for the next steps on how to run and investigate the SQL further.