JOIN

• JOIN

  • 

• Inner Join

  WITH 
  raw AS (
  SELECT * FROM data_catalog.data_source_glue_table
  ),
  master AS (
  SELECT * FROM data_catalog.master_data_glue_table
  )
  SELECT
  raw.userId, raw.count, master.name
  FROM raw
  INNER JOIN master
  ON raw.userId = master.userId

• LEFT JOIN

  WITH 
  raw AS (
  SELECT * FROM data_catalog.data_source_glue_table
  ),
  master AS (
  SELECT * FROM data_catalog.master_data_glue_table
  )
  SELECT
  raw.userId, raw.count, master.name
  FROM raw
  LEFT JOIN master
  ON raw.userId = master.userId

• RIGHT JOIN

  WITH 
  raw AS (
  SELECT * FROM data_catalog.data_source_glue_table
  ),
  master AS (
  SELECT * FROM data_catalog.master_data_glue_table
  )
  SELECT
  raw.userId, raw.count, master.name
  FROM raw
  RIGHT JOIN master
  ON raw.userId = master.userId

• FULL JOIN

  WITH 
  raw AS (
  SELECT * FROM data_catalog.data_source_glue_table
  ),
  master AS (
  SELECT * FROM data_catalog.master_data_glue_table
  )
  SELECT
  raw.userId, raw.count, master.name
  FROM raw
  FULL JOIN master
  ON raw.userId = master.userId