Flatten a Dictionary | Dataford Interview Questions

Write a function to flatten a dict.

Implement this as a PostgreSQL function that accepts a jsonb object and returns one row for each non-object value, including values nested inside objects. Nested keys must be represented as dot-delimited paths. Arrays should remain intact as single jsonb values.

Output

Return input_id, path, and value.
Produce one row per flattened value from each input object.
Order by input_id, then path.

Schema

flatten_inputs

Column	Type	Description
input_idPK	INT	Identifier for the JSON input
source_label	VARCHAR(40)	Optional label for the input
payload	JSONB	JSON object to flatten

Your question is Flatten a Dictionary. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a function to flatten a dict.

Output

Return input_id, path, and value.
Produce one row per flattened value from each input object.
Order by input_id, then path.

Schema

flatten_inputs

Column	Type	Description
input_idPK	INT	Identifier for the JSON input
source_label	VARCHAR(40)	Optional label for the input
payload	JSONB	JSON object to flatten

Your question is Flatten a Dictionary. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.