Tables

Bulk create or update tables

Create or update multiple tables in a single operation. Returns a BulkOperationResult with success/failure details for each table.

put/v1/tables/bulk

Request

  • Base URL: https://demo.getcollate.io/api
  • URL: https://demo.getcollate.io/api/v1/tables/bulk
  • Auth: HTTP bearer

Query parameters

overrideMetadataboolean

When true, allows the bulk update to overwrite user-curated fields (description, displayName, owners, tags) that bot-driven updates normally preserve, and disables the sourceHash fast-path so unchanged entities are re-evaluated. Defaults to false.

asyncboolean

Request body

namestring required
displayNamestring
descriptionstring
tableType'Regular' | 'External' | 'Dynamic' | 'View' | 'SecureView' | 'MaterializedView' | 'Iceberg' | 'Local' | 'Partitioned' | 'Foreign' | 'Transient' | 'Stream' | 'Stage' | 'SemanticView'
locationPathstring
aliasesstring[]
databaseSchemastring required
schemaDefinitionstring
retentionPeriodstring
extensionobject
sourceUrlstring
domainsstring[]
dataProductsstring[]
fileFormat'csv' | 'csv.gz' | 'tsv' | 'avro' | 'parquet' | 'pq' | 'pqt' | 'parq' | 'parquet.snappy' | 'json' | 'json.gz' | 'json.zip' | 'jsonl' | 'jsonl.gz' | 'jsonl.zip' | 'MF4'
sourceHashstring

Response

Bulk operation results

dryRunboolean
status'success' | 'failure' | 'aborted' | 'partialSuccess' | 'running'
abortReasonstring
numberOfRowsProcessedinteger
numberOfRowsPassedinteger
numberOfRowsFailedinteger

Changes

No recorded changes to this operation across all 1 revision of this API.