Exercise

Learning more about a table's columns

There have been some performance issues and the team wanted to know if you could investigate the coffee county weather table to see if you could identify what is going on. You decided you wanted to check for any DISTKEY or SORTKEYs that might be on the table.

Instructions

100 XP

Select the column_name, distkey and sortkey from the SVV_REDSHIFT_COLUMNS system view for the public_intro_redshift.coffee_county_weather table

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise