AWS Athena

aws athena is a serverless, interactive query service that makes it easy to analyze data directly in amazon simple storage service (amazon s3) using standard sql athena is built on presto, an open source distributed sql query engine optimized for low latency, interactive data analysis athena allows you to run sql queries to analyze large datasets without the need for complex data processing or infrastructure management, making it a popular choice for data analysis and exploration how does aws athena work with custify? custify integrates with aws athena, allowing you to extract people , events , and companies directly from data stored in amazon s3 by connecting athena to custify, you can map your source data to custify’s data objects, ensuring your customer success team has accurate and up to date information for reporting, analysis, and customer management custify synchronizes data hourly by default, making it accessible for real time insights and actions how do i activate this integration? depending on the geographical location of your data (germany, ireland or us), you will need to whitelist a list of ips before activating the data warehouse frankfurt cluster 3 123 52 1563 67 152 22418 159 43 17018 194 219 2193 74 25 43 ireland cluster 34 253 103 15, 176 34 236 120, 54 73 1 213 us cluster 3 142 88 1818 188 66 1843 19 0 1973 140 205 1813 140 83 245 activation 1\ sign in to custify and navigate to the docid\ jffsupfbyhwcg43nhfbl7 page 2\ select the data warehouse integration 3\ click new sync and then new source , and select aws athena 4\ provide the necessary details to connect to your aws athena instance, including the access key, secret key, and the region your data is stored in 5\ select which custify object you want to create from your data people, events, or companies 6\ select the source data in your athena managed amazon s3 bucket 7\ choose the database and table in aws athena that contains your source data 8\ map the fields in your source data to the fields expected by custify 9\ map your athena data fields to custify’s data objects to ensure proper synchronization and data integrity by setting up this integration, your customer success team can leverage the power of aws athena and custify to gain real time insights and drive customer engagement and retention strategies effectively