Error while trying to migrate data from one table to another in BigQuery
I run into a problem when trying to migrate data between BigQuery tables, I have an old table that has an attribute nested as Float64, I want to migrate the data from this old table, to another one, in which that attribute was declared as Int64, but when I put the query that extracts all the attributes and do the data type conversion, I get an error that I am trying to insert a STRING, instead of the structured object