MeridianMERIDIAN

Increment / Counter

Counter value that increases by fixed steps (often 1). May appear as row numbers, sequence IDs, or generation numbers. Broad categorization.

Increment / Counter

representation.identifier.increment

Counter value that increases by fixed steps (often 1). May appear as row numbers, sequence IDs, or generation numbers. Broad categorization.

Domain
representation
Category
identifier
Casts to
BIGINT
Scope
broad_numbers

Try it

CLI
$ finetype infer -i "1"
→ representation.identifier.increment

DuckDB

Detect
SELECT finetype('1');
-- → 'representation.identifier.increment'
Cast expression
CAST({col} AS BIGINT)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS BIGINT) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.identifier.increment';

JSON Schema

finetype schema representation.identifier.increment
{
  "$id": "https://meridian.online/schemas/representation.identifier.increment",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Counter value that increases by fixed steps (often 1). May appear as row numbers, sequence IDs, or generation numbers. Broad categorization.",
  "examples": [
    "1",
    "2",
    "3"
  ],
  "pattern": "^[0-9]+$",
  "title": "Increment / Counter",
  "type": "string",
  "x-finetype-broad-type": "BIGINT",
  "x-finetype-transform": "CAST({col} AS BIGINT)"
}

Examples

123

Aliases

countersequenceid

Type Registry