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" --mode column
→ representation.identifier.increment

DuckDB

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

JSON Schema

finetype taxonomy representation.identifier.increment -o json-schema
{
  "$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-label": "representation.identifier.increment",
  "x-finetype-pii": false
}

Examples

123

Aliases

countersequenceid

Type Registry