Data solutions for Python apps on Azure

Azure offers a choice of fully managed relational, NoSQL, and in-memory databases, spanning proprietary and open-source engines in addition to storage services for object, block, and file storage. The following articles help you get started with Python data solutions on Azure.

Databases

• PostgreSQL: Build scalable, secure, and fully managed enterprise-ready apps on open-source PostgreSQL, scale out single-node PostgreSQL with high performance, or migrate PostgreSQL and Oracle workloads to the cloud.

  • Quickstart: Use Python to connect and query data in Azure Database for PostgreSQL - Flexible Server
  • Quickstart: Use Python to connect and query data in Azure Database for PostgreSQL - Single Server
  • Deploy a Python (Django or Flask) web app with PostgreSQL in Azure App Service

• MySQL: Build apps that scale with managed and intelligent SQL database in the cloud.

  • Quickstart: Use Python to connect and query data in Azure Database for MySQL - Flexible Server
  • Quickstart: Use Python to connect and query data in Azure Database for MySQL

• Azure SQL: Build apps that scale with managed and intelligent SQL database in the cloud.

  • Quickstart: Use Python to query a database in Azure SQL Database or Azure SQL Managed Instance

NoSQL, blobs, tables, files, graphs, and caches

• Cosmos DB: Build applications with guaranteed low latency and high availability anywhere, at any scale, or migrate Cassandra, MongoDB, and other NoSQL workloads to the cloud.

  • Quickstart: Azure Cosmos DB for NoSQL client library for Python
  • Quickstart: Azure Cosmos DB for MongoDB for Python with MongoDB driver
  • Quickstart: Build a Cassandra app with Python SDK and Azure Cosmos DB
  • Quickstart: Build an API for Table app with Python SDK and Azure Cosmos DB
  • Quickstart: Azure Cosmos DB for Apache Gremlin library for Python

• Blob storage: Massively scalable and secure object storage for cloud-native workloads, archives, data lakes, high-performance computing, and machine learning.

  • Quickstart: Azure Blob Storage client library for Python
  • Azure Storage samples using v12 Python client libraries

• Azure Data Lake Storage Gen2: Massively scalable and secure data lake for your high-performance analytics workloads.

  • Use Python to manage directories and files in Azure Data Lake Storage Gen2
  • Use Python to manage ACLs in Azure Data Lake Storage Gen2

• File storage: Simple, secure, and serverless enterprise-grade cloud file shares.

  • Develop for Azure Files with Python

• Redis Cache: Power fast, scalable applications with an open-source-compatible in-memory data store.

  • Quickstart: Use Azure Cache for Redis in Python

Big data and analytics

• Azure Data Lake analytics: A fully managed on-demand pay-per-job analytics service with enterprise-grade security, auditing, and support.

  • Manage Azure Data Lake Analytics using Python
  • Develop U-SQL with Python for Azure Data Lake Analytics in Visual Studio Code

• Azure Data Factory: A data integration service to orchestrate and automate data movement and transformation.

  • Quickstart: Create a data factory and pipeline using Python
  • Transform data by running a Python activity in Azure Databricks

• Azure Event Hubs: A hyper-scale telemetry ingestion service that collects, transforms, and stores millions of events.

  • Send events to or receive events from event hubs by using Python
  • Capture Event Hubs data in Azure Storage and read it by using Python (azure-eventhub)

• HDInsight: A fully managed cloud Hadoop and Spark service backed by 99.9% SLA for your enterprise

  • Use Spark & Hive Tools for Visual Studio Code

• Azure Databricks: A fully managed, fast, easy and collaborative Apache® Spark™ based analytics platform optimized for Azure.

  • Connect to Azure Databricks from Excel, Python, or R
  • Get Started with Azure Databricks
  • Tutorial: Azure Data Lake Storage Gen2, Azure Databricks & Spark

• Azure Synapse Analytics: A limitless analytics service that brings together enterprise data warehousing and big data analytics.

  • Quickstart: Use Python to query a database in Azure SQL Database or Azure SQL Managed Instance (includes Azure Synapse Analytics)