VS Code Integration with Fabric Notebooks Not Working

[tmjones2]

I'm running the code below and getting this error:

AttributeError: 'NoneType' object has no attribute 'sql'

df = spark.sql("SELECT * FROM MyLH.ClaimFacts LIMIT 1000")
display(df)
df.printSchema()

If i run java -version, I get:

My JAVA_HOME is set to jdk-8.0.412.8-hotspot

When I go to the bin folder in there and do java-version, it shows:
"openjdk version "1.8.0_412"

I have all the conda stuff installed

I have the condabin folder and the bin folder of the 1.8 java install in PATH

I'm using the synapse kernal in VSCode (the same as what it shows in the notebook in the Fabric workspace)

I'm reinstalled and restarted my machine 50 times

I've tried running as an admin

Any ideas?

[Anonymous]

Hi @tmjones2 
Thanks for using Fabric Community.
Please follow these steps:
1) Right click the ipython notebook

Reveal in File Explorer

2) Open the python log file: ../../../logs/${NOTEBOOK_ARTIFACT_ID}/PySparkLighter.log and check the session failure reason

Please attach the screenshot of the error here to understand what is happening.

You can also try stopping the spark session in the Notebook and try running in VS code. 
Thanks

[Anonymous]

Hi @tmjones2 
We haven’t heard from you on the last response and was just checking back to see if you could provide the details asked above.
Thanks

[Anonymous]

Hi @tmjones2 
We haven’t heard from you on the last response and was just checking back to see if you could provide the details asked above.
Thanks