AWS Redshift

Amazon Redshift is a data warehouse product

Web site

Tech tags:

• Data warehouse
• Federated queries
• Computation storage seperation
• ML UDF function

Related shared contents:

• Views pwn Tables as data interfaces
  project
  2024-12-05

  Twitch has leveraged Views in their Data Lake to enhance data agility, minimize downtime, and streamline development workflows. By utilizing Views as interfaces to underlying data tables, they've enabled seamless schema modifications, such as column renames and VARCHAR resizing, without necessitating data reprocessing. This approach has facilitated rapid responses to data quality issues and supported efficient ETL processes, contributing to a scalable and adaptable data infrastructure.
• Building end-to-end data lineage for one-time and complex queries using Amazon Athena, Amazon Redshift, Amazon Neptune and dbt
  product
  2024-12-12

  Build a process to built the complete data lineage information by merging the partial lineage generated by dbt automatically.
• Loading data into Redshift with DBT
  project
  2024-11-06

  Why we load the S3 data into the Redshift again? it already queryable via Redshift Spectrum? I guess it's for the performance? Transform the S3 raw data, build the data models and write back into S3?
• Power highly resilient use cases with Amazon Redshift
  poc
  2021-12-27

In productions with: