sqlmesh

sqlmesh copied to clipboard

Added support for METADATA_SCHEMA in ducklake config.yml

5

### Summary Add support for the METADATA_SCHEMA configuration option for DuckLake catalogs in DuckDB connections. This allows users to specify which schema in the catalog server should store DuckLake metadata...

justbry

**SQLMesh Version:** 0.226.0 **Description:** The SQLMesh VSCode extension currently has limited support for environment variables referenced in `config.yaml` using the `{{ env_var('...') }}` syntax, particularly for Snowflake connection credentials like...

SebZbp

fix: CI/CD Bot exit early before applying plan on unmergeable PR

1

**What does this PR do?** On final step of CI/CD, applying plan to prod, exit early (raise an error) _before_ applying plan to prod if the PR merge state status...

bcrant

Observed in sqlmesh[databricks] v0.224. Seed models with Boolean columns having NULL values are coerced to False in the INSERT query. The ideal behavior would be to leave NULLs as is...

saipraveenpn

Hello, are there any plans to add Exasol support to sqlmesh? Note: Exasol is already supported by sqlglot. Best regards

raayu83

Feat: Add Doris adapter

4

Engine Adapter Implementation Doris Adapter: Implemented `DorisEngineAdapter` to support Doris-specific SQL behavior (`sqlmesh/core/engine_adapter/doris.py`) Connection Configuration Doris Connection Config: Added a new `DorisConnectionConfig`, including support for basic authentication and configurable HTTP...

xinge-ji

# Description FULL model refreshes currently use `DELETE ... WHERE TRUE` (sqlmesh `0.226.0`, Postgres engine). For large, indexed tables this is significantly less efficient than creating a new table and...

petrikoro

default_test_connection doesn't accept config shown in docs

1

https://sqlmesh.readthedocs.io/en/stable/guides/connections/#default-test-connection > ``` > default_test_connection: > type: duckdb > database: test.db > ``` My config.yaml: > ``` > default_test_connection: > type: duckdb > database: test.db > ``` ``` % sqlmesh...

martinburch

Fix: Include column types in Databricks materialized views with comments

1

## Summary - Fixes an issue where Databricks materialized views with column comments were missing column type definitions - Databricks requires column types to be explicitly specified in CREATE MATERIALIZED...

afredojala

When the second argument in an `@EACH()` function call matches a column in the node, it seems to be ignored. _SQLMesh definition_ ```sql SELECT organization_id, @EACH( @product_families_simple, product -> (...

tjirab