1

I have a linked service. Name is 'LS_test'. The name of the linked service is the same in development as in production. This linked service makes a connection from a Synapse notebook to the data lake storage account. Since the storage account name is different in development and production I tried to make parameter in the linked service: enter image description here

How can I fill in the StorageAccountName with a different value depending on the environment (development vs production) the notebook is running, say 'Storage-dev' vs 'Storage-prd'?

Maybe with a configuration file of the spark pool?

0

1 Answer 1

1

According to this, PySpark notebooks do not support parameterized linked services. If you attempt to connect ADLS through a linked service, you may encounter the following error:

An error occurred while calling z:mssparkutils.fs.mount. : com.microsoft.spark.notebook.msutils.InvalidCredentialsException: fetch Token from linkedService failed with POST failed with 'Bad Request' (400) and message: {"result":"DependencyError","errorId":"BadRequest","errorMessage":"[Code=LinkedServiceParametersNotSupported, Target=AzureDataLakeStorage1, Message=Failed to load LinkedService, Exception: Linked Services using parameters are not supported yet, LinkedServiceName: AzureDataLakeStorage1]. TraceId : 76484a03-fd79-43cd-aa8d-b54db5a3a7f5 | client-request-id : 302d35df-97ae-4cfc-85b7-e12568582071. Error Component : LSR"}, no any user credential info available for authorization

The error message states that "Linked Services using parameters are not supported yet." This may be a feature request for Synapse notebooks. Instead, create parameters by manually entering the storage account name with managed identity authentication in the storage account linked services for both environments, as shown below:

enter image description here

Use these linked services according to the specific environments.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.