Cargando…
Amazon redshift cookbook : recipes for building modern data warehousing solutions /
Discover how to build a cloud-based data warehouse at petabyte-scale that is burstable and built to scale for end-to-end analytical solutions Key Features Discover how to translate familiar data warehousing concepts into Redshift implementation Use impressive Redshift features to optimize developmen...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing, Limited,
2021.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright and Credits
- Contributors
- Table of Contents
- Preface
- Chapter 1: Getting Started with Amazon Redshift
- Technical requirements
- Creating an Amazon Redshift cluster using the AWS Console
- Getting ready
- How to do it ...
- Creating an Amazon Redshift cluster using the AWS CLI
- Getting ready
- How to do it ...
- How it works ...
- Creating an Amazon Redshift cluster using an AWS CloudFormation template
- Getting ready
- How to do it ...
- How it works ...
- Connecting to an Amazon Redshift cluster using the Query Editor
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift cluster using the SQL Workbench/J client
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift Cluster using a Jupyter Notebook
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift cluster using Python
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift cluster programmatically using Java
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift cluster programmatically using .NET
- Getting ready
- How to do it ...
- Connecting to an Amazon Redshift cluster using the command line
- Getting ready
- How to do it ...
- Chapter 2: Data Management
- Technical requirements
- Managing a database in an Amazon Redshift cluster
- Getting ready
- How to do it ...
- Managing a schema in a database
- Getting ready
- How to do it ...
- Managing tables
- Getting ready
- How to do it ...
- How it works ...
- Managing views
- Getting ready
- How to do it ...
- Managing materialized views
- Getting ready
- How to do it ...
- How it works ...
- Managing stored procedures
- Getting ready
- How to do it ...
- How it works ...
- Managing UDFs
- Getting ready
- How to do it ...
- How it works ...
- Chapter 3: Loading and Unloading Data
- Technical requirements
- Loading data from Amazon S3 using COPY
- Getting ready
- How to do it ...
- How it works ...
- Loading data from Amazon EMR
- Getting ready
- How to do it ...
- Loading data from Amazon DynamoDB
- Getting ready
- How to do it ...
- How it works ...
- Loading data from remote hosts
- Getting ready
- How to do it ...
- Updating and inserting data
- Getting ready
- How to do it ...
- Unloading data to Amazon S3
- Getting ready
- How to do it ...
- Chapter 4: Data Pipelines
- Technical requirements
- Ingesting data from transactional sources using AWS DMS
- Getting ready
- How to do it ...
- How it works ...
- Streaming data to Amazon Redshift via Amazon Kinesis Firehose
- Getting ready
- How to do it ...
- How it works ...
- Cataloging and ingesting data using AWS Glue
- How to do it ...
- How it works ...
- Chapter 5: Scalable Data Orchestration for Automation
- Technical requirements
- Scheduling queries using the Amazon Redshift query editor
- Getting ready
- How to do it ...
- How it works ...
- Event-driven applications using Amazon EventBridge and the Amazon Redshift Data API