SQL in BigQuery 1
1. How to handle duplicate column names on left join A SELECT * EXCEPT statement specifies the names of one or more columns to exclude from the result set. All matching column names are omitted from the output. SELECT t1.* EXCEPT (name), t2.* EXCEPT (name,account_id), t1.name AS deployment_name, t2.name AS account_name FROM table1 t1 LEFT JOIN table2 t2 ON t1.name = t2.name 2. Extract date from timestamp Returns a value that corresponds to the specified part from a supplied timestamp_expression....