Forum Discussion

Frequent Visitor

2 years ago

Solved

Unable to call sparksql methods in VSCode-Fabric integrated Notebook

I'm trying to get my VSCode -> Fabric integration working. I've been through this thread many times, and it was instructive and helpful. -- I've installed the prereqs listed in the docs, have ...

data science

Anonymous
2 years ago
Hi robkerrdm
Please note that you should use openjdk8 instead of openjdk21. Download openjdk8 and set the environment variable.

You can refer to this document for more information:
https://learn.microsoft.com/en-us/fabric/data-engineering/setup-vs-code-extension

Hope this helps. Please let me know if you have any further questions.

Anonymous

Not applicable

2 years ago

Hi robkerrdm

Thanks for using Fabric Community.

1) We only support %pip in current version, other magic commands are not supported yet.

2) Can you please confirm that the Java version which you are using is OpenJDK 8 ?

3) Select the right spark runtime version. You can set environment in notebook in the portal, if you use fabric spark 1.2, you need to choose fabric-synapse-runtime-1-2 kernel when running code in VS Code.

Hope this helps. Please let us know if you have any further questions.

garys12

New Member

2 years ago

Hi Guys,

When will %%sql magic commands start working in vs code when running fabric notebooks locally?