capabilities.work

Provision Linked Service and Dataset

A 3-step recipe with Azure Synapse Analytics. We can help you get access.

Recipe · 3 steps

Provision Linked Service and Dataset

with Azure Synapse Analytics

Stand up a linked service and a dataset that references it.

  1. Create or update the linked service that defines the connection to the backing data store.
  2. Read the linked service back to confirm it was persisted before binding a dataset to it.
  3. Create or update a dataset whose linkedServiceName reference points at the linked service provisioned above.
What you'll need to have ready
  • apiVersion: The Synapse data plane API version (e.g. 2020-12-01).
  • linkedServiceName: The name of the linked service to create or update.
  • linkedService: The LinkedServiceResource definition to publish.
  • datasetName: The name of the dataset to create or update.
  • dataset: The DatasetResource definition. Its properties.linkedServiceName.referenceName should match the linked service created in this flow.
For your developer

Arazzo workflow microsoft-azure-synapse-analytics:provision-linked-service-and-dataset, 3 operations: LinkedService_CreateOrUpdateLinkedService → LinkedService_GetLinkedService → Dataset_CreateOrUpdateDataset. Specs on APIs.io.

More recipes with Azure Synapse Analytics

Build Data Integration PipelineDeploy and Run PipelineDeploy and Start TriggerDeploy and Execute Spark Job DefinitionOpen Spark Session and Run StatementProvision and Resume SQL PoolProvision Spark PoolPublish and Verify NotebookPublish and Verify SQL ScriptSubmit and Poll Spark Batch Job