EA Connect - Snowflake Execute SQL Task Documentation
This documentation provides an overview of the Snowflake Execute SQL Task feature in EA Connect. The Snowflake Execute SQL Task allows users to execute SQL queries on a Snowflake database within EA Connect.
¶ Prerequisite: Snowflake Connection
Before using the Snowflake Execute SQL Task in EA Connect, ensure that you have established a connection to your Snowflake database.
¶ Creating a Snowflake Execute SQL Task
To create a Snowflake Execute SQL Task, follow these steps:
- Open the EA Connect web application in your web browser.
- Log in to your EA Connect account using your credentials.
- Navigate to the "Build" menu.
- Select the "Tasks" submenu.
- Choose the "Snowflake Execute SQL" option.
- In the Tasks section of EA Connect, click on the "Create New" button.
- Provide a suitable name for the task to identify it in the future.
- Select the "Snowflake Execute SQL" task type from the available options.
9.Provide the SQL query you want to execute in the provided field.
10.Specify the output file name for the data retrieved from the SQL query.
11.Enter the Snowflake schema name.
12.Enter the Snowflake database name.
13.Enter the Snowflake warehouse name.
14.Save the task configuration.
¶ Conclusion
The Snowflake Execute SQL Task feature in EA Connect allows users to execute SQL queries on a Snowflake database and retrieve data for further processing. By providing the SQL query, output file name, and the required Snowflake connection parameters, users can seamlessly integrate Snowflake data into their workflows and data transformation processes.