Notebooks Spark SQL Intellisense Not Working

[re84uk]

Hi

Intellisense when using Spark SQL in notebooks never seems to work for me, does anyone else have the same problem?

[v-prasare]

Hi @re84uk ,

When writing Spark SQL queries directly in notebooks, especially within %%sql magic commands, IntelliSense support is limited or non-existent. This is because these cells are treated as plain text, and the notebook interface doesn't parse the SQL context to provide intelligent code suggestions.

I’d also recommend submitting your detailed feedback and suggestions through Microsoft’s official channels, such as the Microsoft Fabric Ideas.  to help bring attention to this limitation.

Thanks,

Prashanth Are

MS Fabric community support

[re84uk]

Hi

The official documenation linked below suggests otherwise, I find none of the functionality listed as "yes" for Spark SQL works.

Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

[v-prasare · Accepted solution]

Hi @re84uk 

try once below mentioned alternatives and let me know if this helps?

Try typing SQL inside a Python cell using the spark.sql("...") pattern. Occasionally, IntelliSense works better in Python cells with embedded SQL strings.

Browser or environment issues: Try clearing cache or switching browsers (e.g., Edge/Chrome)

I recommend submitting feedback on the specific documentation page you referred to this helps Fabric product team prioritize fixes or clarify expectations.

you can raise or upvote the idea for full IntelliSense support for Spark SQL in notebooks here:Microsoft Fabric Ideas. Your observations are valid and helpful in improving the experience for everyone.

Thanks,

Prashanth Are

[v-prasare]

Hi,

Could you please confirm if you’ve raised or upvoted an idea for this on the Mcrosoft fabric ideas forum
Your feedback is valuable, and sharing your observations helps the product team improve the overall experience.

Also, kindly keep us posted with any updates or responses you receive so we can continue to track this effectively.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

We are following up once again regarding your query. Could you please confirm if you have shared ideas with Microsoft?

If the you have any progress, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.