Grokking the Google Forward Deployed Engineer Interview
Vote

0% completed

​

BigQuery and Spark for Forward Deployed Engineers

SELECT shipper_id, SUM(amount) AS billed FROM billing.invoice_lines WHERE invoice_date = DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) GROUP BY shipper_id

At the freight carrier, this query totals yesterday's invoice lines by shipper. In BigQuery, the last line before GROUP BY decides whether it reads about 1 megabyte or about 2 gigabytes. That difference is the first thing a Data Cloud forward deployed engineer (FDE) checks in any query that runs every night.

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%


Vote for new content