PostgreSQL Data Asset Type Support

Data assets can now have a postgres_table type in the externalMeta.type field, enabling PostgreSQL tables to be properly identified and managed alongside existing Snowflake and Sledhouse assets.

What's New

New postgres_table value for the externalMeta.type enum in data asset responses
PostgreSQL tables are now distinguishable from Snowflake tables in API responses
Semantic model validation now supports PostgreSQL-specific data types

Affected Endpoints

GET /api/v1/accounts/{accountId}/workspaces/{workspaceId}/data-assets
PATCH /api/v1/accounts/{accountId}/workspaces/{workspaceId}/data-assets

Response Schema Update

The externalMeta.type field now accepts an additional value:

{
  "externalMeta": {
    "name": "Customer Orders",
    "type": "postgres_table"
  }
}

Supported Type Values

Value	Description
`sledhouse_table`	Sledhouse managed table
`data_product`	Sledhouse data product
`snowflake_table`	Direct Snowflake table
`postgres_table`	Direct PostgreSQL table

Migration Notes

No migration required. Existing integrations continue to work unchanged. The new type value only appears for workspaces connected to PostgreSQL data sources.