SQL: Inspect Raw Data | Dataford Interview Questions

What does the raw data look like?

Use the provided raw_records table to return the stored records without transforming or filtering their values. Preserve nulls in nullable columns and display the semi-structured payload as stored.

Output

One row per raw record with columns raw_id, source_system, record_type, captured_at, external_id, and payload.
Include all records and sort by captured_at ascending, placing null timestamps last, then by raw_id ascending.

Schema

raw_records

Column	Type	Description
raw_idPK	INT	Unique identifier for the raw record
source_system	VARCHAR(50)	System that produced the record
record_type	VARCHAR(50)	Type assigned to the raw record
captured_at	TIMESTAMP	Timestamp when the record was captured
external_id	VARCHAR(100)	Identifier supplied by the source system
payload	JSONB	Original semi-structured record contents

Your question is SQL: Inspect Raw Data. 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