identifier
3 identifier types: none a sibling also accepts, 1 that decompose into parts.
The 3 identifier types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Snowflake ID snowflake_id · BIGINT | 175928847299117063 | — |
TSID tsid · VARCHAR | 0JMVQ049NFN6K | — |
ULID ulid · VARCHAR | 01ARZ3NDEKTSV4RRFFQ69G5FAV | — |
Which identifier type is it?
1 of 3 identifier types accepts it.
| Type | Reads it as |
|---|---|
Snowflake ID snowflake_id | 2012-03-03 13:01:20.453 |
Use it
CLI · DuckDB
$ printf '%s\n' '175928847299117063' '1234567890123456789' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('175928847299117063'), ('1234567890123456789')) t(v);After 1234567890123456789, one type remains: snowflake_id.