Hi @Akshay_Petkar ,

To be precise, you are going to connect SQL Server with Databricks using Lakehouse Federation 😉 SSMS is just a client tool you can use to query SQL Server database.
And answering your question, you are limited only to dialect supported by Spark SQL. So you cannot use TOP 10, which comes from T-SQL dialect, because you will get an error as below: