Hi ! Is possible to create an in-memory table using flinkSQL for a batch job ? Looks live even temporary tables requires a backing catalog/connector

There has to be a way to get the data into Flink, so that’s where the necessity of a connector comes in. You may be able to read in the data from a file, for example, with the file source, and then convert the rows from DataStream -> Table.

Sure thing but for my use case I'd like to create an in-memory table with a

CTAS

in order to reuse the resulting table of a join