Clinton Poserio

AMI source: 099720109477/ubuntu/images/hvm-ssd/ubuntu-xenial-16.04-amd64-server-20201014 reference issue: #4714 Signed-off-by: Clinton Poserio

Simplified `UNNEST` with `STRUCT` de-structuring

3

The following CTE block: https://github.com/DataExpert-io/data-engineer-handbook/blob/954ac02af1edcceaf56c0e784ec88c3904e73550/bootcamp/materials/1-dimensional-data-modeling/lecture-lab/incremental_scd_query.sql#L67-L75 can be simplified to (using `CROSS JOIN` to the `UNNEST`ed array): ```sql unnested_changed_records AS ( SELECT c.player_name, r.* FROM changed_records c, UNNEST(c.records) r ), ```...

Dockerize the CLI

4

I recently needed to run the CLI inside containers (due to our CI platform). Not sure if there's an existing solution to run the CLI inside Docker because the CLI...