v.24.1New Feature

Added sqidDecode Function for Sqids Decoding

Official CH changelog text
Added function sqidDecode which decodes Sqids. #58544 (Robert Schulze).
Added the function sqidDecode to decode Sqids-encoded strings in ClickHouse.

Why it matters

This feature allows users to convert Sqids (https://sqids.org/) encoded strings back to their original numeric IDs directly within ClickHouse, facilitating integration with systems using Sqids for obfuscating numeric identifiers.

How to use it

Use the function sqidDecode in your queries to decode Sqids strings. For example:
sql<br>SELECT sqidDecode('your_sqid_string')<br>FROM your_table<br>

Related resources

PreviousNext