capabilities.work

Publish and Verify SQL Script

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

Recipe · 2 steps

Publish and Verify SQL Script

with Azure Synapse Analytics

Publish a SQL script artifact and confirm it was stored.

  1. Create or update the SQL script artifact in the workspace.
  2. Read the SQL script back to confirm its content and connection were persisted.
What you'll need to have ready
  • apiVersion: The Synapse data plane API version (e.g. 2020-12-01).
  • sqlScriptName: The name of the SQL script to create or update.
  • sqlScript: The SqlScriptResource definition, including content.query and content.currentConnection.
For your developer

Arazzo workflow microsoft-azure-synapse-analytics:publish-and-verify-sql-script, 2 operations: SqlScript_CreateOrUpdateSqlScript → SqlScript_GetSqlScript. 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 Linked Service and DatasetProvision Spark PoolPublish and Verify NotebookSubmit and Poll Spark Batch Job