Ingest and query data using Azure Cosmos DB for PostgreSQL

Beginner
Developer
Azure
Azure Cosmos DB

Azure Cosmos DB for PostgreSQL provides a highly scalable distributed database solution, reliably and securely managed on Azure. To efficiently ingest and querying data with distributed tables, it's essential to understand how data is distributed across shards in the cluster.

Learning objectives

By the end of this module, you'll be able to:

  • Identify data ingestion techniques in Azure Cosmos DB for PostgreSQL.
  • Run queries on distributed data in Azure Cosmos DB for PostgreSQL.
  • Examine ways to view data distribution.

Prerequisites

  • Basic familiarity with relational databases
  • Understanding of database distribution concepts in Azure Cosmos DB for PostgreSQL
  • Knowledge of how to correctly select distribution columns for distributed tables
  • Awareness of the principles of table colocation in Azure Cosmos DB for PostgreSQL