KNIME

https://docs.knime.com
Admin
KNIME is an open-source data analytics, reporting, and integration platform that enables users to...
Tokens:69,416
Snippets:1,056
Trust Score:10
Update:4 months ago
Show doc for...
Tokens:
Raw
### Example JDBC URL Template

Source: https://docs.knime.com/ap/latest/db_extension_guide

An example of a JDBC URL template for an Oracle driver, demonstrating the required escaping of colons and backslashes.

```text
jdbc\:oracle\:thin\:@<host>\:<port>/<database>
```

--------------------------------

### Register Multiple JDBC Drivers (Windows Example)

Source: https://docs.knime.com/ap/latest/db_extension_guide

Example of registering multiple JDBC drivers on Windows for the deprecated database framework. Note the escaping of backslashes in Windows paths.

```text
!\/=
/instance/org.knime.workbench.core/database_drivers=C\:\\KNIME\\JDBC\\db2\\db2jcc4.jar;C\:\\KNIME\\JDBC\\Neo4J\\neo4j-jdbc-driver-3.4.0.jar
file_export_version=3.0
```

--------------------------------

### Row-wise Function Examples

Source: https://docs.knime.com/ap/latest/knime_expressions_guide

Provides examples of common row-wise functions, including mathematical operations and conditional logic. Demonstrates function nesting and argument separation.

```KNIME Expressions
sqrt(4)
```

```KNIME Expressions
pow(abs(-sqrt(3.14**2)),2)
```

```KNIME Expressions
if(TRUE, "true branch","false branch")
```

--------------------------------

### Agent Prompter User Message Example

Source: https://docs.knime.com/ap/latest/ai/tutorials/restaurant-agent

Optionally, configure a user message in the Agent Prompter node for initial testing. This example simulates a user request for booking a table.

```text
Can you book a table for two people for tomorrow evening?
```

--------------------------------

### Install KNIME Tableau Extensions

Source: https://docs.knime.com/ap/latest/tableau_integration_user_guide

Install legacy Tableau extensions from the KNIME Extensions. Search for 'Tableau' and deselect 'Group items by category' to view available extensions.

```text
File -> Install KNIME Extensions -> Search for "Tableau" -> Deselect "Group items by category"
```

--------------------------------

### Make Script Executable on macOS

Source: https://docs.knime.com/ap/latest/r_installation_guide

Use this command in the Terminal to make the KNIME R integration setup script executable on macOS.

```bash
chmod u+x <name_of_the_script>.sh
```

--------------------------------

### Install Latest Rserve from Source on Windows

Source: https://docs.knime.com/ap/latest/r_installation_guide

This command installs the latest version of Rserve from the Rforge repository as a source package. Ensure Rtools and necessary paths are configured.

```r
install.packages('Rserve',,"http://rforge.net/",type="source")
```

--------------------------------

### Install driverlessai Python Module

Source: https://docs.knime.com/ap/latest/h2o_driverless_ai_guide

Install the `driverlessai` Python module using pip. Ensure your KNIME Python environment has this package.

```bash
pip install driverlessai
```

--------------------------------

### Install Rserve Package on Windows

Source: https://docs.knime.com/ap/latest/r_installation_guide

Use this command within R to install the Rserve package. If the library folder is not writable, you will be prompted to use a personal library.

```r
install.packages('Rserve')
```

--------------------------------

### Find R Home Directory

Source: https://docs.knime.com/ap/latest/r_installation_guide

Use this command within R to determine the installation path, which is required for KNIME configuration.

```R
R.home()
```

--------------------------------

### FLOAT Literal Examples

Source: https://docs.knime.com/ap/latest/knime_expressions_guide

Demonstrates various ways to write FLOAT literals, including decimal points, underscores for readability, and scientific notation.

```KNIME Expressions
0.123
```

```KNIME Expressions
.123
```

```KNIME Expressions
123.
```

```KNIME Expressions
1_000.567_890
```

```KNIME Expressions
1.23e4
```

```KNIME Expressions
1.23E+4
```

--------------------------------

### Example cURL Command for REST API Invocation

Source: https://docs.knime.com/ap/latest/analytics_platform_workflow_invocation_guide

This example demonstrates the cURL command structure for invoking a REST endpoint of a KNIME workflow. Ensure the correct endpoint URL and any necessary authentication are provided.

```bash
curl -X POST \
  http://localhost:8080/knime/rest/v1/workflows/my_workflow \
  -H "Content-Type: application/json" \
  -d @input.json
```

--------------------------------

### Operator Precedence Examples

Source: https://docs.knime.com/ap/latest/knime_expressions_guide

Demonstrates the order of operations in KNIME expressions, including the use of parentheses to enforce evaluation order. Covers arithmetic, exponentiation, and logical operators.

```KNIME Expressions
1 + 2 * 3
```

```KNIME Expressions
1 + (2 * 3)
```

```KNIME Expressions
1 + 2 ** 3 * 4
```

```KNIME Expressions
1 + ((2 ** 3) * 4)
```

```KNIME Expressions
2 * 2 ** 3 ** 2
```

```KNIME Expressions
2 * (2 ** (3 ** 2))
```

```KNIME Expressions
TRUE or FALSE and FALSE
```

```KNIME Expressions
TRUE or (FALSE and FALSE)
```

--------------------------------

### Example Relative Path for Data Folder

Source: https://docs.knime.com/ap/latest/analytics_platform_file_handling_guide

Illustrates how to specify a relative path to a data folder within a KNIME workflow. This path is relative to the workflow's location.

```text
<knime-workspace>/workflow_group/my_workflow/data/
```

--------------------------------

### KNIME Python Integration Default Options (Bundled)

Source: https://docs.knime.com/ap/latest/python_installation_guide

Configures KNIME to use the bundled Python environment by default. This is the simplest setup and requires no external Conda installation.

```properties
/instance/org.knime.python3.scripting.nodes/pythonEnvironmentType=bundled
/instance/org.knime.python3.scripting.nodes/bundledCondaEnvPath=org_knime_pythonscripting
```

--------------------------------

### Accessing Input and Output Tables

Source: https://docs.knime.com/ap/latest/python_installation_guide

Demonstrates how to access input and output tables using their respective indices from the `knio` module.

```python
knio.input_tables[i]
knio.output_tables[i]
```

--------------------------------

### Install libssl-dev on Linux Ubuntu

Source: https://docs.knime.com/ap/latest/r_installation_guide

If the Rserve installation fails with an ld error on Linux Ubuntu, use this command to install the necessary OpenSSL development libraries.

```bash
sudo apt install libssl-dev
```

--------------------------------

### Install Xcode Command Line Tools on macOS

Source: https://docs.knime.com/ap/latest/r_installation_guide

If you encounter errors during Rserve installation on macOS versions older than 10.14, run this command in the Terminal to install Xcode command-line tools.

```bash
xcode-select --install
```

--------------------------------

### Install Cairo Package on macOS

Source: https://docs.knime.com/ap/latest/r_installation_guide

Use this command within R on macOS to install the Cairo graphics package.

```r
install.packages('Cairo')
```

--------------------------------

### Install Keras GPU Version Packages

Source: https://docs.knime.com/ap/latest/deep_learning_installation_guide

Installs required packages for the GPU version of Keras within a specified conda environment.

```bash
conda install --name <your_env_name> h5py=2.8 tensorflow=1.12 keras-gpu=2.2.4
```

--------------------------------

### Install Keras CPU Version Packages

Source: https://docs.knime.com/ap/latest/deep_learning_installation_guide

Installs required packages for the CPU version of Keras within a specified conda environment.

```bash
conda install --name <your_env_name> h5py=2.8 tensorflow-mkl=1.12 keras=2.2.4
```

--------------------------------

### Initialize Batch Output Table

Source: https://docs.knime.com/ap/latest/python_installation_guide

Create an instance of BatchOutputTable to store processed batches. This is the first step in setting up batch processing.

```python
processed_table = knio.BatchOutputTable.create()
```

--------------------------------

### Install ONNX Python Package using pip

Source: https://docs.knime.com/ap/latest/deep_learning_installation_guide

Use this command to install the ONNX Python package and its dependencies into an existing conda environment.

```bash
pip install onnx==1.4.1
```

--------------------------------

### Minimal krb5.conf Configuration

Source: https://docs.knime.com/ap/latest/analytics_platform_kerberos_user_guide

A basic Kerberos client configuration file example. Adjust the realm and KDC details to match your specific environment. This file is essential for configuring KNIME Analytics Platform to use Kerberos authentication.

```ini
[libdefaults]
default_realm = MYCOMPANY.COM

[realms]
MYCOMPANY.COM = {
  kdc = kdc.mycompany.com
  admin_server = kdc.mycompany.com
}
```

--------------------------------

### Executor Configuration for Conda Directory

Source: https://docs.knime.com/ap/latest/python_installation_guide

Specify the path to your Conda or Miniforge installation directory for the KNIME Executor. This is typically only needed if Conda is installed in a non-default location.

```properties
/instance/org.knime.conda/condaDirectoryPath=<path to conda installation dir>
```

--------------------------------

### Create Job for File Download via REST API

Source: https://docs.knime.com/ap/latest/analytics_platform_workflow_invocation_guide

Initiate a job on KNIME Server to prepare for downloading an output file. This is the first step in a multi-step process for downloading files from a workflow.

```bash
curl --location --request POST '{{baseUrl}}/rest/v4/repository/{{path}}:jobs'
```

--------------------------------

### Organize Tool Workflows

Source: https://docs.knime.com/ap/latest/ai/tutorials/restaurant-agent

Illustrates the directory structure for organizing KNIME tool workflows. This includes placing individual workflow files (.knwf) into a dedicated 'tools' folder.

```text
tools/
																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																														

```

--------------------------------

### Configure Ollama Connection in KNIME

Source: https://docs.knime.com/ap/latest/ai/tutorials/first-local-agent

Set up the connection to your local Ollama server within the KNIME workflow. Ensure the URL is correct and select the desired LLM model for agent interactions.

```python
http://localhost:11434/v1
```

--------------------------------

### Install nomkl on macOS for LSTM Layer Issues

Source: https://docs.knime.com/ap/latest/deep_learning_installation_guide

On macOS, networks with LSTM layers may fail due to MKL library issues. Install the 'nomkl' package to resolve this.

```bash
conda install nomkl
```

--------------------------------

### Increase Deep Learning Installation Test Timeout

Source: https://docs.knime.com/ap/latest/deep_learning_installation_guide

If the Python back end installation test times out, increase the timeout value by setting the VM option in the knime.ini file.

```ini
-Dknime.dl.installationtesttimeout=<value-in-ms>
```

--------------------------------

### Build Prompt with KNIME Expression Node

Source: https://docs.knime.com/ap/latest/ai/tutorials/summarize-product-reviews

Dynamically creates a prompt for each review using KNIME Expression Language. Combines fixed instructions with review text from a table column.

```text
string(
  "You are a product quality expert.\n" +
  "Summarize the following review in 10 to 15 words:\n\n" +
  $["Review"]$
)
```

--------------------------------

### Register JDBC Drivers for Deprecated Framework

Source: https://docs.knime.com/ap/latest/db_extension_guide

Create a text file to register JDBC drivers for the deprecated database framework. Replace `<PATH_TO_THE_JDBC_DRIVER>` with the actual path to your driver JAR file. Multiple drivers can be registered by separating paths with a semicolon.

```text
!\/=
/instance/org.knime.workbench.core/database_drivers=<PATH_TO_THE_JDBC_DRIVER>
file_export_version=3.0
```

--------------------------------

### Snowflake OAuth Resource Scope Example

Source: https://docs.knime.com/ap/latest/snowflake_extension_guide

This is an example of the scope URL required for Microsoft Entra ID authentication with Snowflake. Ensure you replace placeholders with your specific Azure ID and resource details.

```text
https://<YOUR_AZURE_ID>.onmicrosoft.com/6ea360a8-3f57-407f-xxxxx-xxxxxxxxxxxx/session:role-any
```

--------------------------------

### KNIME Python Integration Manual Environment Configuration

Source: https://docs.knime.com/ap/latest/python_installation_guide

Specifies the direct paths to Python 2 and Python 3 executables when using a manual environment setup. This is required if 'pythonEnvironmentType' is set to 'manual'.

```properties
/instance/org.knime.python3.scripting.nodes/python2Path=<path to python2 env>
/instance/org.knime.python3.scripting.nodes/python3Path=<path to python3 env>
```
Tokens:
Raw