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.

Some parts of the output code are omitted for clarity reasons.

Definition

Reproduces the functionality of the expand-on function in Teradata.

PUBLIC.EXPAND_ON_UDF(TIME STRING, SEQ NUMBER, PERIOD STRING)

Parameters

TIME STRING

The expand-on time used in nachor.

SEQ NUMBER

The sequence to calculate each row.

PERIOD STRING

The date from the period required.

Returns

A VARCHAR that represents the calculation of the expand-on clause for the period.

Migration example

Input:

IN -> Teradata_01.sql

SELECT bg FROM table1 EXPAND ON pd AS bg BY ANCHOR ANCHOR_SECOND;

Output:

OUT -> Teradata_01.sql

WITH
ExpandOnCTE AS
(
SELECT
PUBLIC.EXPAND_ON_UDF('ANCHOR_SECOND', VALUE, pd) bg
FROM
table1,
TABLE(FLATTEN(PUBLIC.ROW_COUNT_UDF(PUBLIC.DIFF_TIME_PERIOD_UDF('ANCHOR_SECOND', pd))))
)
SELECT
bg
FROM
table1,
ExpandOnCTE;