Retrieve data from Azure Synapse SQL with a condition

This example Pipeline demonstrates how to retrieve data from an employee table by specifying a condition to retrieve only those fields where the account type is Savings.

• Azure Synapse SQL Select

Insert records by creating a new table in Azure Synapse SQL

This example Pipeline demonstrates how to insert data into a table. The table 'employee1' does not exist on the database initially. So, the Snap first creates the table 'Employee1' and then inserts the records read and parsed using the upstream Snaps.

• Azure Synapse SQL Insert
• File Reader
• CSV Parser

Update data in an employee table based on a condition

This example Pipeline demonstrates how to update data in an employee table by specifying a condition to update.

• Azure Synapse SQL Update

Delete employee records from Azure Synapse SQL with a condition

This example Pipeline demonstrates how to delete employee records from the employee table by specifying a delete condition.

• Azure Synapse SQL Delete
• File Reader
• CSV Parser
• Mapper

Execute SQL statements in Azure Synapse SQL

This example Pipeline demonstrates how to execute SQL statements to create a table and perform insert and delete operations.

• Azure Synapse SQL Execute
• JSON Formatter
• File Writer

Load data in bulk from Snowflake to Azure Synapse SQL

This example Pipeline demonstrates how to load data in bulk using the Azure Synapse SQL Bulk Load Snap.

• Azure Synapse SQL Bulk Load
• Snowflake - Select

Call a stored procedure in Azure Synapse SQL

This example Pipeline demonstrates how to call a simple stored procedure.

• Azure Synapse SQL Stored Procedure
• JSON Formatter
• File Writer

List tables from Azure Synapse SQL database

This example Pipeline demonstrates how to read data from the Azure Synapse database and list the tables.

• Azure Synapse SQL Table List