Generate table with type parameters in BigQuery? (Numeric )

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.-