Snowflake - Export query result action

Export query result

This bulk long action executes a SQL query and exports the results as a CSV file. You can stream the exported CSV content via the File Contents datapill. The maximum timeout for this action is 120 minutes.

Export query result action

Input

Input field	Description
SQL	A valid SQL query. for example, SELECT * FROM PUBLIC.ACCOUNTS
Column delimiter	Choose a delimiter character. CSV files typically use comma.

Output

The output of this action contains metadata about the export action.

Output field	Description
Number of rows exported	The number of rows exported.
Column names	Column headers in the CSV file.
File Contents	CSV stream of the contents of the file.