Scenario

A rideshare company maintains customer records in two separate regional tables that share the same schema.

Task

Write a Snowflake SQL query that:

1. Selects all columns from {{ ref("customers_west") }}
2. Selects all columns from {{ ref("customers_east") }}
3. Returns all rows from both tables combined (including any duplicates)

Schema

customers_west

customers_east

Example

customers_west:

customers_east:

Expected Output:

Note: All rows from both tables appear in the output. The combined result contains 5 rows (3 from west + 2 from east).