I have used Snowflake extensively. What is the difference between Snowflake and DynamoDB? Why did you use Snowflake and for what purpose?

Snowflake is a cloud data warehouse that stores data in a columnar format, supports SQL, and automatically scales compute and storage independently. It is optimized for analytical queries, complex joins, and large‑scale data transformations. DynamoDB is a managed NoSQL key‑value and document database that provides single‑digit millisecond latency for read/write operations. It is designed for high‑throughput, low‑latency transactional workloads. I chose Snowflake for a project that required aggregating terabytes of log data, running ad‑hoc analytics, and feeding dashboards. Snowflake’s elastic compute allowed me to spin up warehouses for peak query loads without over‑provisioning, and its support for semi‑structured data (JSON, Avro) simplified ingestion. DynamoDB would have been a poor fit for that use case because it lacks native SQL support, complex join capabilities, and efficient analytical query performance.