[Feature] Add `partition_by_source_relation` macro

[fivetran-catfritz]

We need add the partition_by_source_relation macro to prevent the Redshift constant expression error. Here is the PR with the updates to roll into the next release.