...
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)
Overview
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 6.6 9 and later with Python options installed.
Universal Agent for Linux Version 6.6 9 and later with Python options installed.
...
Universal Controller Version 6.69.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 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 Universal Templates.
- 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.
...
This document references the following documents:
Name | Location | Description |
---|---|---|
Universal Templates |
User documentation for creating Universal Templates in the Universal Controller user interface. | |
Universal Tasks |
User documentation for creating Universal Tasks in the Universal Controller user interface. |