<ul><li>Customers can now use Amazon Aurora Zero-ETL integration with Amazon Redshift and dbt Cloud to enable near real-time analytics.</li><li>Amazon Aurora and Amazon Redshift address different analytics requirements, allowing for a separation of concerns.  </li><li>Data in Amazon Redshift is transactionally consistent and updates are automatically and continuously propagated. </li><li>dbt helps manage data transformation by enabling teams to deploy analytics code following software engineering best practices</li><li>dbt Cloud is a hosted service that helps data teams productionize dbt deployments.</li><li>Aurora MySQL creates a source database and RedShift creates a target database.</li><li>Use CloudFormation to provision an Aurora MySQL cluster and Redshift Serverless data warehouse.</li><li>Populate source data in Amazon Aurora MySQL by creating a sample database on your local system.</li><li>Create dbt models in dbt Cloud and deploy on Amazon Redshift.</li><li>Use dbt to verify and test models, and to produce and deploy documentation and production jobs.</li></ul>

Unlocking near real-time analytics with petabytes of transaction data using Amazon Aurora Zero-ETL integration with Amazon Redshift and dbt Cloud

Discover more