ELT & CDC uses Snowflake compute resource in auto suspend and auto-resume mode to run queries to load data from an external stage. You have an option to either run a ELT & CDC dedicated compute warehouse and provide a database for ELT & CDC to load data or choose an existing warehouse and database to load.
Using an existing warehouse is recommended to minimise compute resources usage and cost for loading data from any source to Snowflake
- Any one of the ACCOUNTADMIN, SYSADMIN or SECURITYADMIN access for running the prerequisite/setup steps.
Copy the user script and run on your snowflake worksheet.
Copy the role script and run on your snowflake worksheet.
Copy the integration script and run on your snowflake worksheet.
Register your Snowflake Account Identifier, Warehouse, Username, PW, Role, DB and Schema on the dashboard
Note that the all details here (username, password, etc) should be the same with the one you executed on your snowflake worksheet. Input your snowflake identifier per dashboard instruction.