From the course: Learning Amazon Web Services (AWS) QuickSight
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Joining tables - AWS QuickSight Tutorial
From the course: Learning Amazon Web Services (AWS) QuickSight
Joining tables
- [Instructor] Let's say you have two tables that you connected to in your ETL process. You then want to join them together to effectively work as a single data table. The table on the left is the data or fact table, and the table on the right is a key containing customer information. For those of you familiar with SQL code, you can also create joins when you set up your database connection in QuickSight using SQL JOIN functions in your query. We first determine what field will serve as the join key. Let's use the name field because it appears in both tables. The values we're matching must match exactly. We cannot have any difference in capitalization, spacing, or punctuation. It's also very important to note that the key table must contain unique values for the field we're matching it on. The data or fact table, however, doesn't need to contain unique values. There are several QuickSight join types between tables. You…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.