Mike Wallis

Pretty SQL before sending to execution engine

9

A small request I hope. Would it be possible to use SQLGlot's pretty functionality before executing SQL statements? It would be much easier to find syntax issues if it wasn't...

When matched ambiguous name

5

I tried to use the when_matched configuration property to add a condition but the target placeholder wasn't substituted. If we take the structure of the example you provide then it...

Trino SQL split trailing semi-colon

14

### Apache Airflow version Other Airflow 2 version (please specify below) ### What happened We're currently using Airflow 2.6.1 but I believe the issue persists in the latest versions. The...

Environments for audits

4

The problem I faced was 2 fold. I wanted to update an audit and test it. The audit was user defined and involved joins to other models within the project,...

Trino demotion issue when moving between catalogs

4

When promoting a model that has changed catalogs in Trino (in this example Hive -> Iceberg) we end up with an unsupported format error. I think what's happening is that...

Document standalone audits

1

As part of this issue I raised #3665 I discovered this functionality within sqlmesh isn't covered in the documentation.

Pickling error for custom model kind

2

SQLMesh Version: 0.174.2 (but I believe the problem still persists) Dialect: Trino State: Postgres I created a custom materialization to override the default use of MERGE for INCREMENTAL_BY_UNIQUE_KEY in Trino...