Some exciting new features just dropped for @SQLMesh v0.100! Snowpark's DataFrame api is now available to use in Python models! Now you can leverage the power of Python and Snowpark to run advanced transformations that run directly on Snowflake! Python models are super easy to write and debug with SQLMesh because they run wherever you run SQLMesh. The driver code runs on your laptop while the distributed code (dataframe api) runs in the warehouse. It's the best of both worlds! Another really cool feature we've added is the new Incremental by Partition model kind / materialization. These are special models that will incrementally replace partitions while keeping existing partitions intact. For example, if you have a dataset that is partitioned by country, and every day, you want to only refresh a set of countries. sqlmesh.readthedocs.io/en/st… sqlmesh.readthedocs.io/en/st…