Press "Enter" to skip to content

Loading JSONB into Postgres via Azure Data Factory

Rayis Imayev is slinging JSON:

Requirements:

1. Sourcing data comes from a SQL Server database

2. The destination is a PostgreSQL database table

3. Transformation logic is to aggregate several rows from a sourcing table and populate the resulting JSON structured document into a single row JSONB type column

Read on for Rayis’s notes.