Set parameters

Update a tool's configuration with values from interface questions when run as app or macro

Define a JSON schema for structured output from the Prompt tool

Choose and configure the LLM provider connection the workflow's AI tools use

Store a statement with placeholder arguments for repeated execution

List the session configuration options

Add system values such as dates, host name, pipeline name and run ids as fields

Put variable values into fields of new or existing rows

Read the metadata objects defined in the current project as rows

List the installed transforms, actions and metadata types from the plugin registry

Set variables from the fields of a row, at a chosen scope

Switch the process-wide two-way password encoder from inside a workflow

Set variables at a chosen scope, from values or a properties file

66 services: connection pools, credentials, SSL contexts, OAuth2, Kerberos, caches, proxies, file resources

8 components that fetch parameters from secret stores, databases, environment variables and files

Select a record sink service at run time from an attribute

11 services that supply record schemas: Avro, JSON, Confluent, Apicurio, AWS Glue, database table

Options shared by all transforms: name the input dataset and the output dataset of a step

Apply any transform per table of a multi-table stream, matched by table name pattern

Add a value to an existing array variable

Return key-value pairs from a child pipeline to the pipeline that called it

Set the value of an existing variable

Run-window and run-context values injected into the Jinja context, such as start_date

User-defined pipeline variables available to templates

13 Jinja filters on template dates: add_years, add_months, add_days, truncate_month, date_format, …

Shift the start or end of the processing window to catch late or early data

Run a SQL query at compile time and return its result columns as a dictionary

Run a SQL query at compile time and return its single value, with a default

Store credentials for a remote service, scoped to a path

Install and load an extension

Compile a statement with parameters and run it with values

Parameters in a query, positional or named

Change or restore a configuration option

Hold a value in a named variable for later statements

Choose the default database and schema

The functions documented on the Utility Functions page

duckdb_extensions table function

duckdb_functions table function

duckdb_keywords table function

duckdb_optimizers table function

duckdb_prepared_statements table function

duckdb_secret_types table function

duckdb_secrets table function

duckdb_settings table function

duckdb_variables table function

icu_calendar_names table function

pg_timezone_names table function

pragma_collations table function

pragma_platform table function

pragma_user_agent table function

pragma_version table function

which_secret table function

compute a value by SQL during the run and expose it as a run variable

Emit one row with each project parameter's value as a column

List an EasyMorph project's connectors, parameters, modules, tables and actions as a table

Remember, recall, list, forget or increment values in a shared key-value store

Emit one row of runtime facts: Windows account, free RAM, machine name, UTC offset, run ID

List the files supplied through the workflow's file-upload parameters

Named, typed placeholder for a lambda or deferred-function argument

Typed placeholder whose value is supplied when the query is executed

Component-dialog checkbox; outputs a boolean or integer flow variable

Component-dialog column picker; outputs the table reduced to the chosen columns

Component-dialog single-column picker; outputs the column name as a flow variable

Build file and folder paths and expose them as flow variables

Component-dialog user name and password entry; outputs a credentials flow variable

Read non-confidential parts of credentials variables, such as user name

Component-dialog date&time picker; outputs the value as a string flow variable

Component-dialog decimal number entry; outputs a double flow variable

Read workflow context properties such as workflow name, path and logged-in user

Read system properties such as current user name and working directory

Split the flow variables off a data connection

Split the flow variables off a database connection

Authenticate to selected Google services for downstream connector nodes

Merge flow variables into a data connection, passing the data through

Merge flow variables into a database connection, passing it through

Component-dialog whole number entry; outputs a flow variable

Component-dialog slider; outputs an integer flow variable

Extension outside the base install: 1 current node: Google Workload Identity Federation

Authenticate against a KNIME Hub for downstream connector nodes

Component-dialog text area; outputs a one-column table holding the entered list

Component-dialog local file picker; outputs the chosen path as a flow variable

Evaluate a mathematical formula over flow variables into a new or replaced variable

Merge the flow variables of several connections into one

Authenticate to Microsoft Azure and Office 365 services for downstream connector nodes

Component-dialog multi-select over a list of strings; outputs the chosen values

Component-dialog value picker; outputs rows having the chosen values of a column

Obtain an OAuth 2 token by authorisation-code flow for downstream nodes

Obtain an OAuth 2 token by client-credentials flow for downstream nodes

Obtain an OAuth 2 token by resource-owner password flow for downstream nodes

Convert path flow variables to string flow variables

Component-dialog chooser for files, workflows or folders on a remote mountpoint

Set a flow variable from ordered first-match rules over flow variables

Set a flow variable from first-match rules supplied in a table

Component-dialog single-select over a list of strings; outputs the chosen value

Component-dialog text entry; outputs a string flow variable

Evaluate a string-function expression over flow variables

Convert string flow variables to path flow variables

Turn a column's values into flow variables named by RowID

Turn the first row's values into flow variables named by column

Component-dialog single-select over a column's domain values; outputs the chosen value

Define flow variables for use in the workflow

Evaluate custom expressions to create or update flow variables

Keep or drop flow variables by name

Build a credentials variable from flow variables

Append flow variable values as new columns of a table

Write flow variables into a single-row table

Log in with the Wikidata account that uploads will be made under

Choose which Wikibase the project edits, adding others by manifest URL or JSON

Read the value of a Pentaho Server session variable

Add system values such as the system date and arguments as fields

Put the values of environment or Kettle variables into fields

List the transformations and jobs stored in a repository with their details

Set the value of a Pentaho Server session variable

Set environment variables from a single input row

4 classes: CredentialProvider base and one each for AWS, Azure and GCP

3 functions: register_extension_type, unregister_extension_type, get_extension_type

3 classes: PartitionBy, FileProviderArgs, ScanCastOptions; partitioned output files and casts applied on scan

4 entries: StringCache, enable_string_cache, disable_string_cache, using_string_cache; documented as doing nothing

Set the global random seed

4 functions: Identity.From, Identity.IsMemberOf, IdentityProvider.Default, AccessControlEntry.ConditionToIdentities

Custom-operator parameter chosen from a table's columns, exposed as a macro

Custom-operator checkbox parameter, exposed as a true/false macro

Custom-operator dropdown parameter with fixed categories, exposed as a macro

Clear the cookies held for HTTP connections

Copy parameter values from one operator's parameters to another's

Add objects to a named collection that persists across executions in the session store

Custom-operator date-time parameter, exposed as a macro

Custom-operator directory-chooser parameter, exposed as a macro

Custom-operator decimal-number parameter, exposed as a macro

Set a macro to the name of the operator that last modified an object

Set a macro from a table: a cell value, a statistic, row count or column count

Set a macro from a table value with date or number formatting, or from a collection's size

Set macros from the values of an object's annotations

Custom-operator file-chooser parameter, exposed as a macro

Compute new macros from expressions over existing macros

Obtain a JSON Web Token from an AI Hub server for authenticated calls

Read all parameter values of another operator into a table

Obtain a bearer token for connecting to Altair IoT Studio

Custom-operator integer parameter, exposed as a macro

Custom-operator dropdown whose suggestions come from a process, exposed as a macro

Store an object in the AI Hub app or Studio session for later recall

Read the key-value pairs of a Dictionary connection (such as API keys) into a one-row table

Fetch an object from the process object store by name

Fetch an object stored in the AI Hub app or Studio session

Store an object in the process object store under a name

Custom-operator repository-location parameter, exposed as a macro

Define one macro with a given value

Define a macro through a numeric parameter so that optimise operators can vary it

Define several macros with given values

Set macros from the rows of a name-value table

Apply a parameter set, such as an optimised one, to named operators

Set operator parameter values from the rows of a table

Custom-operator free-text parameter, exposed as a macro

Remove macros from the process context

Read a blueprint variable defined in the MODEL statement, with an optional default

Define a local macro variable, or an inline macro function with arguments, inside a model

Evaluate a SQL expression at render time with SQLGlot's executor and emit the result

Render a template from the catalog, schema and table parts of the physical table name

Read a global or gateway variable from project config by name, with an optional default

Name of the current gateway

Name of the current model kind, for model defaults

Current runtime stage: loading, creating, evaluating, promoting, demoting, auditing, testing

Physical table name the model view selects from; used in generic audits

27 variables: start, end, execution x dt, dtntz, date, ds, ts, tstz, hour, epoch, millis

Setting that overrides the ef_search candidate count when scanning HNSW indexes

Setting that allows HNSW indexes in a database stored on disk; off by default

User and system parameters substituted into inputs, outputs, filters and calculations

8 components opening a connection to a business application: tSalesforceConnection, tSAPConnection, tMarketoConnection

106 components opening, closing or configuring a connection: tMysqlConnection, tOracleClose, tHiveConfiguration

23 components opening, closing or configuring a connection: tS3Connection, tFTPConnection, tHDFSConfiguration, tGSClose

9 components opening, closing or configuring a connection: tKafkaConnection, tRabbitMQConnection, tMessagingClose

Load an OpenAPI contract as the source definition of a contract-first data service

Emit the context variables of the current Job as rows, for a file, a table or tContextLoad

Set the values of the active context from an incoming flow, warning on undefined parameters

Fetch secrets at run time from a CyberArk vault through the Central Credential Provider web service

Fetch the content of a secret from a CyberArk vault at run time into a Job variable

Load Java libraries for use in the Job

Close a named pipe that tNamedPipeOpen opened

Open a named pipe for writing data into it

Add variables to the system environment for the duration of the Job

Define and set global variables

Set the Kerberos authentication details for the Job

Set truststore and keystore data, PKCS 12 or JKS, for SSL connections

Set the proxy details for the Job

Define a reusable connection to a Tachyon storage system for a Spark Job

Edit the option in current Options Sheet row

Store current cell value under a name in the Memory Sheet

Open the config file as a text sheet

Open Memory Sheet of named stored values usable in expressions

Open Options Sheet to edit global options

Open Options Sheet to edit options for current sheet

Remove the option override in current Options Sheet row

Save as Options Sheet as a .visidatarc config file

Enum of link functions applied to a custom loss's raw output

Set a filename prefix so several models can share one directory

Constrain a numerical feature so predictions only rise or only fall with it

Protobuf holding label, features, task, learner key, seed and hyperparameters

Pin the model to one named inference engine

Return named preset hyperparameter sets, such as better_defaultv1, to apply to a learner

Read or edit the learner's hyperparameters as a dictionary

List the inference engines able to run this model on this machine

Switch predictions between probabilities and raw logits