sqlmesh icon indicating copy to clipboard operation
sqlmesh copied to clipboard

Efficient data transformation and modeling framework that is backwards compatible with dbt.

Results 105 sqlmesh issues
Sort by recently updated
recently updated
newest added

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...

Bug

Adds support for using Serverless compute from a notebook. I tested by plan/applying using a Serverless environment. Two key changes: * Serverless does not support global temp views but does...

Context around `exp.AlterTable -> exp.Alter`: https://github.com/tobymao/sqlglot/commit/0428c37e11f42be8eba352e69c1d2e7425824d38

This update contains the following performance improvements to the state sync: - Add dev intervals in bulk for new forward-only snapshots. Previously they were added one interval at a time....

This PR makes the `columns_to_types` method more lenient by leveraging any existing snapshots in the evaluator's context as a fallback to fetch the target model's schema. The motivation can be...

The goal of this PR is to bring a lot of UX familiarity from dbt-utils into SQLMesh native macros similar to the deduplicate macro I just contributed. dbt-utils version of...

An update to the dbt adapter to resolve sources' tables from an external location when specified in the source metadata, rather than using schema and table names, fixes: #2988

I'm using sqlmesh+dbt+duckdb. I have declared my sources as follows: ![image](https://github.com/user-attachments/assets/03ed0a7b-8d43-4c60-8f86-99788103d1d0) In my model, upon using the source jinja function, I get an error: ![image](https://github.com/user-attachments/assets/e5dc8423-c9ee-4d41-a1e0-030b495c4998) ``` Traceback (most recent call...

Engine: DuckDB

Hi there, What is the proper way to UNNEST a JSON array? I have following JSON structure saved in a `raw` column of my table : ``` { "post_id": "1",...

Project: UI

As a follow up to the https://github.com/tobymao/sqlglot/pull/3577 PR, starting the initial work to add the SQLMesh Materialize engine adapter. This is still WIP, just starting with the initial work.