Hi, Is there a Synapse Activity that I can use to execute a Select statement against synapse lake database with out using Notebook?

Hi @vinu thomas, you should be able to use Serverless SQL to query a lake databse table. In a Synapse Pipeline you can use Serverless SQL in a Lookup or Copy Activity.