Athena Compatibility - Githubissues

Describe your changes

explicitly cast all columns to the same data type that are being concatenated together if they are different data types
- example: (claim_id||'-'||cast(claim_line_number as {{ dbt.type_string() }}
left() and right() replaced with substring()
removed USING clause in join
renamed normalized to normalized_cte
removed qualify statement and added cte
replaced floats with {{ dbt.type_float() }}
replaced numeric with {{ dbt.type_numeric() }})
using datediff instead of subtracting dates
using double quotes to for quote inside of string
removed insights mart as it had a lot of issues above and we will be replacing with data quality mart

(Credit to @sanrodari for initially getting the Tuva Project to run on AWS Athena. Awesome work!)

successfully ran in athena enviro

[ ] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
[ ] My code follows style guidelines
[ ] (New models) YAML files are categorized by sub folder and models listed in alphabetical order
[ ] (New models) I have added a config to each new model to enable it for claims and/or clinical data
[ ] (New models) I have added the variable tuva_last_run to the final output
[ ] (Optional) I have recorded a Loom to explain this PR