topic Databricks Free Edition - sql server connector not working- in Data Engineering

Databricks Free Edition - sql server connector not working-

RakeshRakesh_De — Thu, 12 Jun 2025 03:10:19 GMT

I am trying to explore New Databricks Free edition but SQL Server connector Ingestion pipeline not able to set up through UI..

Its showing error that --Serverless Compute Must be Enabled for the workspace,

But Free Edition only have Serverless Option and it should be enabled by default..

Then Why I am getting that error

#FreeEdition #Lakeflow #SqlServer

Re: Databricks Free Edition - sql server connector not working-

RakeshRakesh_De — Fri, 13 Jun 2025 03:15:12 GMT

Can any one please help

Re: Databricks Free Edition - sql server connector not working-

Advika — Thu, 26 Jun 2025 17:14:43 GMT

Hello @RakeshRakesh_De!

The SQL Server connector requires both classic compute (to run the ingestion gateway) and serverless compute (to execute the pipeline). Since the Free Edition only provides Serverless compute, the ingestion gateway cannot start, which may lead to the error you're seeing.

For reference: https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/sql-server-limits#pipelines

Re: Databricks Free Edition - sql server connector not working-

Saf4Databricks — Fri, 31 Oct 2025 18:19:38 GMT

Hi @RakeshRakesh_De The error is misleading. As mentioned in the second row of the table here the gateway runs on classic compute, and the ingestion pipeline runs on serverless compute (mentioned in the third row of the same table linked above). Hope this helps.