MeridianMERIDIAN

S3 URI

Amazon S3 bucket/key URI in the format s3://bucket-name/key-path. Used in data pipelines, ETL tools, and cloud storage references.

S3 URI

technology.cloud.s3_uri

Amazon S3 bucket/key URI in the format s3://bucket-name/key-path. Used in data pipelines, ETL tools, and cloud storage references.

Domain
technology
Category
cloud
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "s3://my-bucket/data/file.csv"
→ technology.cloud.s3_uri

DuckDB

Detect
SELECT finetype('s3://my-bucket/data/file.csv');
-- → 'technology.cloud.s3_uri'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.cloud.s3_uri';

Struct Expansion

Expression
bucket: REGEXP_EXTRACT({col}, '^s3://([^/]+)')
key: REGEXP_EXTRACT({col}, '^s3://[^/]+/(.*)')

JSON Schema

finetype schema technology.cloud.s3_uri
{
  "$id": "https://meridian.online/schemas/technology.cloud.s3_uri",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Amazon S3 bucket/key URI in the format s3://bucket-name/key-path. Used in data pipelines, ETL tools, and cloud storage references.",
  "examples": [
    "s3://my-bucket/data/file.csv",
    "s3://production-logs/2024/01/events.parquet",
    "s3://data-lake-raw/ingestion/batch-001/part-00000.json"
  ],
  "pattern": "^s3://[a-z0-9][a-z0-9.\\-]{1,61}[a-z0-9](/.*)?$",
  "title": "S3 URI",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

s3://my-bucket/data/file.csvs3://production-logs/2024/01/events.parquets3://data-lake-raw/ingestion/batch-001/part-00000.json

Type Registry