search

TobikoData / sqlmesh

Efficient data transformation and modeling framework that is backwards compatible with dbt.
https://sqlmesh.com
Apache License 2.0
1.83k stars 161 forks source link

Fix: Support coercion of BIGNUMERIC values into FLOAT64 for BigQuery #3417

Closed izeigerman closed 1 day ago

izeigerman commented 1 day ago

Even though BIGNUMERIC is not compatible with FLOAT64 when it comes to column alteration, BIGNUMERIC values can still be safely inserted into FLOAT64 columns. This update ensures that SQLMesh can do this without needing to drop and recreate a column.