Azure-Samples / azure-samples-python-management

This repo contains sample code for management libraries of Azure SDK for Python
MIT License
171 stars 136 forks source link

Documentation for azure-mgmt-synapse #145

Open coreyryanhanson opened 10 months ago

coreyryanhanson commented 10 months ago

I'm trying to integrate an existing account with the Overture API using Microsoft Synapse SQL queries. I haven't encountered much documentation in doing so.

Specifically I was wondering if it was possible through this python library to:

  1. Push SQL commands and publish them to Synapse Studio programatically
  2. Execute those commands through Python and download the results.

Is this possible and is azure-mgmt-synapse the appropriate library for achieving this? If so where can I best find documentation for this?

ChenxiJiang333 commented 2 months ago

Hi, azure-mgmt-synapse does not have the function to achieve that. You can do it using azure-synapse-artifacts with method begin_create_or_update_sql_script.