[Feature] Restructure the tmp models to leverage the new empty table feature in union data

Is there an existing feature request for this?

[X] I have searched the existing issues

Describe the Feature

The latest release of the fivetran_utils package allows us to instinctively infer if the source table the package is using is in fact present, if it is not the package will create an empty table to ensure the downstream transformations succeed.

However, the Stripe package is not currently compatible with this feature due to the livemode_predicate which exists in the *_tmp staging models. In order for the new empty data model creation to be successful in the Stripe package, we will need to move this predicate macro to the non *_tmp staging model.

Describe alternatives you've considered

Not leveraging the new empty model creation feature within the tmp models.

Are you interested in contributing this feature?

[X] Yes.
[ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
[ ] No.

Anything else?

No response

fivetran / dbt_stripe_source