Forum Discussion

vapid128's avatar
vapid128
Solution Specialist
1 year ago
Solved

Fabric Notebook: IntelliSense Fails for Tables in Schema-Enabled Lakehouse

Hello Fabric Community, I'm experiencing an issue with IntelliSense (table name completion) in a Fabric Notebook using Spark SQL (%%sql). My setup involves connecting to what the documentation refe...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi vapid128 ,

     

    Thank you for sharing your insights on the IntelliSense issue in Lakehouse. I completely agree when working outside the schema context, tables need to be manually referenced using the full path lke  Workspace.Lakehouse.Database.Schema.TableName.

     

    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.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

v-sathmakuri's avatar
v-sathmakuri
Community Support
1 year ago

Hi vapid128 ,

 

Thank you for sharing your insights on the IntelliSense issue in Lakehouse. I completely agree when working outside the schema context, tables need to be manually referenced using the full path lke  Workspace.Lakehouse.Database.Schema.TableName.

 

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.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!