Unable to create azure synapse pipeline from az synapse pipeline create using Azure CLI

Radha Pusarapu (Ernst & Young LLP) 31 Reputation points Microsoft Vendor
2022-03-30T10:21:30.087+00:00

I am trying to create a pipeline from ARM template using Azure CLI but couldnt get it.

I am facing this error when I am executing the pipeline

The command failed with an unexpected error. Here is the traceback:
'properties'
Traceback (most recent call last):
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 231, in invoke
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/init.py", line 658, in execute
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/init.py", line 721, in _run_jobs_serially
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/init.py", line 692, in _run_job
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/init.py", line 328, in call
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/synapse/manual/operations/artifacts.py", line 82, in create_or_update_pipeline
KeyError: 'properties'

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,818 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 70,026 Reputation points Microsoft Employee
    2022-03-31T07:33:51.173+00:00

    Hello @Radha Pusarapu (Ernst & Young LLP) ,

    Thanks for the question and using MS Q&A platform.

    This is an excepted behaviour when you are using the Export template - JSON file.

    188568-image.png

    As per the repro, received the same error message as shown above:

    188645-image.png

    In order to create synapse pipeline using JSON file, I would request to download the support files.

    188681-image.png

    Once you download the support files, go to the pipeline folder and pick the JSON file.

    188598-image.png

    Using the download the support files of the pipeline helps to create the synapse pipeline using Azure CLI.

    188662-image.png

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful