BFILENAME_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

The function takes the directory name and the filename parameter as a string. Then, it returns a concatenation using the '\'.

The character '\' must be changed to match the Operating System file concatenation character.

PUBLIC.BFILENAME_UDF (DIRECTORYNAME STRING, FILENAME STRING);

Parameters

DIRECTORYNAME STRING

The directory name to be processed as a string.

FILENAME STRING

The filename to be concatenated.

Returns

Returns a string that contains the directory name and filename concatenated by a '\'.

Migration example

Input:

IN -> Oracle_01.sql

SELECT BFILENAME ('directory', 'filename.jpg') FROM DUAL;

Output:

OUT -> Oracle_01.sql

SELECT
PUBLIC.BFILENAME_UDF('directory', 'filename.jpg') FROM DUAL;

Usage example

Input:

SELECT PUBLIC.BFILENAME_UDF('directory', 'filename.jpg');

Output:

directory\filename.jpg