Snowflake - Export query result action

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

Export query result action

Input

Input field	Description
SQL	Enter a valid SQL query. For example, SELECT * FROM PUBLIC.ACCOUNTS.
Column delimiter	Choose a delimiter character. CSV files typically use comma.
Timeout limit	Specify an upper limit for the action. If any asynchronous jobs exceed this limit, the recipe proceeds to the next step. The maximum timeout limit is 120 minutes.

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 content	CSV stream of the contents of the file.

REFRESH SCHEMA TO DISPLAY FILE CONTENTS DATAPILL

If the File content datapill doesn't appear in the output datatree of this action, click Refresh to regenerate the output fields.

Click Refresh to regenerate the output fields