# JDBC - Export query result

# Export query result

This action exports the data from a valid SQL query to a specific file.

On-prem profile configuration

Remember to configure a staging area in your on-prem agent profile. Learn how to setup a staging area in the OPA server profile.

Export query result Export query result

# Input fields

# SQL

First, you must enter into the field a table to export from. If you are having trouble finding a table, you can change the action to select rows and find a value from the table section there. After a valid table is entered, it should be limited by something such as select so it can be exported to a file.

# Column delimiter

For the column delimiter, you can choose between several options to seperate the table. CSV files typically use comma.

# Upload URL

This is the CSV file that the result of the query is going to be exported to. You can generate this url using On-prem files or Amazon S3.

# Example Recipe

If you are having trouble figuring out how to do this, view this example recipe. (opens new window)