Get Schema Changes

Get schema changes

curl --request GET \
  --url http://localhost:8000/api/v1/assets/{asset_id}/schema-changes

const options = {method: 'GET'};

fetch('http://localhost:8000/api/v1/assets/{asset_id}/schema-changes', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "success": true,
  "data": null,
  "message": "<string>",
  "error": "<string>",
  "meta": {}
}

{
  "detail": [
    {
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

GET

api

assets

{asset_id}

schema-changes

Get schema changes

curl --request GET \
  --url http://localhost:8000/api/v1/assets/{asset_id}/schema-changes

const options = {method: 'GET'};

fetch('http://localhost:8000/api/v1/assets/{asset_id}/schema-changes', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

{
  "success": true,
  "data": null,
  "message": "<string>",
  "error": "<string>",
  "meta": {}
}

{
  "detail": [
    {
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

Get the history of schema changes for an asset. Use this to track drift, understand what changed, and build change management workflows.

When to Use

Change tracking: Monitor schema drift over time
Impact analysis: Understand what changed before troubleshooting
Compliance: Audit schema modifications
Integration: Sync changes to external systems

SDK & CLI Examples

from anomalyarmor import Client

client = Client(api_key="aa_live_xxx")

# Get schema changes from last 7 days
changes = client.schema.changes(
    "snowflake.prod.public.orders",
    days_back=7
)

for change in changes:
    print(f"{change.change_type}: {change.object_name}")
    print(f"  Detected: {change.detected_at}")
    if change.old_value:
        print(f"  Before: {change.old_value}")
    if change.new_value:
        print(f"  After: {change.new_value}")

# Filter by change type
removals = client.schema.changes(
    "snowflake.prod.public.orders",
    change_type="column_removed"
)

# Get recent changes
anomalyarmor schema changes snowflake.prod.public.orders

# Filter by days
anomalyarmor schema changes snowflake.prod.public.orders --days 7

# Filter by change type
anomalyarmor schema changes snowflake.prod.public.orders --type column_removed

# Output as JSON
anomalyarmor schema changes snowflake.prod.public.orders --format json

Parameters

Parameter	Type	Description
`asset_id`	string	Asset ID or qualified name
`days_back`	integer	Look back this many days (default: 30)
`change_type`	string	Filter by type (see Change Types below)
`limit`	integer	Max results (default: 100)

Response

{
  "asset": "snowflake.prod.public.orders",
  "changes": [
    {
      "id": "chg_abc123",
      "change_type": "column_removed",
      "object_name": "status",
      "object_type": "column",
      "old_value": {
        "name": "status",
        "data_type": "varchar(20)",
        "nullable": true
      },
      "new_value": null,
      "detected_at": "2024-01-15T08:30:00Z",
      "discovery_id": "disc_xyz789"
    },
    {
      "id": "chg_def456",
      "change_type": "column_added",
      "object_name": "fulfillment_status",
      "object_type": "column",
      "old_value": null,
      "new_value": {
        "name": "fulfillment_status",
        "data_type": "varchar(50)",
        "nullable": true
      },
      "detected_at": "2024-01-15T08:30:00Z",
      "discovery_id": "disc_xyz789"
    }
  ],
  "total": 2
}

Response Fields

Field	Description
`id`	Unique change identifier
`change_type`	Type of change (see Change Types)
`object_name`	Name of changed column or table
`object_type`	`column` or `table`
`old_value`	Previous state (null for additions)
`new_value`	New state (null for removals)
`detected_at`	When the change was discovered
`discovery_id`	Discovery run that found this change

Change Types

Type	Description	Impact
`column_added`	New column appeared	Low - usually safe
`column_removed`	Column no longer exists	High - breaks queries
`column_type_changed`	Data type modified	Medium - may affect logic
`column_renamed`	Detected as remove + add	High - breaks queries
`table_added`	New table discovered	Low - informational
`table_removed`	Table no longer exists	High - breaks queries
`constraint_changed`	PK, FK, or unique modified	Medium - may affect joins

Error Responses

Status	Meaning
`401`	Invalid or missing API key
`404`	Asset not found
`429`	Rate limit exceeded

Headers

Authorization

string

Path Parameters

asset_id

string<uuid>

required

Query Parameters

days_back

integer

default:7

Days to look back for changes

Required range: 1 <= x <= 365

Response

Successful Response

Standard API response wrapper.

success

boolean

required

data

unknown

message

string | null

error

string | null

API Overview

API Reference

API Guides

SDKs

CLI

Integrations

AI Agents

When to Use

SDK & CLI Examples

Parameters

Response

Response Fields

Change Types

Error Responses

Headers

Path Parameters

Query Parameters

Response

​When to Use

​SDK & CLI Examples

​Parameters

​Response

​Response Fields

​Change Types

​Error Responses

Headers

Path Parameters

Query Parameters

Response

When to Use

SDK & CLI Examples

Parameters

Response

Response Fields

Change Types

Error Responses