---
title: "Add live tables from a virtual connection"
method: POST
path: "/datasets/{owner}/{id}/tables"
tags: ["tables"]
---

# Add live tables from a virtual connection

`POST /datasets/{owner}/{id}/tables`

Add tables from an established virtual connection. For increased security, endpoints that interact with
external connection sources require an Enterprise Admin Token. This token can be found under
[Advanced Settings](https://data.world/settings/advanced). To learn more about the virtual connections
data.world supports, please visit our
[help portal](https://help.data.world/hc/en-us/sections/360009504254-Create-and-manage-virtual-connections).

## Path parameters

- `owner` string, required
- `id` string, required

## Request body

- TableBatchUpdateRequest
  - `tables` FileCreateOrUpdateRequest[]
    - `description` string
    - `labels` string[]
    - `mediaType` string
    - `mediaTypeLocked` boolean
    - `name` string, required
    - `source` FileSourceCreateOrUpdateRequest
      - `authorization` WebAuthorization
        - `credentials` string
        - `type` string, required
      - `credentials` WebCredentials
        - `password` string
        - `user` string, required
      - `dataTables` object
      - `databaseMetadataSpec` DatabaseMetadataSpecDto
        - `tableSpecs` TableMetadataSpecDto[]
          - `database` string
          - `schema` string
          - `tablePrefixes` string[]
          - `tableTypes` string[]
          - `tables` string[]
      - `databaseSource` DatabaseSourceReference
        - `id` string, uuid, required
        - `owner` string, required
      - `dwccSpec` DwccSpecDto
        - `databaseId` string
        - `metadataToExclude` string[]
        - `sourceDatabase` string
        - `sourceSchemas` string[]
        - `targetCatalog` string
      - `expandArchive` boolean
      - `method` 'GET' | 'POST'
      - `oauthToken` OauthTokenReference
        - `id` string, uuid, required
        - `owner` string, required
        - `site` string, required
      - `requestEntity` string
      - `requestHeaders` object
      - `tableSpec` SingleTableMetadataSpecDto
        - `database` string
        - `schema` string
        - `table` string
        - `tableType` 'EXTRACT' | 'VIRTUAL'
      - `url` string, uri
      - `useDwCredentials` boolean
      - `viewRequest` ViewRequestDto
        - `baseAgentId` string, required
        - `baseDatasetId` string, required
        - `queryId` string, uuid
        - `queryName` string, required
        - `queryText` string
        - `queryType` 'SPARQL' | 'SQL', required
        - `runAsAgentId` string, required
        - `targetAgentId` string, required
        - `targetDatasetId` string, required

## Response `200`

default response

- SuccessMessage
  - `message` string

---

[API](https://skmtc.dev/data/apis/data-world-public-api.md) · [All operations](https://skmtc.dev/data/apis/data-world-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/data/data-world-public-api/revisions/0a0cb1f94dad/schema)