How to read data using synapsesql connector from Synapse spark with minimum permissions

TLDR; The documented minimum permissions required for using the synapsesql connector for spark to read or write data from Synapse SQL Pools is giving high privileges to spark users even though the required operation is only read. In this article,...