Execute Stored Procedure In Snowflake

This node executes Stored Procedure in Snowflake

Output

Pass the return data from SP to in next node and pass the input dataframe to next node.

Type

shellcommand

Class

fire.nodes.snowflake.NodeExecuteStoredProcedureInSnowFlake

Fields

Name	Title	Description
authType	Auth Type	Authentication Type. Possible value is OAUTH or USER_CREDENTIAL or KEYPAIR
connection	Connection	The Snowflake connection to connect
sfWarehouse	Snowflake Warehouse	Warehouse for connecting to the Snowflake
sfDatabase	Snowflake Database	Database for connecting to the Snowflake
sfSchema	Snowflake Schema	Schema for connecting to the Snowflake
extraOptionsKeys	JDBC Properties Name	Extra JDBC Properties Name.
extraOptionsValues	JDBC Properties Value	Extra JDBC Properties Value
storedProcedureInputConfiguration	StoredProcedureInputConfiguration
storedProcedureStmt	Stored Procedure Stmt	example: call return_value_proc(?)
parameterType	SP Parameter Type	Stored Procedure input parameter Type: string, integer, double, float, boolean and datetime.
parameterValue	SP Parameter Value	Stored Procedure input parameter values.
storedProcedureOutputConfiguration	StoredProcedureOutputConfiguration
returnValueName	SP Return Value Name	Stored Procedure ouput Return Value Name.
returnValueType	SP Return Type	Stored Procedure ouput Return Value Type: string, integer, double, float, boolean and datetime..

Examples

Execute Query In Snowflake Node Examples

Example of Connection Values

• CONNECTION : SNOWFLAKE_DEV_ENV_NCUS

• SNOWFLAKE WAREHOUSE : SNOWFLAKE_BI_VWH

• SNOWFLAKE DATABASE : CUSTOMER_SALES_NCUS

• SNOWFLAKE SCHEMA : INT_NA_CUSTSALES

• Stored Procedure Stmt :call return_value_proc(?)