These parameter values will be reset to the defaults. Are you sure?

Analytics Database

VAL

Function Name

Description

Error: To use this VAL function, specify first a database name for the VAL_DATABASE custom property in your connection settings. Warning: To avoid errors, you must either (a) specify a default database in your connection, or (b) specify schema(s) in the input Dataset(s) settings.

Drop Output Table/s

Check if Output Tables already exists.

Distribution Key

{{config.function.function_alias_name}}'s arguments

Name

Value

Unaliased Input Tables

UAF Type Details

Instance Names Data Type

Row Column ID

Payload

Start Value

Offset Value

Number Entries

Layer Interval Zero WHERE

Data Partition Option

Partition by

Hash by

Column {{$index+1}} Column {{$index+1}}

Order by

Column {{$index+1}}

ORDER BY Column

Column {{$index+1}}

PARTITION BY ANY

PARTITION BY Column

PARTITION BY column {{$index+1}}

This same table name must be entered into the Input / Output tab above as an Output.

{{config.function.partnerFunction.function_alias_name}}'s arguments

Name	Value
Unaliased Input Tables
{{ cleanName(item.name) }} {{ cleanKind(item.kind) }}	{{config.function.function_alias_name}}'s output Partition Type Partition by PARTITION BY column {{$index+1}} Order by ORDER BY column {{$index+1}} ORDER BY column {{$index+1}}
ORDER BY Column	ORDER BY column {{$index+1}}
PARTITION BY ANY
PARTITION BY Column	PARTITION BY column {{$index+1}}
{{ getArgumentFormattedName(item.name) }}	This same table name must be entered into the Input / Output tab above as an Output.
{{ getArgumentFormattedName(item.name) }}

{{config.function.function_alias_name}}'s arguments

Name	Value
{{ cleanName(item.name) }} {{ cleanKind(item.kind) }}	Partition by Hash by Column {{$index+1}} Column {{$index+1}} Order by ORDER BY column {{$index+1}}
{{ getArgumentFormattedName(item.name) }}	This same table name must be entered into the Input / Output tab above as an Output.
{{ getArgumentFormattedName(item.name) }}	No columns added, click the + button to add a column

{{config.function.partnerFunction.function_alias_name}}'s arguments

Name	Value
{{ cleanName(item.name) }} {{ cleanKind(item.kind) }}	Partition Type Partition by PARTITION BY column {{$index+1}} Order by ORDER BY column {{$index+1}}
{{ getArgumentFormattedName(item.name) }}	This same table name must be entered into the Input / Output tab above as an Output.
{{ getArgumentFormattedName(item.name) }}	No columns added, click the + button to add a column

Function has no Optional Arguments

Name	Value
Modify Select Columns of Output Query	Customize Select Columns
Additional Clauses