bit.io - Store Query Results as CSV

Overview

Turn the results of your SQL SELECT statement into a CSV file. Extract your bit.io data into files for easier delivery to clients and partners.

Variables

Name	Reference	Type	Required	Default	Options	Description
API Key	BITIO_API_KEY	Password	✅	-	-	API Key associated to your bit.io account. For more information, see the Authorization documentation.
Query	BITIO_QUERY	Alphanumeric	✅	-	-	A SELECT statement that returns data. Formatting is ignored.
Folder Name	BITIO_DESTINATION_FOLDER_NAME	Alphanumeric	➖	-	-	The folder structure that you want your CSV to be created in. If left blank, the file will be created in the home directory.
File Name	BITIO_DESTINATION_FILE_NAME	Alphanumeric	✅	output.csv	-	The file name that you want your generated CSV to have.
Include Column Names as Header?	BITIO_FILE_HEADER	Boolean	✅	true	-	If checked, your CSV file will include a header row with column names.