Previous Topic

Next Topic

Book Contents

Book Index

Running a Snowflake Stored Procedure

Return Values

Snowflake procedures do not have OUT or INOUT parameters. Instead, the result is returned as either a single value or as a table. In both cases, the result is shown in the data grid.

Procedure Parameters need to be specified twice

Due to a problem with the Snowflake ODBC Driver, AQT needs to specify parameter values twice. You will notice this when you use Copy to SQL window and see the SQL that AQT uses for running the procedure.

This problem may be corrected in later versions of the Snowflake ODBC Driver.

Advanced Query Tool
https://www.querytool.com
© 2024 Cardett Associates Ltd. All rights reserved.