Hi everyone! I have some data in a postgres database (AWS Aurora). I want to extract some data using a query, and dump it onto an S3 destination bucket. I know I can configure postgres as a source and S3 as destination. Is there a way in Airbyte to specify the query to be run at the source to extract the data? Like

SELECT department, count(distinct employeeId)
FROM Employee
GROUP BY department

Then the result of this query will be dumped on the S3 target.

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2463 to ensure timely resolution!

Hey when you run the schema discovery you should see the tables there and later you can use custoom DBT to basically run analytics over it.

Hey @Tanmay Kulkarni, did we answer you question! Let us know and feel free to post more questions in the channel 🙂