Amazon Redshift
E17671
Amazon Redshift is a fully managed, cloud-based data warehousing service from Amazon Web Services designed for fast querying and analysis of large datasets using SQL.
Aliases (2)
Statements (61)
| Predicate | Object |
|---|---|
| instanceOf |
Amazon Web Services product
→
cloud data warehouse service → managed database service → |
| deploymentModel |
cloud-based
→
|
| developer |
Amazon Web Services
→
|
| hasComponent |
Redshift cluster
→
compute nodes → leader node → |
| integratesWith |
AWS CloudTrail
→
AWS Glue → AWS Lambda → Amazon CloudWatch → Amazon DynamoDB → Amazon Kinesis Data Firehose → Amazon QuickSight → Amazon RDS → Amazon S3 → |
| notDesignedFor |
OLTP
→
|
| ownedBy |
Amazon.com, Inc.
→
|
| pricingModel |
on-demand
→
reserved instances → serverless → |
| primaryUseCase |
analytics
→
business intelligence → data warehousing → |
| regionAvailability |
multiple AWS regions worldwide
→
|
| serviceModel |
fully managed
→
|
| supportsClient |
JDBC
→
ODBC → psql-compatible clients → |
| supportsDataFormat |
Avro
→
CSV → JSON → ORC → Parquet → |
| supportsDeploymentOption |
provisioned clusters
→
serverless data warehouse → |
| supportsFeature |
AQUA (Advanced Query Accelerator)
→
RA3 instances with managed storage → automatic backups → columnar storage → concurrency scaling → data compression → encryption at rest → encryption in transit → federated queries → massively parallel processing → materialized views → spectrum for querying data in Amazon S3 → workload management → |
| supportsIntegrationType |
BI tools
→
ETL tools → data integration platforms → |
| supportsQueryLanguage |
PostgreSQL-compatible SQL
→
SQL → |
| supportsSecurityFeature |
AWS KMS integration
→
IAM integration → VPC isolation → audit logging → network encryption → |
| supportsWorkload |
OLAP
→
|
Referenced by (10)
| Subject (surface form when different) | Predicate |
|---|---|
|
AWS Glue
→
Amazon Kinesis Data Firehose → Amazon QuickSight → Tableau → |
integratesWith |
|
AQUA (Advanced Query Accelerator)
("Amazon Redshift RA3 instances")
→
|
associatedService |
|
Snowflake
→
|
competitor |
|
AQUA (Advanced Query Accelerator)
→
|
developedFor |
|
Amazon Web Services
→
|
offersService |
|
AQUA (Advanced Query Accelerator)
("Amazon Redshift data warehouse clusters")
→
|
supports |
|
Amazon Kinesis Data Firehose
→
|
supportsDestination |