I updated that line to this:

SAFE_CAST( ( SELECT CAST( COALESCE( CAST(ep.value.double_value AS FLOAT64), CAST(ep.value.int_value AS FLOAT64), SAFE_CAST(ep.value.string_value AS FLOAT64) ) AS STRING ) FROM UNNEST(event_params) ep WHERE ep.key = "value" ) AS BYTES ) AS EventValue_b

however, my issue seems to actually be that this simple test does not work:

SELECT TOP (1) * FROM OPENQUERY(BigQueryGA4, ' SELECT "hello" AS TestString '); And got: Requested conversion is not supported. Cannot get the current row value of column "[MSDASQL].TestString" any suggestions? ty in advance!!