Resource sharing occurs between the central governance account (controlled by the publisher) and the publisher account holding advertiser data. 7 The central governance account provides access to the publisher account (which transforms S3 objects to different advertisers’ accounts). 8 The advertiser client applications kicks off a process to integrate data from publishers. 9 Uses Amazon Managed Workflows for Apache Airflow to create Airflow DAG for transformations. 10 The transformation process extracts data from local S3 buckets containing advertiser data. 11 The transformation process gets access to related data from the publisher account through central governance and metadata access layer. 12 Transformed and joined data from both accounts are stored in final S3 buckets. 13 S3 Data is exported to Redshift DW or queried directly with Amazon Athena or Amazon Redshift Spectrum. 14 Amazon QuickSight accesses the tables created in Amazon Athena or Amazon Redshift Spectrum. © 2022, Amazon Web Services, Inc. or its affiliates. All rights reserved. 15 Dashboards/Insights are accessed by analysts.
