•  Introduction to Amazon Redshift V2 Connector
  •  Amazon Redshift V2 Connector assets
  •  Introduction to Amazon Redshift
  •  Amazon Redshift Spectrum overview
•  Connections for Amazon Redshift V2
  •  Prepare for authentication
  •  Create a minimal Amazon IAM policy
  •  Configure IAM authentication
  •  Configure an assume role for Amazon Redshift
    •  Generate temporary security credential policies for Amazon Redshift
    •  Generate temporary security credentials using AssumeRole for EC2
  •  Configure an assume role for Amazon S3 staging
    •  Generate temporary security credentials using AssumeRole for Amazon S3 staging
    •  Generate temporary security credentials using AssumeRole for EC2
  •  Enable encryption
  •  Connect to Amazon Redshift
    •  Before you begin
    •  Connection details
    •  Authentication types
  •  Proxy server settings
  •  Amazon Redshift Serverless connectivity
  •  Requirements to use Amazon Redshift Spectrum
  •  Private communication with Amazon Redshift
•  Amazon Redshift sources and targets
  •  Amazon Redshift V2 sources
    •  Read from Amazon Redshift with or without staging
    •  Data encryption in Amazon Redshift V2 sources
    •  Unload command
  •  Amazon Redshift V2 targets
    •  Amazon Redshift staging directory for Amazon Redshift V2 targets
    •  Data encryption in Amazon Redshift V2 targets
    •  Copy command
    •  Analyze target table
    •  Retain staging files
    •  Vacuum tables
    •  Recovery and restart processing
    •  Preserve record order on Write
    •  Octal values as DELIMITER and QUOTE
    •  Success and error files
•  Mappings and mapping tasks with Amazon Redshift
  •  Before you begin
    •  Create an external schema and table for Amazon Redshift Spectrum
  •  Amazon Redshift V2 objects in mappings
    •  Amazon Redshift V2 sources in mappings
    •  Rules and guidelines for reading data
    •  Rules and guidelines for configuring SQL query
    •  Adding multiple source objects
    •  Amazon Redshift V2 targets in mappings
    •  Amazon Redshift V2 lookups in mappings
    •  Mapping task with Oracle CDC sources example
    •  SQL transformation
    •  Dynamic schema handling for mappings
    •  Bulk processing for write operations
    •  Optimize the staging performance for a mapping
•  SQL ELT with Amazon Redshift V2 Connector
  •  SQL ELT configuration options
    •  Create a mapping in SQL ELT mode
    •  Enable SQL ELT optimization for a mapping task
  •  SQL ELT query preview
  •  Mappings in SQL ELT mode for Amazon Redshift
    •  Sources in mappings in SQL ELT mode
    •  Targets in mappings in SQL ELT mode
    •  Transformations in mappings in SQL ELT mode
    •  Functions in mappings in SQL ELT mode
    •  Operators in mappings in SQL ELT mode
    •  Rules and guidelines in mappings in SQL ELT mode
  •  SQL ELT optimization for mapping tasks
    •  SQL ELT optimization types
    •  SQL ELT optimization scenarios
    •  Data flow run order
    •  SQL ELT compatibility
    •  Configuring SQL ELT optimization
    •  Transformations for Amazon Redshift V2 mappings
    •  Features
    •  SQL ELT optimization for multiple targets
    •  Determine the order of processing for multiple targets
    •  Clean stop a SQL ELT optimization job
    •  Rules and guidelines for SQL ELT optimization
•  Data type reference
  •  Amazon Redshift and transformation data types
  •  Rules and guidelines for data types
•  Troubleshooting
  •  Troubleshooting for Amazon Redshift V2 Connector

Introduction to Amazon Redshift V2 Connector

Troubleshooting for Amazon Redshift V2 Connector

CDI_REDSHIFTV2_PREPARE_FOR_AUTHENTICATION

CDI_REDSHIFTV2_AMAZON_IAM_POLICY

CDI_REDSHIFTV2_IAM_AUTHENTICATION

CDI_REDSHIFTV2_ASSUMEROLE_REDSHIFT

CDI_REDSHIFTV2_ASSUMEROLE_S3STAGING

CDI_REDSHIFTV2_ENABLE_ENCRYPTION

AMAZON_RSV2_CONN

AMAZON_RSV2_CONN-CONN_NAME

AMAZON_RSV2_CONN-CONN_DESC

AMAZON_RSV2_CONN-CONN_TYPE

AMAZON_RSV2_CONN-AGENTGROUPID

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE-DEFAULT

AMAZON_RSV2_CONN-JDBCURL

AMAZON_RSV2_CONN-USERNAME

AMAZON_RSV2_CONN-PASSWORD

AMAZON_RSV2_CONN-USEEC2ROLETOASSUMEROLE

AMAZON_RSV2_CONN-IAMROLEARN

AMAZON_RSV2_CONN-AWSACCESSKEYID

AMAZON_RSV2_CONN-AWSSECRETACCESSKEY

AMAZON_RSV2_CONN-S3ENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE ENDPOINT-S3ENDPOINTDNSNAME

AMAZON_RSV2_CONN-STSVPCENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE_ENDPOINT-STSENDPOINTDNSNAME

AMAZON_RSV2_CONN-KMSVPCENDPOINTTYPE

AMAZON_RSV2_CONN-INTERFACE_ENDPOINT-KMSENDPOINTDNSNAME

AMAZON_RSV2_CONN-EXTERNALID

AMAZON_RSV2_CONN-REGION

AMAZON_RSV2_CONN-CONNECTIONENVIRONMENTSQL

AMAZON_RSV2_CONN-MASTERSYMMETRICKEY

AMAZON_RSV2_CONN-CUSTOMERMASTERKEYID

AMAZON_RSV2_CONN-AUTHENTICATIONTYPE-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-CLUSTERIDENTIFIER

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-DATABASENAME

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTIAMROLEARN

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTACCESSKEYID

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-REDSHIFTSECRETACCESSKEY

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-DATABASEGROUP

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-EXPIRATIONTIME

AMAZON_RSV2_CONN-REDSHIFT_IAM_AUTHENTICATION_VIA_ASSUMEROLE-AUTOCREATEDBUSER

CDI_REDSHIFTV2_PROXY_SERVER_SETTINGS

CDI_REDSHIFTV2_SERVERLESS_CONNECTIVITY

CDI_REDSHIFTV2_PREREQ_REDSHIFT_SPECTRUM

CDI_REDSHIFTV2_PRIVATE_COMMUNICATION