sqlmesh
sqlmesh copied to clipboard
Efficient data transformation and modeling framework that is backwards compatible with dbt.
Bumps [yaml](https://github.com/eemeli/yaml) from 2.8.0 to 2.8.1. Release notes Sourced from yaml's releases. v2.8.1 Preserve empty block literals (#634) Commits 1dc3c3b 2.8.1 5bbb1cb chore: Add explicit jest-resolve@29 dev dependency to keep...
### Description Running `sqlmesh rollback` after downgrading from sqlmesh 0.224.0 to 0.209.0 raises a PostgreSQL dependency error. The process attempts to drop table `sqlmesh._snapshots` while view `sqlmesh.model_snapshots` still depends on...
SQLMesh version: sqlmesh==0.209.2 Postgres 16 I need to use Postgres roles to give access rights to specific tables in SQLMesh. `MODEL ( name sandbox.sumsub_checks_access, kind VIEW ); SELECT *, CASE...
I've noticed a few times that when I run `sqlmesh plan` or `sqlmesh create_external_models` it then chugs along in the background for anywhere from a few seconds to a minute...
## Description We've encountered limitations when trying to implement audits that work consistently across both incremental models and view models in SQLMesh. Specifically, temporal macros like `@start_date` and `@end_date` are...
When using the SQLMesh VSCode extension with dbt, the language server crashes due to malformed protocol messages. Specifically, extra log lines are mixed into the LSP stream, producing errors like:...
Apologies if I missed it in the docs. But there are a [few ducklake-specific configuration options](https://ducklake.select/docs/stable/duckdb/usage/configuration) that would be nice to add to the sqlmesh ducklake config. An alternative is...
- **feat: first draft of a daemon** - **feat: first step of daemon mode (not ready)**
AWS has introduced a feature called [S3 Tables](https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables.html) where specific [table buckets](https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-buckets.html) in S3 are designated for storage of data in lakehouse formats (eg Iceberg). This brings some benefits: -...
**Describe the bug** I am using SQLMesh with DuckDB as an intermediate engine to transfer data from a MySQL source to a PostgreSQL destination. This setup is necessary because SQLMesh...