HTTP / REST connector

Materializes a JSON HTTP response as a DuckDB view.

- name: posts
  type: http
  url: "https://api.example.com/posts"
  # optional
  headers:
    Accept: "application/json"
  auth_bearer: "$TOKEN"
  method: GET

Requirements:

• Response must be JSON.
• Shape must be either a top-level array of objects, or an object with a single array property under one of data, results, items.

Caveats

• The connector fetches the full response at attach time. Huge responses will hurt. Add pagination support in your own wrapper or use a proper database.
• No streaming yet. Planned.
• No response-change detection. Re-attach to refresh.

For anything beyond trivial REST feeds, write your own connector — see connector SDK.