This will need to see the patch landing and a subsequent release of the dlt package.

• CrateDB: Add destination adapter dlt-hub/dlt#2733

A corresponding notice on the dlt repository does not raise many expectations, it looks like CrateDB might be too late to the party.

📣 New destinations are unlikely to be merged due to high maintenance cost.

@hlcianfagna: I've blatantly copied this from the Clickhouse documentation, without knowing too much about corresponding details. As I think you have expertise in this area, could you please validate this statement in the context of ingestr and CrateDB, possibly including some hands-on validations? 🙏

At least I can tell from my basic orientation flights that I have been able to use Incremental Strategy: replace successfully.

This is probably not a big surprise, as it doesn't need any database support at all?

Because this patch does not include much code at all, the topic is possibly a concern of the underlying dlt adapter.

• CrateDB: Add destination adapter dlt-hub/dlt#2733

However, we can also discuss relevant matters here, at your disposal, and also to create less noise on the dlt project.

I assume the ingestr incremental loading strategy is the same parameter that gets mapped to the dlt write disposition? In this case, the documentation about PostgreSQL's destination adapter says:

All write dispositions are supported.

So, after possibly validating all of them with CrateDB, we may want to adjust the documentation here.

That's just temporary in order to support installing from a Git branch.