01 Deploy Data by Exporting Data Files

Write data to Google Sheets

Step 1: Drag the "Google Sheets Connector" node into the workflow and connect it with the output port of the "Google Authenticator" node.

Step 2: Execute the node to establish the connection with the Google Sheets associated with the user's account.

Step 3: Connect the "Google Sheet Writer" node to output port of the "Google Sheets Connector" node. Connect the data table to be written to the data input port.

Step 4: Double Click on the node to open the dialog box. Specify the "Spreadsheet" and "Sheet" name and set other "Write Settings". Click "Apply and Execute" to write the data to Google Sheet.

Writing data to your local system

To write data to your local system follow these steps:

Step 1: Drag the ''CSV Writer'' node into the workflow. Click on the node to open the configuration window.

Step 2: Specify the path where the file should be saved. Click the yellow folder button to browse your files. Select "Local file system" to write to your local system.

Step 3: Decide what should happen if the file already exists (e.g., overwrite the existing file, append, or fail).

Step 4: Execute the node to export the data as CSV file.

Writing data to a workflow data area using relative paths

To write data to a workflow data area follow these steps:

Step 1: Drag the ''Table Writer'' node into the workflow. Click on the node to open the configuration window.

Step 2: Specify the path where the file should be saved. Click the yellow folder button to browse your files. Select "Embedded data" to write to the workflow data area.

Step 3: Decide what should happen if the file already exists (e.g., overwrite the existing file, append, or fail).

Step 4: Execute the node to export the data as KNIME table file.

Deploy Data: Export Data Files from KNIME

This workflow demonstrates how data can be exported from a KNIME workflow to various file types (e.g., .csv, .table (KNIME's native format), Google Sheet.) and file systems (e.g., local system, workflow data area, remote file systems like Google Cloud).

In this example, we export data to:

• A .csv file saved in your local system. Note that this option requires you to specify the file path in the CSV Writer node to make it work on your local system.

• A .table file (KNIME's native file type) saved in the workflow data area using relative paths.

• A Google Sheet. Note that this option requires you to authenticate to your Google account.

Workflow complete!

Keep the momentum going by exploring Just KNIME It! on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.

Authenticate your Google account via login

Step 1: Drag the "Google Authenticator" node into the workflow.

Step 2: Click on the node to open the configuration window. Specify the "Scopes of access" to determine the level of permission you give (e.g., read-only or full access). Add scopes if needed.

Step 3: Under "Authentication", click on "Login". A browser tab will open which lets you sign in to your Google account. Execute the node to finish the authentication.