Bloomberg·Software Engineer·Technical Phone Screen
- You have a PostgreSQL table with a raw text column storing pipe-delimited key=value pairs. Write a single SQL query that parses the raw column into structured fields (user, country, timestamp), filters for US rows in August 2025, and returns the daily count of distinct users ordered by day. Also name the BigQuery functions you'd normally reach for and their PostgreSQL equivalents.
“My brain went straight to BigQuery's REGEXP_EXTRACT and PARSE_TIMESTAMP before I even finished reading the question.”