The problem I’m having
Hello. I’m new using dbt and Bigquery
I’d like to create a table using SELECT and have parameterized types (ex. NUMERIC(4,7))in big query , but when compiling dbt says it doesnt allow parameterized
The context of why I’m trying to do this
I’m working in dbt with strict instructions (basically we can use only SELECT to create tables) and I would like to have the type NUMERIC(7,4) in the types in GCP
What I’ve already tried
CAST, SAFE_CAST in the query, not working.-