Is it possible to use a query as a source of readi...
# random
i
Is it possible to use a query as a source of reading (extracting) from postgres? I don't want to read a table. I have a complicated query that should be used to extract the data. From what I saw here: https://docs.meltano.com/guide/integration/#selecting-entities-and-attributes-for-extraction I'm under the impression I need to import the data from each table and then transform it, instead of using a query. I'm aware of the option to create a view on the DB and use it as a source. But prefer to use a query and not calling a view.