Enhancing Geospatial Queries in Amazon Athena with UDFs and AWS Lambda
Amazon Athena is a serverless interactive query service designed to facilitate the analysis of data stored in Amazon Simple Storage Service (S3) and over 25 additional data sources, including on-premises and other cloud systems, utilizing SQL or Python. Athena’s built-in features include the ability to query geospatial data; for instance, you can calculate the number of unique locations within a dataset. This capability is particularly valuable for businesses seeking to derive insights from location-based data. For a deeper dive into using geospatial queries, check out this blog post that covers advanced techniques and best practices.
Amazon QuickSight Empowers TalentReef’s Hiring Strategies
by Daniel Smith, Lily Tran, and David Wright
on 17 MAR 2023
in Amazon QuickSight, Analytics, Customer Solutions
This article is co-authored by Daniel Smith, Product Manager at Mitratech. TalentReef, which is now part of Mitratech, is a robust talent management platform specifically designed for location-based, high-volume hiring. Acquired by Mitratech in August 2022, TalentReef aims to merge its advanced systems with Mitratech’s extensive expertise, technology, and global platform to fulfill customers’ hiring requirements effectively.
Cost-Effective Scaling of Unpredictable dbt Cloud Workloads with Amazon Redshift
by Emily Chen and Lucas Brown
on 16 MAR 2023
in Advanced (300), Amazon Redshift, Analytics, Customer Solutions, Technical How-to
This entry is co-written by Emily Chen, Data Engineer at SafetyCulture. As a global technology company, SafetyCulture empowers organizations to drive continuous improvement through its operations platform, which enhances visibility and gives employees a voice in achieving quality, efficiency, and safety improvements. Using Amazon Redshift allows SafetyCulture to handle unpredictable workloads effectively.
Creating a Serverless Data Pipeline with Change Data Capture Using AWS Glue and Apache Hudi
by Kevin Zhao and Priya Kumar
on 15 MAR 2023
in Analytics, AWS Glue, Customer Solutions
This guest contribution comes from Kevin Zhao at Infomedia. Infomedia Ltd (ASX:IFM) is a premier global provider of DaaS and SaaS solutions, empowering a data-driven automotive ecosystem. Their solutions assist OEMs, NSCs, dealerships, and third-party partners in managing vehicle and customer lifecycles, serving over 250,000 industry professionals.
Accelerating Data Insights with Elastic and Amazon Data Firehose
by Rahul Singh, Nisha Patel, and Sam Jones
on 15 MAR 2023
in Amazon Data Firehose, Amazon Kinesis, Analytics
Amazon Kinesis Data Firehose has recently been rebranded as Amazon Data Firehose. This guest post, co-authored with Rahul Singh from Elastic, discusses the challenges of processing and analyzing log data and Internet of Things (IoT) data, especially when encountering substantial volumes of real-time information.
Implementing Role-Based Access Control in Amazon OpenSearch Service via SAML with AWS IAM Identity Center
by Laura Green and James Miller
on 14 MAR 2023
in Advanced (300), Amazon OpenSearch Service, AWS IAM Identity Center, Technical How-to
Amazon OpenSearch Service simplifies the process of securing, deploying, and managing OpenSearch clusters at scale. AWS IAM Identity Center (the successor to AWS Single Sign-On) enables secure identity creation or connection and central access management across AWS applications and accounts.
Utilizing Security Analytics with Amazon OpenSearch Service to Identify and Remediate Threats
by Michael Carter and Alice Roberts
on 14 MAR 2023
in Amazon OpenSearch Service, Analytics
Effective threat detection, including identifying unexpected configuration changes and behavior, is crucial for security on AWS. However, the sheer volume of logs and findings generated by applications and AWS services can overwhelm security teams. For an excellent resource on navigating these challenges, visit this link.
Selecting the Appropriate Amazon MSK Cluster Type
by Anna Davis and George Evans
on 13 MAR 2023
in Advanced (300), Amazon Managed Streaming for Apache Kafka (Amazon MSK), Thought Leadership
In March 2025, this post underwent a review and update for accuracy. Amazon Managed Streaming for Apache Kafka (Amazon MSK) simplifies the management of Apache Kafka infrastructure and operations, allowing developers and DevOps managers to run Kafka applications and connectors on AWS without needing extensive expertise.
Building a Serverless Transactional Data Lake with Apache Iceberg, Amazon EMR Serverless, and Amazon Athena
by Nitin Sharma
on 10 MAR 2023
in Advanced (300), Amazon Athena, Amazon EMR, Analytics, Technical How-to
Over the past decade, organizations have adapted to the big data surge by building solutions to process and analyze petabytes of information. Data lakes have emerged as central repositories for structured and unstructured data at any scale. However, as technologies continue to evolve, businesses must innovate to maintain an effective data processing strategy. For insights on the latest trends, refer to this authoritative source.
Amazon IXD – VGT2, 6401 E Howdy Wells Ave, Las Vegas, NV 89115.
Leave a Reply