Home

RE: How do I make an ATTRIBUTE column a UUID?

SPLICE MACHINE SOURCE: In my data flow I want to make an attribute column a UUID (For example: 87c312f0-4a49-45d9-aa65-bb6921cb1833). How can I accomplish this?

KaleyVolk Beginner Asked on August 14, 2019 in Diyotta Studio.
Add Comment
Cancel
3 Answers

Hi Kaley

In MSSQL[ sql server] we have a function newid()  which will generate unique values .

1.Create a dataflow and drag the MSSQL source instance into the dataflow

2. Then add a derived attribute in the source instance and include the function as shown below make sure we place it in the diyotta custom function to overcome the validation issues as shown below.

RE: How do I make an ATTRIBUTE column a UUID?

3. Then map the source instance derived attribute to the target instance column it will populate with the unique values as shown below.

RE: How do I make an ATTRIBUTE column a UUID?

Cancel
Expert Answered on August 14, 2019.

KaleyVolk

Hi Naveen,

Thank you, however, I am using Splice Machine as my SOURCE. It doesn’t appear to be working with the method you mentioned above. Any suggestions?

 

Thanks,

Kaley

on August 14, 2019.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.