I have an incremental model set up in DBT CORE. I already know to distinguish new and old records in a query.
Now I would like to use DBT post_hook to send REST request (POST) with those ids to an endpoint (my backend), i.e.
{{ config(materialized="incremental", .., post_hook=" {{ send_to_endpoint(ids) }} ") }}
where send_to_endpoint(ids) is a dbt macro. And after many hours of struggle I still haven't figured out how to do that and now even doubt that it is even possible. Can anybody help? :)