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.
Deze oefening maakt deel uit van de cursus
Introduction to Redshift
Oefeninstructies
- Select the
column_name,distkeyandsortkeyfrom theSVV_REDSHIFT_COLUMNSsystem view for thepublic_intro_redshift.coffee_county_weathertable
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- View the distkey and sortkey status of each column
SELECT column_name,
___,
___
-- Use the proper system view
FROM ___
-- Only in the proper schema
WHERE schema_name = '___'
-- For the proper table
AND table_name = '___';