Azure SQL Snap Pack examples

The following examples demonstrate how to use Snaps in the Azure SQL Snap Pack.

Example Snaps used

Basic Use Case (Azure SQL Bulk Extract)

In this pipeline, the Bulk Extract Snap retrieves the data from a table on the Azure Database. The output view is parsed in a JSON format.

Basic Use Case (Azure SQL Bulk Load)

In this Pipeline, the Azure SQL Bulk Load Snap loads the data from the input stream. The data is bulk loaded into the table "dbo"."datatypetest".

Typical Snap Configurations (Azure SQL Bulk Load)

The key configurations for the Snap are:

Advanced Use Case

The following describes a Pipeline, with a broader business logic involving multiple ETL transformations, that shows how typically in an enterprise environment, Azure SQL Bulk Load functionality is used.

Azure SQL - Execute Snap as a Standalone Pipeline

The following pipeline describes how the Snap functions as a standalone Snap in a pipeline:

Typical Snap Configurations (Azure SQL Execute)

The key configuration of the Azure SQL - Execute lies in how you pass the SQL statement to read Azure records. As it applies in SnapLogic, you can pass SQL statements in the following manner:

Extract, Transform, Load

The following example use case demonstrates a broader business logic involving the ETL transformations, that shows how typically in an enterprise environment, an execute functionality is used.

Basic Use Case (Azure SQL - Stored Procedure)

Demonstrates invoking a stored procedure in an Azure SQL Database, passing an input parameter from an upstream Snap and retrieving results in the result set output view.

Basic Use Case (Azure SQL - Table List)

Demonstrates retrieving all tables from the dbo schema, including dependency order when the Compute table graph option is enabled.

Basic Use Case (Azure SQL - Update)

Demonstrates updating records in an Azure SQL table using an input document from an upstream Snap, with a static update condition.

Typical Snap Configurations (Azure SQL - Update)

Shows how to pass the Update Condition with or without expressions, using upstream document values or pipeline parameters.

Basic Use Case (PolyBase Bulk Load)

Demonstrates a simple ETL pipeline using JSON Generator, Mapper, and PolyBase Bulk Load Snaps to load records into a SQL Server table with PolyBase enabled.

Advanced Use Case (PolyBase Bulk Load)

Demonstrates an enterprise ETL pipeline combining data extraction, transformation, and PolyBase bulk loading into a SQL Server table.