sqlmesh

sqlmesh copied to clipboard

loader.reload_needed() doesn't take into account new files

2

crericha

Support automatic table properties for Redshift/Snowflake and Incremental by Time models

2

Snowflake should define the time columns as part of the `cluster_by` key. Redshift should define it as part of it's `sort_key` key. We need to make sure that if a...

eakmanrq

Right now if someone happens to run the SQLMesh state migration while there is an ongoing plan application, it may lead lead to unexpected results, lost data intervals and even...

izeigerman

Add notify_user to airflow

1

Airflow doesn't use the scheduler so doesn't alert on audit failures. Either engines/commands.py needs to start doing that, or perhaps we move the notification into the snapshot_evaluator directly so that...

tobymao

Add a variable that can be used to access a specific model's latest interval. Ex: I have `db.user` model. To access latest date string I would do: ``` WHERE ds...

eakmanrq

target.schema should return the schema for the environment being evaluated

2

dbt users expect target.schema to point to the schema for their active environment (aka target). sqlmesh should match that behavior to support run-time adapter queries that dynamically fetch tables.

crericha

Currently if an error occurs during snapshot table creation it immediately bubbles up, causing termination of the creation process. We should instead attempt to create tables for all snapshots for...

izeigerman

Add an option to `sqlmesh plan` to use rendered model queries for diffing

1

This should help investigate issues which occur due to non-deterministic nature of some macros which result in unexpected creation of new model snapshots.

izeigerman

Docker example

2

I, and probably others as well, would greatly appreciate having some documentation and an example `Dockerfile` for running sqlmesh on container-based cloud hosts, such as Google Cloud Run. To make...

gunar

crericha