Amazon Redshift Streaming Workshop - A hands-on workshop and sample library to build a near-realtime logistics dashboard using Amazon Redshift and Amazon Managed Grafana.
UDFs Collection - A collection of useful UDFs, such as bitwise ops, url parsing, masking, kms encryption, dynamodb lookups, and converting json to upper case.
Text UDFs - UDFs to analyze text, such as translating, detecting language, detecting sentiment, detecting and redacting entities, detecting and redacting PII.
Test Drive - A collection of utilities and automation to compare performance of different Redshift configurations for a given workload.
Simple Replay - A library to record your queries and replay them on a different cluster to test performance. (DEPRECATED: Use Test Drive)
Node Configuration Compare - A library to compare performance of different cluster sizes and configurations by recording and replaying your queries (uses Simple Replay under the hood). (DEPRECATED: Use Test Drive)
Admin Scripts - A collection of queries and scripts to inspect performance and other administrative tasks.
Admin Views - A collection of views to inspect performance and other adminstrative tasks.
Redshift Stored Procedures - A collection of stored procedures to perform common data tasks, such as integrity checks, permissions, and changing your data model.
Redshift Automation - A library to automate common tasks using AWS CloudWatch events and AWS Lambda.
QMR Notifications Utility - A library to set SNS notifications for changes in WLM Query Monitoring Rules (QMR).
Integrations
Libraries and resources to help integrate Redshift with other frameworks and AWS services
Awesome Redshift
A curated list of awesome Amazon Redshift libraries, utilities, and resources.
General Workshops
Hands-on workshops to learn Redshift.
Key Features
Amazon Redshift Serverless
Amazon Redshift Serverless resources
Data Sharing
Data Sharing for sharing data between Redshift clusters
Data APIs
Resources related to Data APIs for accessing Redshift from web services–based applications
Federated Queries
Resources related to Federated Queries querying live data from external databases
Streaming Ingestion
Resources related to Streaming Ingestion querying stream data from Amazon Kinesis Data Streams and Amazon Managed Streaming for Apache Kafka
Redshift Spectrum
Resources related to Redshift Spectrum for querying S3 data
User Defined Functions (UDFs)
Collections of User defined functions (UDFs)
Machine Learning (ML)
Resources related to Amazon Redshift ML
Performance Tuning
Tools and tips to measure and tune Redshift’s performance.
Connectors and Drivers
Redshift connectors and drivers
Operations
Tools and scripts to automate management and operations of Redshift.
Integrations
Libraries and resources to help integrate Redshift with other frameworks and AWS services
Pandas
dbt
Grafana
Apache Airflow
SQLAlchemy
sqlalchemy-redshiftdialect with SQLAlchemy.Querybook
AWS Glue
Amazon Location Service
Security and Authentication
General Security
General resources for Redshift’s security
Single Sign On (SSO)
Integration with SSO providers
Role Based Access Control (RBAC)
Using role-based access control (RBAC) to manage database permissions
Row Level Security (RLS)
Using row-level security (RLS) to gain granular access control
Encryption
Protect your data using encryption
Cost Optimization
Tools and resources to help reduce Redshift cost
CI/CD
Libraries and resources to help provision Redshift using CI/CD tools
Redshift Internals
Redshift’s internal architecture and design
General Resources
Blogs, forums, and other online Redshift resources
Contributing
Your contributions are always welcome! Please take a look at the contribution guidelines first.
We will keep some pull requests open if we aren’t sure whether those resources are awesome, you could vote for them by adding
to them.