This is on my list of things to test, but it's a long list 😉
If I have keyed my table w/ the business keys + last update date ( AsOfDate ) and I just copy/paste my query into the "incremental query" section of the data source it should still work as intended, right?
Any new records would be added including "new" records based on the last update date.
What the "where" clause buys me is a potentially faster load-time because I'd be querying a small subset of all the data.
I *think* the cost of doing it w/out a where clause - in addition to longer load-times - might be larger parquet files for each incremental update? But I'm not completely sure how or if that's a showstopper.