Does Azure Synapse Analytics have support for Python?

Roohiya Dudekula 1 Reputation point
2021-06-08T00:26:04.873+00:00

What I am trying to do?

Glue-Athena-like process.

  1. Data in S3
  2. AWS Glue (create metadata tables)
  3. Tables can be queried using Athena via boto3 (python library)

Problem I am facing in Azure Cloud

~Trying to replicate the above process using Azure Synapse Analytics~

  1. Data in linked Azure Storage container
  2. Azure Data Factory (create external tables)
  3. How to make T-SQL queries on the external tables using python?

Is there any python library to make T-SQL calls to the external tables created in Azure Synapse workspace?

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.

0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA 90,521 Reputation points
    2021-06-08T10:52:40.797+00:00

    Hello @Roohiya Dudekula ,

    Welcome to the Microsoft Q&A platform.

    Yes, Azure Synapse Analytics supports python.

    Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage and serve data for immediate BI and machine learning needs.

    103424-image.png

    Key Service Capabilities in Azure Synapse Analytics:

    Note: Only following magic commands are supported in Synapse pipeline : %%pyspark, %%spark, %%csharp, %%sql.

    103405-image.png

    For more information, refer to What is Azure Synapse Analytics? and Magic commands in Synapse Analytics.

    Hope this helps. Do let us know if you any further queries.

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

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

    Was this answer helpful?

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    5 deleted comments

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.