the best practice to create unique id within Keboola

Hi all, 

We have a database of our clients in mongoDB, where the unique id of the client is created. But for some purposes we need to anonymize the ids for reporting it to other services.

I can see there two possibilities:

  1. encode the ids or
  2. create new unique ids which will be stored in Keboola.

We are used to mongoDB ids so we would prefer to have something similar.

I found out that there is a possibility to make a unique value via snowlake command uuid_string() but the string is unbelievable long.
 

What would you recommend?

2
1 reply