> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sonarx.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Quick map of AWS services → Snowflake / Databricks
> Some AWS services have direct, documented integrations with Snowflake and/or Databricks, while others are indirect - here is a clear map, service by service, plus links
### Quick map (AWS service → Snowflake / Databricks)
* **Athena**
* Snowflake: **Direct** via the **Athena Snowflake connector** (federated query over JDBC; registered in Glue/Lake Formation).
[Amazon Athena Snowflake connector - AWS Documentation](https://docs.aws.amazon.com/athena/latest/ug/connectors-snowflake.html)
* Databricks: **Indirect**—Athena can read **Delta Lake** tables in S3 (so it can query Databricks-written Delta data) when tables are in **Glue Catalog**.
[1. Athena enhances read support for Delta Lake table format - AWS](https://aws.amazon.com/about-aws/whats-new/2022/12/athena-enhances-read-support-delta-lake-table-format)
\
[2. Query Linux Foundation Delta Lake tables - AWS Documentation](https://docs.aws.amazon.com/athena/latest/ug/delta-lake-tables.html)
* **AWS Glue**
* Snowflake: **Direct**—native Glue → Snowflake connectivity GA (read/write; Glue Studio source/target).
[1. Snowflake connectivity for AWS Glue for Apache Spark is now generally available - AWS](https://aws.amazon.com/about-aws/whats-new/2023/07/snowflake-connectivity-aws-glue-apache-spark/)
\
[2. Snowflake connections - AWS Documentation](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-connect-snowflake-home.html)
* Databricks: **Works with** Glue catalog patterns (historic); Databricks now recommends **Unity Catalog** but still documents federation to Glue.
[Databricks jobs using AWS Glue Data Catalog failing due to inability to reach cluster drivers - Databricks](https://kb.databricks.com/en_US/data-sources/databricks-jobs-using-aws-glue-data-catalog-failing-due-to-inability-to-reach-cluster-drivers)
* **QuickSight**
* Snowflake: **Direct**—native QuickSight connector to Snowflake.
[SnowflakeParameters - AWS QuickSight API Documentation](https://docs.aws.amazon.com/quicksight/latest/APIReference/API_SnowflakeParameters.html)
* Databricks: **Direct**—native QuickSight connector to Databricks SQL. [Amazon Web Services, Inc.](https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-quicksight-supports-connectivity-databricks/?utm_source=chatgpt.com)
[Amazon QuickSight now supports connectivity to Databricks - AWS](https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-quicksight-supports-connectivity-databricks)
* **Kinesis / Firehose**
* Snowflake: **Direct** via **Firehose → Snowpipe Streaming** (seconds-level ingest); classic Snowpipe via S3 also works.
[Uplevel your data architecture with real- time streaming using Amazon Data Firehose and Snowflake - AWS](https://aws.amazon.com/blogs/big-data/uplevel-your-data-architecture-with-real-time-streaming-using-amazon-data-firehose-and-snowflake)
* Databricks: **Direct**—Structured Streaming connector for **Kinesis** (source/sink).
[Connect to Amazon Kinesis - Databricks Documentation](https://docs.databricks.com/aws/en/connect/streaming/kinesis)
* **S3 + SQS/SNS (events)**
* Snowflake: **Direct**—Snowpipe auto-ingest uses **S3 events → SQS**; can fan-out via **SNS**; error notifications to SNS supported.
[1. Automating Snowpipe for Amazon S3 - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3)
\
[2. Enabling Snowpipe error notifications for Amazon SNS - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-errors-sns)
* Databricks: **Common**—uses S3 natively; SQS/SNS typically via AWS SDKs or event fan-out into Kinesis/Firehose (no special first-party SQS listener).
* **DynamoDB**
* Snowflake: **No native direct**; typical paths are **Glue ETL** or 3rd-party CDC/ETL to S3/Snowpipe.
[DynamoDB connections - AWS Documentation](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-connect-dynamodb-home.html)
* Databricks: **Via Spark connectors/partners** (for example, DynamoDB Spark/EMR connector; partner tools).
[The Amazon EMR-DynamoDB Connector for Apache Hive and Apache Spark is now open-source - AWS](https://aws.amazon.com/about-aws/whats-new/2016/09/the-amazon-emr-dynamodb-connector-for-apache-hive-and-apache-spark-is-now-open-source/)
* **Redshift**
* Snowflake / Databricks: **No native direct bridge**. Use **S3 interchange** (UNLOAD/COPY), Athena federation where applicable, or partner ETL. (AWS and 3P references illustrate S3/ETL patterns.)
[Stream data from Snowflake Data Cloud to Amazon Redshift - Estuary](https://estuary.dev/integrations/snowflake-to-redshift)
* **EMR**
* Snowflake: **Indirect** via S3/Glue pipelines.
* Databricks: **Parallel platforms**; “integration” is usually **shared S3 data + Glue Catalog** (EMR uses Glue as Hive metastore).
[Using the AWS Glue Data Catalog as the metastore for Hive - AWS Documentation](https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-hive-metastore-glue.html)
* **Timestream**
* Snowflake / Databricks: **No first-party direct** integration documented; common approaches are **export to S3** (then Snowpipe/Delta), **Athena/SDK/JDBC** middle tiers. (No official Snowflake/Databricks connector pages.)
* **SNS/SQS (messaging)**
* Snowflake: see **Snowpipe auto-ingest + SNS error notifications**.
[1. Enabling Snowpipe error notifications for Amazon SNS - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-errors-sns)
\
[2. Automating Snowpipe for Amazon S3 - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3)
* Databricks: handled via AWS SDKs/streams (or route through **Kinesis/Firehose**).
***
## How to choose (fast decisioning)
* **Query Snowflake from AWS analytics?** Use **Athena Snowflake connector** (governed via Glue/Lake Formation).
[1. Amazon Athena Snowflake connector - AWS Documentation](https://docs.aws.amazon.com/athena/latest/ug/connectors-snowflake.html)
* **ETL between Snowflake and AWS data lake/services?** Prefer **Glue’s native Snowflake connectivity** (Studio visual jobs; SQL source; upsert/merge).
[Snowflake connectivity for AWS Glue for Apache Spark is now generally available - AWS](https://aws.amazon.com/about-aws/whats-new/2023/07/snowflake-connectivity-aws-glue-apache-spark/)
* **Real-time into Snowflake?** **Firehose → Snowpipe Streaming** (or S3→Snowpipe with SQS/SNS).
[1. Uplevel your data architecture with real- time streaming using Amazon Data Firehose and Snowflake - AWS](https://aws.amazon.com/blogs/big-data/uplevel-your-data-architecture-with-real-time-streaming-using-amazon-data-firehose-and-snowflake)
\
[2. Automating Snowpipe for Amazon S3 - Snowflake Documentation](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3)
* **Real-time with Databricks?** **Kinesis Structured Streaming** (or MSK).
[Connect to Amazon Kinesis - Databricks Documentation](https://docs.databricks.com/aws/en/connect/streaming/kinesis)
* **BI on Snowflake/Databricks?** **QuickSight native connectors** for both.
[SnowflakeParameters - AWS QuickSight API Documentation](https://docs.aws.amazon.com/quicksight/latest/APIReference/API_SnowflakeParameters.html)
\
[Amazon QuickSight now supports connectivity to Databricks - AWS](https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-quicksight-supports-connectivity-databricks)
* **Athena on Databricks-written data?** Store as **Delta Lake** in S3 with **Glue catalog**; Athena reads it natively.
[1. Athena enhances read support for Delta Lake table format - AWS](https://aws.amazon.com/about-aws/whats-new/2022/12/athena-enhances-read-support-delta-lake-table-format)
\
[2. Query Linux Foundation Delta Lake tables - AWS Documentation](https://docs.aws.amazon.com/athena/latest/ug/delta-lake-tables.html)