Data Snaps

Amazon Athena Snap Pack: Enables querying and analyzing data stored in Amazon S3 using SQL with Amazon Athena.

Azure SQL Snap Pack: Enables you to connect to Azure SQL Server, a cloud-native SQL database. You can bulk extract and bulk load data, execute SQL statements, run stored procedures, list tables, and update records.

Azure Synapse SQL Snap Pack: Enables you to query and analyze big data using Azure Synapse SQL with T-SQL language. You can execute SQL statements, fetch data, manage tables, and run stored procedures for data analytics and warehousing operations.

Cassandra Snap Pack : Enables you to work with data in Apache Cassandra, a distributed NoSQL database. You can execute Cassandra Select operations and run CQL statements or queries.

Databricks Snap Pack : Enables you to integrate with Databricks Data Science & Engineering environment (Databricks Lakehouse Platform) for unified analytics and data processing.

DynamoDB Snap Pack : Enables you to read, write, update, query, and delete data in Amazon DynamoDB tables. Provides seamless integration with Amazon's NoSQL database service for efficient data management and scalable operations.

Google AlloyDB Snap Pack : Enables you to connect to Google AlloyDB, a fully managed PostgreSQL-compatible database. You can execute SQL operations, perform bulk loads, manage tables, and leverage vector search capabilities for AI and ML workloads.

Google BigQuery Snap Pack: Enables you to integrate with Google BigQuery for big data analytics. You can execute SQL queries, manage datasets and tables, and perform bulk load and upsert operations using cloud storage and streaming APIs.

Hadoop Snap Pack: Enables reading and writing data to Hadoop Distributed File System (HDFS) using various file formats including Parquet, ORC, and RC files.

Hive Snap Pack : Provides a SQL-like interface to data stored in Hadoop distributions, including Cloudera, Hortonworks, and others.

Kafka Snap Pack: Enables you to access Apache Kafka and Confluent Kafka to produce and consume messages. You can integrate real-time data streams, publish and consume messages from Kafka topics, and acknowledge processed messages to maintain delivery guarantees.

MongoDB Snap Pack: Enables you to read from and write to MongoDB, a cross‑platform document-oriented database. You can perform operations such as finding, inserting, updating, deleting, and aggregating documents in MongoDB collections, as well as running advanced vector searches on MongoDB Atlas.

MySQL Snap Pack: Enables you to connect to MySQL databases and perform data operations. You can execute SQL statements, run stored procedures, perform bulk loads, and manage data through insert, update, delete, merge, lookup, and select operations.

OpenSearch Snap Pack: Enables you to integrate with OpenSearch database, providing robust search and analytics capabilities. Facilitates efficient data retrieval and analysis with superior performance and scalability for managing large datasets.

Oracle Snap Pack: Enables you to connect to Oracle databases (11i, 12c, or 19c) and perform SQL operations. You can list tables, lookup records, fetch data, execute SQL statements to delete, update, merge, or insert data, run stored procedures, and perform bulk load or parallel load operations.

Oracle CDC Snap Pack: Enables efficient data replication, synchronization, and integration with other systems by capturing incremental changes from Oracle databases rather than processing the entire dataset.

Pinecone Snap Pack: Enables you to connect and synchronize your data with Pinecone's vector database, enabling quick similarity search and advanced machine learning capabilities with efficient data handling and superior search performance.

PostgreSQL Snap Pack: Enables you to connect to PostgreSQL databases and perform comprehensive data operations. You can execute SQL statements, perform bulk loads and upserts, manage tables, run queries, and leverage vector search capabilities for AI workloads.

Redshift Snap Pack: Enables seamless integration with Amazon Redshift data warehouse for performing data operations such as bulk loading, querying, inserting, updating, and deleting records with efficient data transfer for large-scale analytics workloads.

SAP HANA Snap Pack: Enables you to connect with and manage data in SAP HANA environments. Provides comprehensive functionality for executing SQL operations, data manipulation, and integration with SAP's in-memory database.

Snowflake Snap Pack: Enables you to integrate with Snowflake cloud data platform with support for vectors, schema generation, and vector data types. You can insert, upsert, update, unload, execute, and delete records, query instances, execute multiple queries, and enable SCD2 to track the history of changes.

SQL Server Snap Pack: Enables you to connect to Microsoft SQL Server databases and perform comprehensive data operations. You can execute SQL statements, run stored procedures, manage tables, and perform data manipulation through various operations.

SQL Server CDC Snap Pack: Enables you to identify and capture changes made to data in SQL Server databases. Enables efficient data replication, synchronization, and integration with other systems by capturing incremental changes rather than processing the entire dataset.

Teradata Snap Pack: Enables you to connect to Teradata databases and perform data operations. You can select, execute, and perform multi-execute operations, load and export data using FastLoad, FastExport, and TPT operations, and export data from Teradata to HDFS.

Vertica Snap Pack: Enables you to connect to Vertica databases and perform data operations. You can insert, update, merge, lookup, and select records, as well as perform bulk loads and updates.