Introducing the OpenAPI Connector

Starburst has introduced an OpenAPI connector, entering public preview with Starburst Enterprise 482, that lets users query data from APIs with OpenAPI descriptions through SQL without building custom pipelines or copying data manually. The connector creates catalogs from an API’s base URI and specification, automatically generating table functions for qualifying GET endpoints and translating JSON responses and schemas into Trino-native rows, columns, arrays, and row types. Users can join API data with information from Starburst’s existing connectors, analyze nested API responses using SQL features such as UNNEST, and configure authentication for private APIs. It also provides configurable cast policies to either drop unsupported schema elements or fall back to strings and JSON types, enabling partial access to complex APIs such as GitHub’s. Pagination support can follow link headers for multi-page results, though sequential pagination may affect performance for large datasets, while query limits can speed API exploration.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.