DB_ID_UDF(STRING)

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

This user-defined function (UDF) emulates the DB_ID functionality.

DB_ID_UDF(p_database_name STRING)

Parameters

p_database_name STRING

The name of the database to obtain the id.

Returns

Returns an id which correspond to the number assigned to the database when it is created. This number is assigned consecutively.

Usage example

Input:

SELECT DB_ID_UDF('MY_DATABASE')

Output:

6

If the database does not exist, it returns null.