kamelet-sql/src/main/resources/camel/my-route.camel.yaml

- route:
    id: "sql"
    from:
      uri: "kamelet:postgresql-source"
      parameters:
        serverName: "{{aws:postgresql/host}}"
        username: "{{aws:postgresql/username}}"
        password: "{{aws:postgresql/password}}"
        query: 'SELECT * FROM accounts'
        port: "{{aws:postgresql/port}}"
        databaseName: "{{aws:postgresql/dbname}}"
        consumedQuery: 'delete from accounts where user_id = :#user_id'
      steps:
        - to: 
            uri: "kamelet:log-sink"