Data Snaps

The Data Snaps enable you to integrate applications that span data processing, data streaming, databases, storage systems, and big data.

In this Section

Azure SQL Snap Pack
- Configuring Azure SQL Accounts
- Azure SQL - Bulk Extract
- Azure SQL - Bulk Load
- Azure SQL - Execute
- Azure SQL - Stored Procedure
- Azure SQL - Table List
- Azure SQL - Update
- PolyBase Bulk Load
Azure Synapse SQL Snap Pack
- Configure Storage Account in Azure Portal for Azure Synapse SQL Account
- Configuring Azure Synapse SQL Accounts
- Azure Synapse SQL - Bulk Load
- Azure Synapse SQL Delete
- Azure Synapse SQL - Execute
- Azure Synapse SQL Insert
- Azure Synapse SQL Select
- Azure Synapse SQL Stored Procedure
- Azure Synapse SQL Table List
- Azure Synapse SQL Update
- Use Case: Reading Data from Snowflake and Loading into Azure Synapse
- Use Case: Querying Data From Azure Blob Storage
Cassandra Snap Pack
- Configuring Cassandra Accounts
- Cassandra - Execute
- Cassandra - Select
Databricks Snap Pack
- Configuring Databricks Accounts
- Databricks - Bulk Load
- Databricks - Delete
- Databricks - Execute
- Databricks - Insert
- Databricks - Merge Into
- Databricks - Select
- Databricks - Unload
DynamoDB Snap Pack
- Configuring DynamoDB Account
- DynamoDB Update
- DynamoDB Bulk Get
- DynamoDB Bulk Write
- DynamoDB Delete Table
- DynamoDB Delete Table Item
- DynamoDB Query
- DynamoDB Scan
ELT Snap Pack
- Best Practices for Using the ELT Snap Pack
- SQL Expressions and Functions Supported for ELT
- Subquery Pushdown Optimization (SPDO)
- Configuring ELT Database Accounts
- ELT Aggregate
- ELT Case Expression
- ELT Cast Function
- ELT Coalesce
- ELT Conditional Function
- ELT Copy
- ELT Create View
- ELT Execute
- ELT Filter
- ELT Insert-Select
- ELT Intersect
- ELT Join
- ELT Limit
- ELT Load
- ELT Math Function
- ELT Merge Into
- ELT Minus
- ELT Pivot
- ELT Router
- ELT SCD2
- ELT Sample
- ELT Select
- ELT Sort
- ELT String Function
- ELT Transform
- ELT Union
- ELT Unique
- ELT Unpivot
- ELT Window Functions
- SnapLogic ELT Use Cases
Google AlloyDB Snap Pack
- Configuring Google AlloyDB Accounts
- AlloyDB Bulk Load
- AlloyDB Delete
- AlloyDB Execute
- AlloyDB Insert
- AlloyDB Lookup
- AlloyDB Select
- AlloyDB Table List
- AlloyDB Update
Google BigQuery Snap Pack
- Configuring Google BigQuery Accounts
- BigQuery Bulk Load (Cloud Storage)
- BigQuery Bulk Load (Streaming)
- BigQuery Execute
- BigQuery Write
- BigQuery Dataset Create
- BigQuery Dataset Delete
- BigQuery Dataset List
- BigQuery Table Create
- BigQuery Table Data List
- BigQuery Table Delete
- BigQuery Table List
- BigQuery Upsert (Streaming)
Hadoop Snap Pack
- Configuring Hadoop Accounts
- HDFS Encryption
- Hadoop Directory Browser
- HDFS Delete
- HDFS Reader
- HDFS Writer
- HDFS ZipFile Reader
- HDFS ZipFile Writer
- ORC Reader
- ORC Writer
- Parquet Reader
- Parquet Writer
- RC File Formatter
- RC File Parser
- Sequence Formatter
- Sequence Parser
Hive Snap Pack
- Configuring Hive Accounts
- Hive - Execute
Kafka Snap Pack
- Configuring Kafka Accounts
- Kafka Acknowledge
- Kafka Consumer
- Kafka Producer
MongoDB Snap Pack
- Configuring MongoDB Accounts
- MongoDB - Delete
- MongoDB - Execute
- MongoDB - Find
- MongoDB - Group
- MongoDB - Insert
- MongoDB - Update
MySQL Snap Pack
- Configuring MySQL Accounts
- MySQL - Bulk Load
- MySQL - Delete
- MySQL - Execute
- MySQL - Insert
- MySQL - Lookup
- MySQL - Merge
- MySQL - Multi Execute
- MySQL - Select
- MySQL - Stored Procedure
- MySQL - Table List
- MySQL - Update
Oracle Snap Pack
- Oracle JDBC Driver Upgrade from v11.2.0.4 to v19.20.0.0 and JOOQ Upgrade from v3.9.1 to 3.17.x
- Configuring Oracle Accounts
- Oracle - Bulk Load
- Oracle - Delete
- Oracle - Execute
- Oracle - Update
- Oracle - Insert
- Oracle - Lookup
- Oracle - Merge
- Oracle - Select
- Oracle - Stored Procedure
- Oracle - Table List
PostgreSQL Snap Pack
- Configuring PostgreSQL Accounts
- PostgreSQL - Bulk Load
- PostgreSQL - Delete
- PostgreSQL - Execute
- PostgreSQL - Insert
- PostgreSQL - Lookup
- PostgreSQL - Select
- PostgreSQL - Table List
- PostgreSQL - Update
- PostgreSQL JDBC driver from v9.4.1207 to v42.7.2
Redshift Snap Pack
- Migrating from the PostgreSQL JDBC Driver to the Amazon Redshift JDBC Driver
- Setup for Redshift Cross Account IAM Role
- Configuring Redshift Accounts
- Redshift - Bulk Load
- Redshift - Bulk Upsert
- Redshift - Delete
- Redshift - Insert
- Redshift - Lookup
- Redshift - Multi Execute
- Redshift - S3 Upsert
- Redshift - SCD2
- Redshift - Select
- Redshift - Execute
- Redshift - Table List
- Redshift - Unload
- Redshift - Update
SAP HANA Snap Pack
- Configuring SAP HANA Accounts
- SAP HANA - Delete
- SAP HANA - Execute
- SAP HANA - Insert
- SAP HANA - Select
- SAP HANA - Stored Procedure
- SAP HANA - Table List
- SAP HANA - Update
- SAP HANA - Upsert
Snowflake Snap Pack
- Configuring Snowflake Accounts
- Snowflake - Bulk Load
- Snowflake - Bulk Upsert
- Snowflake - Delete
- Snowflake - Execute
- Snowflake - Insert
- Snowflake - Lookup
- Snowflake - Multi Execute
- Snowflake SCD2
- Snowflake - Select
- Snowflake - Table List
- Snowflake - Unload
- Snowflake - Update
- Use Case: Move Data Using Snowflake Snap Pack
SQL Server Snap Pack
- Configuring SQL Server Accounts
- SQL Server - Bulk Load
- SQL Server - Delete
- SQL Server - Execute
- SQL Server - Insert
- SQL Server - Lookup
- SQL Server - Merge
- SQL Server - Select
- SQL Server - Table List
- SQL Server - Stored Procedure
- SQL Server - Update
Teradata Snap Pack
- Teradata Select
- TPT Load
- Teradata Export to HDFS
- TPT Insert
- Configuring Teradata Database Accounts
- Teradata Execute
- Teradata FastExport
- TPT Delete
- TPT FastExport
- Teradata FastLoad
- TPT Update
- TPT Upsert
Vertica Snap Pack
- Configuring Vertica Accounts
- Vertica - Bulk Load
- Vertica - Bulk Upsert
- Vertica - Delete
- Vertica - Execute
- Vertica - Insert
- Vertica - Lookup
- Vertica - Multi Execute
- Vertica - Select
- Vertica - Table List
- Vertica - Update