Date casting issue causes silent errors in redshift

[tuvaforrest]

Describe the bug
financial_pmpm in redshift (and likely postgres) is not building individual member months for pharmacy, only grouping all spend under a null member month

financial_pmpm__patient_spend_with_service_categories.sql has this line.

The redshift dispatch of the macro requires the input format to be of one of four formats or else it defaults to null, and the call from the above model does not use one of them. that makes all of the dates null.

We can just get rid of the cast in that model. the staging model it pulls from is already casting it as a date.

To Reproduce
run the project in redshfit with pharmacy data. All records with Pharmacy as service category 1 will have a null member month. they are broken out by real member months when using other adapters

Expected behavior
pharmacy service category spend should be broken out by member months

Screenshots

Environment

• Package version (e.g. 0.6.0): 0.8.0
• Data warehouse (e.g. Snowflake): Redshift

Additional context