snowflake_muid_uuid.sql

create or replace function uuid_to_muid(id varchar)
returns varchar as
$$
trim(base64_encode(
  substring(hex_decode_binary(replace(id, '-', '')), 9, 8) ||
  substring(hex_decode_binary(replace(id, '-', '')), 1, 8),
  0,
  '-_ '
))
$$;
                              
create or replace function muid_to_uuid(id varchar(22))
returns varchar(36) as
$$
with uuids as (select
    hex_encode(substring(base64_decode_binary(id || '  ', '-_ '), 9, 9), 0) || 
    hex_encode(substring(base64_decode_binary(id || '  ', '-_ '), 0, 9), 0) as uuid
)
select concat(substring(uuid, 0, 8), '-', substring(uuid, 9, 4), '-', substring(uuid, 13, 4), '-', substring(uuid, 17, 4), '-', substring(uuid, 21, 12)) from uuids
$$;