Forum Discussion

tmjones2's avatar
tmjones2
Helper I
2 years ago

VS Code Integration with Fabric Notebooks Not Working

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?

data engineering
Notebook

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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