SELECT

f.value as log_message,

t.*

FROM eclipse.core.fact_transactions t,

LATERAL FLATTEN(input => log_messages) f

where log_message LIKE '%Program log: Creating new domain%'

and ENDSWITH(f.value, '.turbo')