6/10/2023 0 Comments Redshift federated queryOverview of Athena Federated QueryĪthena Federated Query uses data source connectors that run on AWS Lambda to run federated queries to other data sources. You can also use QuickSight Q to allow users to ask questions using natural language and find answers to business questions immediately. QuickSight is a serverless business analytics service with built-in machine learning (ML) capabilities that can automatically look for patterns and outliers, and has the flexibility to embed dashboards in applications for a data-driven experience. ![]() Databases are a popular choice for UI applications for managing user profiles, product catalogs, profile views, clickstream events, events from a connected device, and so on. You can choose to deploy MongoDB as a self-hosted or fully-managed database. MongoDB is a popular NoSQL database option for websites and API endpoints. With Athena Federated Query, you can run SQL queries across data that is stored in relational, non-relational, object, and custom data sources. For data that isn’t stored on Amazon S3, you can use Athena Federated Query to query the data in place or build pipelines that extract data from multiple data sources and store it in Amazon S3. In this post, you will learn how to use Amazon Athena Federated Query to connect a MongoDB database to Amazon QuickSight in order to build dashboards and visualizations.Īmazon Athena is a serverless interactive query service, based on Presto, that provides full ANSI SQL support to query a variety of standard data formats, including CSV, JSON, ORC, Avro, and Parquet, that are stored on Amazon Simple Storage Service (Amazon S3).
0 Comments
Leave a Reply. |