sqlmesh
sqlmesh copied to clipboard
TobikoData
Efficient data transformation and modeling framework that is backwards compatible with dbt.
This now supports alternative DuckDB extension repositories like the built-in `community`. ```yaml gateways: bq: connection: type: duckdb extensions: - name: bigquery repository: community force_install: true catalogs: mem: ':memory:' bq: type:...
Issue created based off of [this thread](https://tobiko-data.slack.com/archives/C044BRE5W4S/p1727901208329819). Previously, non-blocking audits would log an audit error message when running plan. Currently, it no longer does. To reproduce this: ``` MODEL (...
Related to #3070 NOTE I know I need to revert a number of unnecessary format changes. A few thoughts: - [ ] I don't think this is tested enough because...
Converting an `INCREMENTAL_BY_TIME` model to a `VIEW` model as a forward-only plan fails in BigQuery
The generated query from sqlmesh is something like ``` CREATE OR REPLACE VIEW ... ``` But BigQuery fails with the following error: ``` is not allowed for this operation because...
_Let me preface by saying, that I understand the clickhouse engine is still very new._ After some considerable work on our side to get try to get things to work...
Hi, We have the practice of creating UX views for our facts & dimensions, that shows them with "readable" column names. The UI currently breaks when we have "%" in...
Assuming model `foo.bar` has some downstream dependencies, it would be useful to see which models will be affected by a `restatement` plan before applying it.
# Store SQLMesh Audit Failures for Later Consumption ## Summary Add an option to `sqlmesh audit` to store failed audit results in a table for later analysis and reporting. ##...
[Secure views](https://docs.snowflake.com/en/user-guide/views-secure#overview-of-secure-views) are feature in Snowflake that allows engineers to obfuscate the view query code and must be used when sharing views across Snowflake Account using [Snowflake Data Sharing](https://docs.snowflake.com/en/user-guide/data-sharing-provider#general-data-sharing-considerations-and-usage). Because...
Assuming the following: ```sql MODEL(name full_with_signal, kind FULL, cron '@daily', signals=[(kind=SomeSignal)]); select * from external_table ``` and ```sql MODEL(name other_full, kind FULL, cron '@daily'); select * from full_with_signal ``` When...
Metadata
Owner
Metadata
Efficient data transformation and modeling framework that is backwards compatible with dbt.