Expressions in Connection Properties

Some connection properties allow you to specify an expression using the StreamSets expression language.

For example, to configure the Password property in a connection, you might use the credential:get function to retrieve the password from a credential store.

Use expression completion in a connection property to view a list of functions and other elements of the StreamSets expression language that are valid for use at that location. Expression completion in connection properties works the same as it does in pipeline properties.

To invoke expression completion, place the cursor within the curly brackets of the expression, ${ }, then begin typing. You can filter the element list by typing a few letters of the element name. The list displays element names that include your full input at the top, followed by element names that include individual letters.

To use an expression in a credential property, click Show Value before invoking expression completion.

When you configure connections, expression completion displays the list of valid functions for the selected authoring Data Collector. Be sure to use functions that are valid for the execution engine.

Credential functions are available for all execution engines. Most Data Collector functions are available in Transformer, and a smaller number are available in Transformer for Snowflake. However, some functions, such as the list functions, are only available in Data Collector.

For more information about using the StreamSets expression language in connections, see the Data Collector, Transformer, or Transformer for Snowflake documentation.