Recipes for the ELT Pipeline for Snowflake accelerator

This accelerator contains a set of recipes to implement the ELT Pipeline for Snowflake bot in Slack and a collection of recipes to implement the bot in Teams. The recipes relevant to you depend on which package you install.

• Recipes for Slack are located in ELT_Pipeline_for_Slack.zip
• Recipes for Teams are located in ELT_Pipeline_for_MS_Teams.zip.

Recipes for Slack

The recipes in this version of the accelerator are organized in the following folders:

• 04 Functions
• 03 Data Load
• 02 Controller
• 01 UI

04 Functions

ELT | FUNC-005 | Error Handling [Slack]

ELT | FUNC-004 | Get ELT Control Table Results [Slack]

ELT | FUNC-003 | Notify ELT User [Slack]

ELT | FUNC-002 | Pre-Processing before MERGE [Slack]

ELT | FUNC-001 | Pre-Processing of Schema [Slack]

03 Data Load

ELT | DTL-003 | Files | Extract and Load [Slack]

ELT | DTL-002b | PostgreSQL | Extract and Load [Slack]

ELT | DTL-002a | SQL Server | Extract and Load [Slack]

ELT | DTL-001 | Salesforce | Extract and Load [Slack]

02 Controller

ELT | REC-001 | Pipeline Scheduler [Slack]

ELT | CAL-001 | Job Dispatcher [Slack]

01 UI

ELT | SUI-002 | Manage Pipeline

ELT | SUI-001 | App Home Page

Recipes for Teams

The recipes in this version of the accelerator are organized in the following folders:

• 04 Functions
• 03 Data Load
• 02 Controller
• 01 UI

04 Functions

ELT | FUNC-005 | Error Handling [MSTeams]

ELT | FUNC-004 | Get ELT Control Table Results [MSTeams]

ELT | FUNC-003 | Notify ELT User [MSTeams]

ELT | FUNC-002 | Pre-Processing before MERGE [MSTeams]

ELT | FUNC-001 | Pre-Processing of Schema [MSTeams]

03 Data Load

ELT | DTL-003 | Files | Extract and Load [MSTeams]

ELT | DTL-002b | PostgreSQL | Extract and Load [MSTeams]

ELT | DTL-002a | SQL Server | Extract and Load [MSTeams]

ELT | DTL-001 | Salesforce | Extract and Load [MSTeams]

02 Controller

ELT | REC-001 | Pipeline Scheduler [MSTeams]

ELT | CAL-001 | Job Dispatcher [MSTeams]

01 UI

ELT | SUI-002 | Manage Pipeline [MSTeams]

ELT | SUI-001 | Teams App Home Page