Displaying fixed-length byte array

Dremio Cloud
1

Hey.

My iceberg table schema has field ruleId: required fixed[16].
If open Dremio this fields is displayed as encoded string, f.e. ACieUvJcSkigP18ZJ85shg==.
What is the algorithm of decoding? I want to make sure my data is saved properly.

2

Hello @Konstantin - you could use TOASCII function which converts a string that is encoded in the specified character set to UTF-8.
To check all the functions for Strings, refer to this documentation: Dremio
Best,
Payal