Access data lake gen2 through Synapse Serverless external tables by technical user

Nick34, you should be able to accomplish this by creating database-scoped permissions for each AAD user in your serverless SQL pool database. The "Configure Database-scoped permissions" steps here show how to create an AAD login in the master database and assign a database role within a specific database. The db_reader role could be used to grant read access to all external tables within a serverless SQL pool, or you could grant the SELECT permission on a table-by-table basis.

Access to the underlying Data Lake Storage files would be provided for all users by a single External Data Source definition and credential (SAS token or workspace Managed Identity), as shown here.