> For the complete documentation index, see [llms.txt](https://docs.frends.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.frends.com/tasks/tasks/snowflake/executequery.md). # ExecuteQuery Task version: 2.0.0 Required Frends version: 5.5+ Required .NET version: 6.0 Compatible Agents: Crossplatform Source code: ## Task Parameters {% tabs %} {% tab title="Input" %} | Name | Description | | --------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 🗝ConnectionString : `String` |

String that contains the necessary data to connect to the database.


Default: -
Example: account=testaccount-123;user=user;role=ACCOUNTADMIN;db=SHOP;schema=PUBLIC; authenticator=SNOWFLAKE\_JWT;private\_key\_file=C:/snow/rsa\_key.p8;private\_key\_pwd=MyStrongPassphrase

| | CommandType : `CommandTypes` |

Specifies how a command string is interpreted.

ExecuteNonQuery: Executes an SQL statement, and returns the number of rows affected.

ExecuteReader: Executes the query, and returns an object that can iterate over the entire result set.

ExecuteScalar: Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

Possible values:

ExecuteNonQuery: Executes an SQL statement, and returns the number of rows affected.

ExecuteReader: Executes the query, and returns an object that can iterate over the entire result set.

ExecuteScalar: Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

ExecuteNonQuery: Executes an SQL statement, and returns the number of rows affected.

ExecuteReader: Executes the query, and returns an object that can iterate over the entire result set.

ExecuteScalar: Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

ExecuteNonQuery: Executes an SQL statement, and returns the number of rows affected.

ExecuteReader: Executes the query, and returns an object that can iterate over the entire result set.

ExecuteScalar: Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.


Default: -
Example: -

| | CommandText : `String` |

text command to run against the data source.


Default: -
Example: SELECT \* FROM mytable

| | PrivateKeyFilePath : `String` |

Full file path to the private key (.p8) used for Snowflake key pair authentication.


Default: -
Example: C:\keys\rsa\_key.p8

| | 🗝PrivateKeyPassphrase : `String` |

Optional passphrase for the private key file, if the key was generated with encryption.

Leave empty if the key file is unencrypted.


Default: -
Example: MySuperSecret123

| | {% endtab %} | | {% tab title="Options" %} | Name | Description | | --------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | ThrowExceptionOnError : `Boolean` |

Gets or sets a value indicating whether an error should stop the Task and throw an exception.

If set to true, an exception will be thrown when an error occurs. If set to false, Task will try to continue and the error message will be added into Result.ErrorMessage and Result.Success will be set to false.


Default: True
Example: true

| | TimeOut : `Int32` |

Gets or sets the wait time (in seconds) before terminating the attempt to execute a command and generating an error.


Default: 30
Example: 30

| | {% endtab %} | | | {% endtabs %} | | ## Task Result | Name | Description | | ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Success : `Boolean` |

Gets a value indicating whether the Task was executed successfully.
Example: true

| | RecordsAffected : `Int32` |

Records affected. Some statements will return -1.
Example: 100

| | ErrorMessage : `Object` |

Error message. This value is generated when an exception occurs and Options.ThrowErrorOnFailure = false.
Example: Table 'NOTABLE' does not exist or not authorized...

| | Data : `Object` |

Procedure's result as JToken.
Example: Examples using SELECT query Input.ExecuteType = ExecuteReader: \[{"NAME": "Jane","AGE": 94},{"NAME": "Eve","AGE": 53}], Input.ExecuteType = NonQuery: null, Input.ExecuteType = Scalar: {"Value": "Jane"}

| ## Task Changelog Changelog for Task Frends.Snowflake.ExecuteQuery. ### \[2.0.0] - 2025-09-03 #### Changed * \[Breaking] Result now returns a dynamic JToken instead of DataTable when using ExecuteReader mode. * Added support for CancellationToken, thus enabling query cancellation. ### \[1.2.0] - 2025-09-03 #### Added * Added support for Snowflake key pair authentication: Input.PrivateKeyFilePath: full path to the .p8 private key file. Input.PrivateKeyPassphrase: optional passphrase for encrypted private keys. ### \[1.1.0] - 2025-02-12 #### Changed * Update: Snowflake.Data 2.1.5 -> 4.3.0 MSTest.TestAdapter 3.8.0 -> 3.8.3 MSTest.TestFramework 3.8.0 -> 3.8.3 ### \[1.0.0] - 2024-01-08 #### Added * Initial implementation --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.frends.com/tasks/tasks/snowflake/executequery.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.