I know Dremio supports queries like this,
SELECT count(*) FROM table_a, table_b, table_c
But I’m looking to retrieve a whole month of data, like table_0901, table_0902, … , table_0930
so is there a way to do
SELECT count(*) FROM table_09*
I tried but it gave me this error: Table_09* not found.