NEWID

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.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Creates a unique value of type uniqueidentifier. (NEWID in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

NEWID ( )  

Snowflake SQL

Snowflake SQL Documentation

UUID_STRING()

Examples

Outputs may differ because it generates a unique ID in runtime

SQL Server

Code:

IN -> SqlServer_01.sql

SELECT NEWID ( ) AS ID;

Result:

+------------------------------------+
|ID                                  |
+------------------------------------+
|47549DDF-837D-41D2-A59C-A6BC63DF7910|
+------------------------------------+

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT
UUID_STRING( ) AS ID;

Result:

+------------------------------------+
|ID                                  |
+------------------------------------+
|6fd4312a-7925-4ad9-85d8-e039efd82089|
+------------------------------------+

Known Issues

No issues were found.

Related EWIs

No related EWIs.