How do I make an ATTRIBUTE column a UUID with Splice Machine as my source?
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.
3. Then map the source instance derived attribute to the target instance column it will populate with the unique values as shown below.
Splice machine does not provide a UUID SQL function. However it should be possible to create a UDF and use that in Diyotta. Add the UDF in Diyotta and use it source attributes. Sample to use UDF in Diyotta is below.
Reference for UDF to generate UUID – https://www.splicemachine.com/subdomains/apidocs/JavaDocs/2.5/com/splicemachine/uuid/Type1UUID.Generator.html