Incremental Materialization Problem in 1.7+

dbt-msft / dbt-sqlserver

dbt adapter for SQL Server and Azure SQL

MIT License

216 stars 101 forks source link

Incremental Materialization Problem in 1.7+ #517

Open cody-scott opened 3 months ago

cody-scott commented 3 months ago

Incremental materializations don't seem to be performing properly since 1.7.

See thread https://github.com/dbt-msft/dbt-sqlserver/discussions/481

axellpadilla commented 2 months ago

@cody-scott could this just be related to database permissions?, if the user doesn't have the full permissions to read information schema, an empty result will be returned and that will make it not incremental, it works fine on my admin one

cody-scott commented 2 months ago

Great point @axellpadilla. I will try this next week!