Type Casting in Staging Models #38
Description
Would it make sense to move all column type casting from the Intermediate layer down to the Staging layer, so that the column types are always set before they become function inputs? For example in the Intermediate model carrier_claim, the first cte on line 1 uses a left( ) function that will give an error if the column clm_thru_dt isn't already a string, but the field isn't explicitly cast as a string until after that on line 34 of the main query.
I'm using BigQuery and loaded some dummy LDS from CSV files, which may be why my column types weren't already correct on initial load.