Congratulations
Introduction to Redshift
Jason Myers
Principal Engineer
Architecture and Data
Redshift Architecture
- Cluster node types
- How queries execute
- Spectrum Internal/external schemas
Data Types
- Standard types
- Semistructured data with the super type
- Conversions
Queries, Performance and Security
Redshift SQL and Functions
- Common Table Expressions
- Time traveling date functions
- Window functions for analysis
- Lead and Lag
Performance & Security
- Writing performant queries
- Investigating query performance issues
- Column level
- Row level
- Data masking
Tables and Views
| Table Name | Description |
|---|---|
| SVV_ALL_SCHEMAS | View schema details |
| SVV_ALL_TABLES | View table details |
| SVV_ALL_COLUMNS | View table columns details |
| STV_PARTITIONS | View details about data across the cluster |
| SVV_TABLE_INFO | View all details about tables like DISTKEY, SORTKEY, and skew |
| STL_ALERT_EVENT_LOG | Queries that trigger alerts and possible resolutions |
| SVL_QUERY_SUMMARY | View query details like size, rows, and time |
| SVV_COLUMN_PRIVILEGES | View details about column-level security |
| SVV_RLS_POLICY | View row-level security policy details |
| SVV_RLS_APPLIED_POLICY | View show queries affected by row-level security policies |
Thank you and Congratulations!
Introduction to Redshift
