Configure the ELT Pipeline for Snowflake accelerator ​

Before you start this accelerator, you must configure your lookup tables, custom OAuth profile, and an OPA and OPG.

Set up your lookup tables ​

You must set up the ELT | User Access lookup table and ELT | System Access lookup table before starting the accelerator.

Set up the ELT | User Access lookup table ​

Set up the ELT | Systems lookup table ​

Workato preconfigures the ELT | Systems lookup table with four sources:

• Salesforce
• SQL Server
• PostgreSQL
• On-prem files

If you don't need to use some of these sources, you can remove them by editing this lookup table.

Set up an OPA and OPG ​

See our On-prem connectivity documentation for instructions on setting up your on-prem agent (OPA) and on-prem group (OPG).

When setting up an OPA, you must create a connection profile for each application. The application profile uniquely identifies each application and contains the configuration information required to connect. See the ELT pipeline accelerator connections documentation for a list of profiles you must create.

Set up a Custom OAuth Profile for Workbot ​

The ELT Pipeline Workbot requires a Custom OAuth profile. Create the profile before connecting to Slack or Microsoft Teams. See our Setting up a Slack Enterprise Workbot or Setting up an Microsoft Teams Workbot documentation for instructions.