oso icon indicating copy to clipboard operation
oso copied to clipboard

Try Dagster embedded-elt for database replication

Open ryscheng opened this issue 9 months ago • 3 comments

What is it?

We've been having all sorts of issues with the Airbyte connector. See this issue for a summary https://github.com/opensource-observer/oso/issues/1229

Dagster seems to have built-in support for ELT using Sling https://docs.dagster.io/integrations/embedded-elt

We can try this instead to see if that can auto-magically work with fewer modifications

ryscheng avatar Apr 29 '24 23:04 ryscheng

Here's the Sling documentation for replication https://docs.slingdata.io/sling-cli/run/examples/database-to-database

ryscheng avatar Apr 29 '24 23:04 ryscheng

Apparently we can choose between dlt or Sling

https://docs.dagster.io/integrations/embedded-elt/dlt

According to @ravenac95 they have better docs on how to write a connector

ryscheng avatar Apr 30 '24 16:04 ryscheng

Another possibility is CloudQuery

https://github.com/cloudquery/cq_dagster_embedded_elt

ryscheng avatar Apr 30 '24 16:04 ryscheng

https://github.com/opensource-observer/oso/pull/1733 Done

ryscheng avatar Jul 02 '24 17:07 ryscheng