How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Visier Table Source API

Use row-based management for your source data in Visier. The Table Source API supports direct SQL-based data modifications, eliminating concerns about file management or override behavior. Use the API to create, modify, and delete tables. Use SQL statements to query, insert, update, delete, and merge data into tables with transactions. You can reference the tables by mappings, just like other sources, to load data into an analytic object in a data version.**Note:** This API is in **alpha**. While in alpha, APIs may change in a breaking way without notice; functionality may be removed, and no deprecation notices will be issued.

Visier Table Source API is one of 51 APIs that Visier publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include TableSource. The published artifact set on APIs.io includes an OpenAPI specification and API documentation.

This API exposes 16 operations across 13 paths, and defines 37 schemas. It is described by OpenAPI 3.2.0, at version 22222222.99201.3040.

Requests are made against the base URL https://{vanity_name}.api.visier.io.

16 operations 13 paths 37 schemas 1 DELETE8 GET5 POST2 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
22222222.99201.3040
Base URL
https://{vanity_name}.api.visier.io
Authentication
API Key, API Key, HTTP Bearer, OAuth 2.0
Resource Areas
1

Authentication & Security 4

Visier Table Source API declares 4 security schemes for authenticating requests. An API key is passed in the cookie as VisierASIDToken (CookieAuth). An API key is passed in the header as apikey (ApiKeyAuth). It accepts HTTP bearer tokens (BearerAuth). It supports OAuth 2.0 (OAuth2Auth) using the authorizationCode and password flows, exposing 2 scopes. By default, every request must be authenticated.

Paths & Operations 16

Across 13 paths, the API surfaces 16 operations — 1 DELETE, 8 GET, 5 POST, 2 PUT. Each is listed below with its method, path, parameters, and response codes.

TableSource 16

Use row-based management for your source data in Visier. The Table Source API supports direct SQL-based data modifications, eliminating concerns about file management or override…

GET
/v1alpha/data/table-sources/tables
Retrieve table sources
TableSource_GetTableSources 3 params → default200
POST
/v1alpha/data/table-sources/tables
Create a table source
TableSource_CreateTableSource 1 param body → default200
GET
/v1alpha/data/table-sources/tables/{tableId}
Retrieve a table source
TableSource_GetTableSource 2 params → default200
PUT
/v1alpha/data/table-sources/tables/{tableId}
Update a table source
TableSource_UpdateTableSource 2 params body → default200
DELETE
/v1alpha/data/table-sources/tables/{tableId}
Delete a table source
TableSource_DeleteTableSource 2 params → default200
GET
/v1alpha/data/table-sources/tables/{tableId}/metadata
Retrieve a table source's metadata
TableSource_GetTableSourceMetadata 2 params → default200
POST
/v1alpha/data/table-sources/tables/{tableId}/regenerate
Regenerate a materialized view
TableSource_RegenerateMaterializedView 2 params body → default200
POST
/v1alpha/data/table-sources/transactions
Start a transaction
TableSource_BeginTransaction 1 param body → default200
GET
/v1alpha/data/table-sources/transactions/{transactionId}
Retrieve a transaction's status
TableSource_GetTransaction 3 params → default200
POST
/v1alpha/data/table-sources/transactions/{transactionId}/extend
Extend a transaction's expiry
TableSource_ExtendTransaction 2 params body → default200
PUT
/v1alpha/data/table-sources/transactions/{transactionId}/inputs/{filename}
Upload an input file to a transaction
TableSource_UploadInputFile 3 params body → default200
POST
/v1alpha/data/table-sources/transactions/{transactionId}/jobs
Run a SQL job within a transaction
TableSource_ExecuteJob 2 params body → default200
GET
/v1alpha/data/table-sources/transactions/{transactionId}/jobs/{jobId}
Retrieve a job's status
TableSource_GetJobStatus 4 params → default200
GET
/v1alpha/data/table-sources/transactions/{transactionId}/outputs/{filename}
Download an output file from a transaction
TableSource_DownloadOutputFile 3 params → default200
GET
/v1alpha/data/table-sources/transactions/{transactionId}/outputs/{filename}/parts
List output file parts
TableSource_ListOutputFileParts 3 params → default200
GET
/v1alpha/data/table-sources/transactions/{transactionId}/outputs/{filename}/parts/{partIndex}
Download an output file part
TableSource_DownloadOutputFilePart 4 params → default200

Schemas 37

The contract defines 37 schemas that model the data the API accepts and returns. The most detailed are servicing.sqlsource.SqlSourceTableDTO (10 properties), servicing.sqlsource.SqlSourceTransactionStateDTO (10 properties), servicing.sqlsource.SqlSourceInputDTO (8 properties), servicing.sqlsource.SqlSourceActionDTO (8 properties). Each schema is shown below with its type and property counts.

servicing.sqlsource.SqlSourceGetTableMetadataResponseDTO
object
6 properties
servicing.sqlsource.SqlSourceListOutputFilePartsResponseDTO
object
3 properties
servicing.SynonymListDTO
object
The object's synonyms.
1 property
servicing.sqlsource.SqlSourceGetJobStatusResponseDTO
object
5 properties
data_in.TableSourceRequest
object
1 property
servicing.sqlsource.SqlSourceExtendTransactionRequestDTO
object
1 property
servicing.sqlsource.SqlSourceColumnDTO
object
3 properties
servicing.sqlsource.SqlSourceResetActionDTO
object
A reset action. Rolls the table back to the latest snapshot given the timestamp.
2 properties
servicing.sqlsource.SqlSourceActionDTO
object
An individual action to execute within a SQL job.
8 properties
servicing.sqlsource.SqlSourceInputDTO
object
8 properties
servicing.sqlsource.SqlSourceExecuteJobRequestDTO
object
5 properties
servicing.sqlsource.SqlSourceJobStatusSummaryDTO
object
4 properties
servicing.sqlsource.SqlSourceIoFormatDTO
object
Input/output format configuration for a query.
2 properties
servicing.sqlsource.SqlSourceTenantJobStatusDTO
object
5 properties
servicing.sqlsource.SqlSourceSetMetadataActionDTO
object
A set metadata action. Sets the key-value pairs to apply to the table source when you commit the transaction. You can use key-value pairs as preconditions for…
3 properties
servicing.sqlsource.SqlSourceProcessActionDTO
object
A process action. Spawns a processing job for the specified data categories.
4 properties
servicing.sqlsource.SqlSourceTableDTO
object
10 properties
servicing.sqlsource.SqlSourceUpsertActionDTO
object
An upsert action. Replaces any rows that match on keys with the rows in the source table, and inserts them if there are no matches.
3 properties
servicing.sqlsource.SqlSourceRollbackActionDTO
object
A rollback action.
servicing.sqlsource.SqlSourceMaterializedViewConfigDTO
object
3 properties
servicing.sqlsource.SqlSourceBeginTransactionRequestDTO
object
2 properties
servicing.sqlsource.SqlSourceMaterializedViewDependencyDTO
object
2 properties
servicing.sqlsource.SqlSourceExecuteJobResponseDTO
object
3 properties
servicing.sqlsource.SqlSourceIoFormatDTO_CsvFormatDTO
object
Options for the CSV format.
1 property
servicing.sqlsource.SqlSourceTransactionStatusSummaryDTO
object
4 properties
servicing.sqlsource.SqlSourceCommitActionDTO
object
A commit action.
Status
object
The response structure for errors.
5 properties
servicing.sqlsource.SqlSourceJobPreconditionDTO
object
A precondition that must be met for a job to execute.
2 properties
servicing.sqlsource.SqlSourceTableListResponseDTO
object
1 property
servicing.BasicInformationDTO
object
Fields that identify and describe the object, such as its display name, description, and explanation.
6 properties
servicing.sqlsource.SqlSourceReplaceActionDTO
object
A replace action. Replaces all rows in the target table with the rows in the source table. Preserves rows that exist in both the source and the target.
2 properties
servicing.sqlsource.SqlJobTableAccessDTO
object
2 properties
servicing.sqlsource.SqlSourceQueryOutputDTO
object
Output configuration for a query. If specified, query output will be written to a file that can be retrieved later.
2 properties
servicing.sqlsource.SqlSourceTransactionStateDTO
object
10 properties
servicing.sqlsource.SqlSourceChildTransactionStateDTO
object
4 properties
servicing.sqlsource.SqlSourceIoFormatDTO_ParquetFormatDTO
object
Options for the Parquet format.
servicing.sqlsource.SqlSourceQueryActionDTO
object
A query action. Executes the specified SQL query within the tenant's context.
4 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

visier-tablesource-api-openapi.yml Raw ↑

Other APIs Visier publishes across the network.

Visier Query MCP Server
Visier Analytic Objects V2 API
Visier Basic Authentication API
Visier Benchmarks API
Visier Concepts V2 API
Visier Consolidated Analytics API
Visier Data And Job Handling API
Visier Data Export Connectors API API
Visier Data Intake API
Visier Data Model API
Visier Data Query API
Visier Data Upload API
Where this information came from

This is an independent, third-party profile of Visier Table Source API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.