Hello,

Having a Spark notebook connecting to CosmosDB for data load. Using linked resource:

df = spark.read.format(“cosmos.olap”)
.option(“spark.synapse.linkedService”, “<enter linked service name>”)
.option(“spark.cosmos.container”, “<enter container name>”)
.load()

as per https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3 

Is is possible to use linkedService when connecting to Azure DB for mysql/pgsql? I did not find anything in the documentation. It seems that the only way is to use standard spark connection configuration with username/password. I did not find any other way in documentation.

I would prefer to use already defined linked service to connect to these databases.

It this possible?

Thanks!

​Hello, Having a Spark notebook connecting to CosmosDB for data load. Using linked resource:df = spark.read.format(“cosmos.olap”)
.option(“spark.synapse.linkedService”, “<enter linked service name>”)
.option(“spark.cosmos.container”, “<enter container name>”)
.load()as per https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3  Is is possible to use linkedService when connecting to Azure DB for mysql/pgsql? I did not find anything in the documentation. It seems that the only way is to use standard spark connection configuration with username/password. I did not find any other way in documentation. I would prefer to use already defined linked service to connect to these databases. It this possible? Thanks!   Read More

​