The SQL block enables you to create a dataset using the SQL language SELECT statements in a Workflow.
The following demonstrates now to use the SQL block to select the variables Title and In_Stock from the input dataset lib_books.csv (which contains observations that describe a range of books available from a lending library) and output them to a new dataset.
SELECT Title, In_Stock FROM "Working Dataset";
A green execution status is displayed in the Output ports of the SQL block and the new Working Dataset. The dataset contains the title of all books in the library collection and whether those books are available for loan.