We have setup azure sql bdc in azure environment. As per the Microsoft document in order to install packages in sql bdc using ADS pyspark kernel, there are two approaches:
1: Using sc._install(<package name>)
2: Using requirements.txt file.
Approach one is working fine in our setup but approach two is failing as kernel is getting dead while execution. Therefore please let us know if there are any configuration/pre requisites required to install packages using requirements.txt approach.
Microsoft doc url to install packages: