sql - BigQuery IF field exists THEN

Question

I'm running a query over multiple tables unioned together over a particular time range.

In the past, a particular field did not exist in the "schema" but about halfway through that time range, the field began its existence and started getting populated with data.

Is there a way to conditionally select it if it exists, else arbitrarily populate a named field with a value?

like this:

SELECT
  (CASE WHEN exists(my_field) THEN my_field ELSE "0" END) as "my_field"
FROM <somewhere>

Answer 1

Waitting for answers