Ryan Eakman

Results 15 issues of Ryan Eakman

If Redshift gets a VARCHAR column of an uncertain precision it will default the value to 256. For users who aren't explicitly defining columns to types or casting columns this...

Improvement
Engine: Redshift

Due to [Redshift's auto table optimization](https://docs.aws.amazon.com/redshift/latest/dg/t_Creating_tables.html) it is possible that a user would have a forward-only table that needs to have a column dropped that is part of the distkey...

Improvement
Engine: Redshift

Currently there are some cases where a job can get an exception and then leave the check status as "running" even though it failed. Basically make sure everything is wrapped...

Bug

Conceptually the goal is to allow users to defined Python, Scala, or Java UDFs and SQLMesh would take care of making sure those functions are compiled and defined on the...

Feature

If a model has data loaded in it that is less than the model start date then we get an error like this: ``` ValueError: `end` (2023-10-04 00:00:00+00:00) must be...

Bug

Currently if a snapshot is unpaused (applied to prod) then existing environments will continue to point to the temp table despite the fact that the change is now live in...

Improvement

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

Improvement

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

Feature

This adds a macro that users can utilize in their incremental pipelines to make it easier to filter tables based on a date range. By default it filters based on...

Feature