...
Your use of this download is governed by Stonebranch’s Terms of Use, which are available at https://www.stonebranch.com/integration-hub/Terms-and-Privacy/Terms-of-Use/
...
Overview
This Universal Task allows Stonebranch users to orchestrate, schedule, trigger, and monitor the Snowflake load and unload process from different data sources (cloud storage or local VM’s) directly from Universal Controller. It uses Python libraries to perform all functions listed in the following sections. Alternatively, you also can perform all these operations using the snowflake JDBC driver which you can add to the Universal Controller libraries, and use SQL Task to perform any operations with Snowflake (https://docs.snowflake.com/en/user-guide/jdbc-download.html)
...
Users can orchestrate the Snowflake functionalities using the following features available in the Universal Task
...
Software Requirements for /wiki/spaces/UC71x/pages/5178050 and /wiki/spaces/UC71x/pages/5180675 Universal Template and Universal Task
Requires Python 3.6 or higher. Tested with the Universal Agent bundled Python distribution.
Python modules required:
- https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/v2.3.9/tested_requirements/requirements_36.reqs
- snowflake-connector-python
- snowflake-ingest
- Please refer to Snowflake URL : https://docs.snowflake.com/en/user-guide/python-connector-install.html for the latest Python connector details.
...
Universal Agent for Windows x64 Version 67.6 0 and later with Python options installed.
Universal Agent for Linux Version 67.6 0 and later with Python options installed.
...
Universal Controller Version 67.60.0.0 and later.
Software Requirements for the Application to be Scheduled
...
To use this downloadable Universal Template, you first must perform the following steps:
- This Universal Task requires the /wiki/spaces/UC71x/pages/5178443 Resolvable Credentials feature. Check that the/wiki/spaces/UC71x/pages/5177877 Resolvable Credentials Permitted system property has been set to true.
- Copy or Transfer To import the Universal Template file to a directory that can be accessed by the Universal Controller Tomcat user.
In the Universal Controller UI, select Configuration > Universal Templates to display the current list of /wiki/spaces/UC71x/pages/5178054.
Right-click any column header on the list to display an Action menu.
Select Import from the menu, enter the directory containing the Universal Template file(s) that you want to import, and click OK.
- into your Controller, follow the instructions here.
- When the files have been imported successfully, refresh the Universal Templates list; the Universal Template will appear on the list.
Configure Snowflake Integration Universal Task
...
This document references the following documents:
NameLocation | Description | |
|---|---|---|
https://docs.stonebranch.com/confluence/display/UC71x/Universal+Templates | User documentation for creating Universal Templates in the Universal Controller user interface. | |
Universal Taskshttps://docs.stonebranch.com/confluence/display/UC71x/Universal+ Tasks | User documentation for creating Universal Tasks in the Universal Controller user interface. |
...