Incremental Materialization Problem in 1.7+

[cody-scott]

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

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

[axellpadilla]

@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]

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