topic Re: Lakebridge Transpile paths in Data Engineering

Lakebridge Transpile paths

Fikrat — Mon, 18 Aug 2025 13:37:34 GMT

Hi there,

What kind of source and target paths can I use in Transpile command?
I'm trying to run command:
databricks labs lakebridge transpile --source-dialect tsql --input-source

and I get error:

ERROR [src/databricks/labs/lakebridge.transpile] ValueError: Invalid path for '--input-source', does not exist XXX
Error: unexpected end of JSON input

I tried using dbfs paths as well as my local paths, and it didn't work.

Re: Lakebridge Transpile paths

szymon_dybczak — Mon, 18 Aug 2025 14:26:36 GMT

Hi @Fikrat ,

First of all make sure that you're using newest version of databricks lakebridge. In newest version --source-dialect supports following values:

- datastage

- informatica (desktop edition)

- informatica cloud

- mssql (your case)

- netezza

- oracle

- synapse

- teradata

Now, --input-source argument expect absolute path to a file that contains sql to transpile.

In my case, I've installed lakebridge on my PC following official guide. Here's how I executed command. It worked without any issue.

Here's a status of successful transpilation process:

Official guide:
Transpile Guide | Lakebridge

Re: Lakebridge Transpile paths

Fikrat — Mon, 18 Aug 2025 15:03:22 GMT

Thanks, @szymon_dybczak , that resolved my initial problem and I was able to run command fine. Is it possible to run Transpile from notebook as well? The official document includes example of using Reconcile from notebook, but not sure about Transpile.

Thanks!

Re: Lakebridge Transpile paths

Fikrat — Mon, 18 Aug 2025 15:10:10 GMT

Also, what cloud source locations are available for Transpile- dbfs, Unity Catalog volumes, etc?

Re: Lakebridge Transpile paths

szymon_dybczak — Mon, 18 Aug 2025 15:10:16 GMT

Hi @Fikrat ,

Great that it worked for you 🙂 And yes, I think it should work from notebook as well

Re: Lakebridge Transpile paths

Fikrat — Mon, 18 Aug 2025 15:49:26 GMT

Excellent, would you be able to provide a sample code or any reference material on that?

Re: Lakebridge Transpile paths

szymon_dybczak — Mon, 18 Aug 2025 15:56:32 GMT

Basically, follow the same steps as in guide to which I've shared a link above. If you will have trouble with installation, let me know and tomorrow I can try to create it on my databricks instance 😉

Re: Lakebridge Transpile paths

Fikrat — Mon, 18 Aug 2025 19:00:44 GMT

I didn't find any info on usage of Transpiler classes from python in that guide, that's why asked. But it's okay if you don't have answers. This product is new and documentation they provided is scarce, so hopefully they add more materials soon.

Thanks!