Grokking the Google Forward Deployed Engineer Interview
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%