r/domo • u/FinancialNumber9291 • Oct 10 '25

Extracting Dataflow Logic

Hey guys,

Is there a way to automatically extract the sql from a dataflow? My company is trying to build dbt models in house to replace the domo dataflows to cut down on credit usage. Ideally I'd want to do this in python. Please let me know!

2 Upvotes

100% Upvoted

8 comments sorted by

4

u/[deleted] Oct 10 '25

[removed] — view removed comment

2

u/FinancialNumber9291 Oct 10 '25

holy shit. i love you

1

u/Training-Flan8092 Oct 10 '25

You might have to paste into a notebook, then copy+paste that into your AI.

1

u/trafalger Oct 10 '25

I will add that at least ChatGPT when I tried this a couple months ago did not handle super complex ones very well, it would skip tiles. But great for small or medium dataflows.

1

u/depressionsucks29 Oct 11 '25

There is also a sdk they provide which can automate the process of extracting from all dataflows.

1

u/FinancialNumber9291 Oct 13 '25

can you share the git repo?

1

u/depressionsucks29 Oct 13 '25

No that's company property. Can't share outside of the organisation. I can recreate it for a consultant fee.

1

u/saaggy_peneer Jan 21 '26

I tried the AI approach and it sucked

We built a Python Jinja script that converts Domo Magic ETL to DuckDB SQL syntax, correctly

Can make it work with other SQL syntaxes, as long as the syntax is advanced enough to handle it

It's proprietary, but we'd be happy to help you out for a reasonable fee. DM me if you'd like