Federated queries with Athena

As you become more familiar with the types and locations of spatial data in AWS, a feature that you may find particularly useful is Athena Federated Query. Whether your geospatial data lives in S3 or one of the relational or NoSQL databases, federated queries give you the ability to query across data sources and formats without moving your data. Athena Federated Query uses Lambda functions to provide connectivity between Athena and other data source services in your AWS account. This can incorporate known AWS source formats as well as custom formats due to the nature of the connector architecture. Having the ability to define how the connection is made and the parameters that are used provides the flexibility to connect to virtually any data source.

Federated queries in Athena allow you to connect to data sources and fetch records back to Athena. These results can be joined with data from other sources using the familiar SQL-like syntax. This capability...