Jsonb column transformation in postgres or using dbt↗
21 Jan
stackoverflow.com
"I am trying to see how to flatten the jsonb column titled "additionalFields" below. I can query the table with
SELECT "id","additionalFields" AS "additionalFields..."
SELECT "id","additionalFields" AS "additionalFields..."