Iaroslav Zeigerman comments

Results 78 comments of


                                            Iaroslav Zeigerman

SQLMesh hangs during plan execution when a composite primary key column is NULL

Hey @harnitbakshi , this reproducible example is amazing. Also, great job identifying the root cause of the issue. I've refactored the implementation to get rid of recursive calls in that...

feat(bigquery): Add support for Bigquery reservations in config

This looks good once the build is green

Accessing the schema of an upstream model in a sql-model-defined-with-python

> Documentation for python models says - specifying depends_on takes precedence over SQLmesh resolving the dependencies. Yeah, I think this documentation is out of date. I think there's a bit...

Accessing the schema of an upstream model in a sql-model-defined-with-python

After additional deliberation it turned out that I was wrong about my initial conclusion. @ananis25, your initial implementation should work with one caveat: the `columns_to_types` will not be available when...

SCDType 2 tests for value_from and value_to

I suspect that this happens because of the column name overlap with the default `valid_from` and `valid_to` column names configured as part of the SCD2 model kind. These columns are...

Concurrent runs leads to duplicate rows

I believe this happens because the transaction isolation in your postgres instance is set to READ COMMITTED or below. So I think the following happens: 1. DELETE from the first...

Concurrent runs leads to duplicate rows

I see now, @simon-pactum. I think we could lock the table before doing the insert with ``` LOCK TABLE IN EXCLUSIVE ```

TLS 1.3 connection issue

Can you please share the error or any other output that SQLMesh produces. Logs would help too. Thanks