COMPUTE_EXPAND_ON_UDF

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Definition

Calculates the expand-on function depending on the period type argument.

PUBLIC.COMPUTE_EXPAND_ON_UDF(TIME STRING, SEQ NUMBER, PERIOD TIMESTAMP, PERIODTYPE STRING)

Parameters

TIME STRING

The time used in anchor.

SEQ NUMBER

The sequence to calculate each row.

PERIOD TIMESTAMP

The date from the period required.

PERIODTYPE STRING

The period type for the calculation ('BEGIN' or 'END')

Returns

A timestamp that represents each row of the EXPAND-ON.

Example

This UDF is used as a derived function of the EXPAND_ON_UDF.