Tal Sheldon
10/01/2023, 7:09 PMUNION ALL
for 80 different (kafka) tables - each one has filters, and different schema.
Since the schema is different for each table, I guess I need to add to the SELECT
of each query - CAST(NULL AS STRING) AS ..
for each field missing, so all SELECT statements will be aligned with the same types and number of fields - any better way you can think of 🙂 ? I’m wondering if there is a better / readable / best practice way to do it.
The purpose of this query is to do stateless operations (filtering only).Dave Filonuk
10/03/2023, 3:54 PMTal Sheldon
10/09/2023, 12:47 PM