Elementum Search Tables API
Manage search tables (snowflake and linked)
Operations 4
POST
/aspects/{aspectId}/linked-search-tables
Create a search table linked to an existing Cortex Search Service
#
Manage search tables (snowflake and linked)
Every API here is available over the APIs.io API and to AI agents over MCP.
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.curl "https://apis.io/api/v1/apis/elementum:elementum-search-tables-api"
curl "https://apis.io/api/v1/apis?limit=25"
Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
openapi: 3.2.0
info:
title: Elementum Search Tables API
description: Manage search tables (snowflake and linked)
contact:
email: apiteam@elementum.io
version: 0.0.1
servers:
- url: /v1
tags:
- name: Search Tables
description: Manage search tables (snowflake and linked)
paths:
/aspects/{aspectId}/search-tables:
post:
tags:
- Search Tables
summary: Create a snowflake-backed search table
operationId: createSnowflakeSearchTable
parameters:
- $ref: '#/components/parameters/aspectId'
requestBody:
description: Snowflake search-table configuration
content:
application/json:
schema:
$ref: '#/components/schemas/AspectSearchTableSnowflakeCreateRequest'
required: true
responses:
'201':
description: Created
content:
application/json:
schema:
$ref: '#/components/schemas/SearchTable'
'400':
$ref: '#/components/responses/400'
'401':
$ref: '#/components/responses/401'
'403':
$ref: '#/components/responses/403'
'404':
$ref: '#/components/responses/404'
'422':
$ref: '#/components/responses/422'
'429':
$ref: '#/components/responses/429'
'500':
$ref: '#/components/responses/500'
security:
- ClientCredentials: []
x-codegen-request-body-name: body
/aspects/{aspectId}/search-tables/{id}:
get:
tags:
- Search Tables
summary: Get a search table by ID
operationId: getSearchTable
parameters:
- $ref: '#/components/parameters/aspectId'
- $ref: '#/components/parameters/aspectSearchTableId'
responses:
'200':
description: Ok
content:
application/json:
schema:
$ref: '#/components/schemas/SearchTable'
'400':
$ref: '#/components/responses/400'
'401':
$ref: '#/components/responses/401'
'403':
$ref: '#/components/responses/403'
'404':
$ref: '#/components/responses/404'
'422':
$ref: '#/components/responses/422'
'429':
$ref: '#/components/responses/429'
'500':
$ref: '#/components/responses/500'
security:
- ClientCredentials: []
x-codegen-request-body-name: body
put:
tags:
- Search Tables
summary: Update a search table by ID
operationId: updateSearchTable
parameters:
- $ref: '#/components/parameters/aspectId'
- $ref: '#/components/parameters/aspectSearchTableId'
requestBody:
description: Search-table fields to update (snowflake-only today)
content:
application/json:
schema:
$ref: '#/components/schemas/AspectSearchTableUpdateInput'
required: true
responses:
'200':
description: Ok
content:
application/json:
schema:
$ref: '#/components/schemas/SearchTable'
'400':
$ref: '#/components/responses/400'
'401':
$ref: '#/components/responses/401'
'403':
$ref: '#/components/responses/403'
'404':
$ref: '#/components/responses/404'
'422':
$ref: '#/components/responses/422'
'429':
$ref: '#/components/responses/429'
'500':
$ref: '#/components/responses/500'
security:
- ClientCredentials: []
x-codegen-request-body-name: body
/aspects/{aspectId}/linked-search-tables:
post:
tags:
- Search Tables
summary: Create a search table linked to an existing Cortex Search Service
operationId: createLinkedSearchTable
parameters:
- $ref: '#/components/parameters/aspectId'
requestBody:
description: Linked search-table configuration
content:
application/json:
schema:
$ref: '#/components/schemas/AspectLinkedSearchTableCreateRequest'
required: true
responses:
'201':
description: Created
content:
application/json:
schema:
$ref: '#/components/schemas/SearchTable'
'400':
$ref: '#/components/responses/400'
'401':
$ref: '#/components/responses/401'
'403':
$ref: '#/components/responses/403'
'404':
$ref: '#/components/responses/404'
'422':
$ref: '#/components/responses/422'
'429':
$ref: '#/components/responses/429'
'500':
$ref: '#/components/responses/500'
security:
- ClientCredentials: []
x-codegen-request-body-name: body
components:
schemas:
SearchTableTimeUnit:
type: string
description: Time unit for search-table refresh duration.
enum:
- SECONDS
- MINUTES
- HOURS
- DAYS
AspectSearchTableSnowflakeCreateRequest:
required:
- attributeFieldIds
- duration
- targetLag
type: object
properties:
attributeFieldIds:
type: array
items:
type: string
format: uuid
vectorIndexes:
type: array
items:
$ref: '#/components/schemas/VectorIndexInput'
aiProviderConnectorId:
type: string
description: Legacy single-index embedding provider; prefer vectorIndexes
format: uuid
targetLag:
type: integer
description: Refresh target-lag amount
format: int32
textIndexFieldIds:
type: array
items:
type: string
format: uuid
duration:
$ref: '#/components/schemas/SearchTableTimeUnit'
fieldId:
type: string
description: Legacy single-index field; prefer vectorIndexes for new tables
format: uuid
warehouse:
type: string
description: Snowflake warehouse used to maintain the table
VectorIndex:
type: object
properties:
aiProviderConnector:
$ref: '#/components/schemas/AiProviderConnectorRef'
field:
$ref: '#/components/schemas/SearchTableField'
AspectSearchTableUpdateInput:
type: object
properties:
snowflake:
$ref: '#/components/schemas/AspectSearchTableSnowflakeUpdateInput'
AiProviderConnectorRef:
type: object
properties:
id:
type: string
description: The AI provider connector ID
format: uuid
SearchTable:
type: object
properties:
aiProviderConnector:
$ref: '#/components/schemas/AiProviderConnectorRef'
attributeFields:
type: array
items:
$ref: '#/components/schemas/SearchTableField'
duration:
$ref: '#/components/schemas/SearchTableTimeUnit'
linkedDatabase:
type: string
description: 'Linked-only: database holding the Cortex Search Service'
field:
$ref: '#/components/schemas/SearchTableField'
id:
type: string
description: The search-table ID
format: uuid
linkedSchema:
type: string
description: 'Linked-only: schema holding the Cortex Search Service'
vectorIndexes:
type: array
items:
$ref: '#/components/schemas/VectorIndex'
textIndexFields:
type: array
items:
$ref: '#/components/schemas/SearchTableField'
errorMessage:
type: string
description: Populated when status is FAILED
targetLag:
type: integer
description: Refresh target-lag amount
format: int32
warehouse:
type: string
description: Snowflake warehouse used to maintain the table
__typename:
type: string
description: The search-table variant (AspectSearchSnowflakeTable or AspectLinkedSearchTable)
linkedServiceName:
type: string
description: 'Linked-only: name of the existing Cortex Search Service'
displayName:
type: string
description: The server-assigned display name
status:
type: string
description: Lifecycle status (PENDING, READY, FAILED, …)
VectorIndexInput:
required:
- aiProviderConnectorId
- fieldId
type: object
properties:
aiProviderConnectorId:
type: string
description: The embedding provider connector for this index
format: uuid
fieldId:
type: string
description: The aspect field to vectorize
format: uuid
SearchTableField:
type: object
properties:
type:
type: string
description: The aspect field variant (e.g. AspectTextField, AspectNumberField)
id:
type: string
description: The field ID
format: uuid
name:
type: string
description: The field name
AspectSearchTableSnowflakeUpdateInput:
type: object
properties:
warehouse:
type: string
description: Snowflake warehouse used to maintain the table
duration:
$ref: '#/components/schemas/SearchTableTimeUnit'
targetLag:
type: integer
description: Refresh target-lag amount
format: int32
AspectLinkedSearchTableCreateRequest:
required:
- cloudLinkId
- database
- schema
- serviceName
type: object
properties:
cloudLinkId:
type: string
description: The cloud link containing the Cortex Search Service
format: uuid
warehouse:
type: string
description: Optional warehouse override
serviceName:
type: string
description: Name of the existing Cortex Search Service
schema:
type: string
description: Schema holding the Cortex Search Service
database:
type: string
description: Database holding the Cortex Search Service
responses:
'401':
description: Unauthorized
'400':
description: Bad Request
'429':
description: Too Many Requests
'404':
description: Not Found
'500':
description: Internal Server Error
'403':
description: Forbidden
'422':
description: Unprocessable Entity
parameters:
aspectSearchTableId:
name: id
in: path
description: The search-table ID
required: true
schema:
type: string
format: uuid
aspectId:
name: aspectId
in: path
description: The aspect ID (UUID)
required: true
schema:
type: string
format: uuid
securitySchemes:
ClientCredentials:
type: oauth2
flows:
clientCredentials:
tokenUrl: /oauth/token
externalDocs:
description: Find out more about Elementum
url: https://www.elementum.com/
x-provenance:
method: harvested
publisher: Elementum
source: https://api.elementum.io/openapi.json
note: split by refine-openapis from the provider's own published document, verified by fetch (openapi/_original/*.fetch.json);
stamped by stamp-openapi-provenance.py (roadmap#793)