Error while trying to generate the model (from sources)

[jfox-teine]

Expected behavior

Should be able to click on 'generate model' in sources.yml and have a model generated.

Actual behavior

An error occured while trying to generate the model. Runtime Error. Runtime Error - Cannot create cursor from closed connection.

I can execute sql, execute model and compile sql, so it can see my profiles.yml and connect to my databricks instance just fine.

Steps To Reproduce

I'm simply navigating from root>project>models>sources>sources.yml and clicking on Generate Model, then an error occurs.

Log output/Screenshots

I have my SQL datawarehouse on and just ran a query against it from Execute dbt SQL.

Operating System

Windows 10

dbt version

1.3.1 core, 1.3.2 databricks, 1.3.0 spark

dbt Adapter

dbt-databricks

dbt Power User version

v0.10.3

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

[nacruzg]

That's exactly what's happening to me at the moment.

[romiof]

Hello guys!

I can confirm that it still happens.

My versions: dbt Power User v0.13.0 VS Code 1.78.2

dbt

• installed: 1.4.6
• sqlserver: 1.4.3 - Up to date!

[alittlesliceoftom]

I get the same issue. So adding a vote

Dbt synapse 1.3.0

[stephan-meier]

Same error here.

dbt SQL-Server 1.4.6, Ubuntu 22

[cs-emre]

same error.

[mdesmet]

Similar to ##532

[DSamuylov]

Same error.

[MarvinJohannisson]

Same here. At random times i have not understood, it just starts working. But usually get this error. Also get same error when tryinh to synchronize columns with database in documentation editor.

[jagomezdiez]

Same here, mysql. errors during documentation editor query update and Generate model

[mdesmet]

Is this still an issue? If so, please reopen.