> ## Documentation Index
> Fetch the complete documentation index at: https://docs.elementary-data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# List table assets

> Lists warehouse table assets with their warehouse-specific fields (`data_platform`, `db_name`, `schema_name`, `table_name`, `materialization`). Full scan by default; supports the `synced_since` / `deleted_since` feeds.



## OpenAPI

````yaml api-reference/beta/openapi.json get /public/beta/{env_id}/assets/tables
openapi: 3.1.0
info:
  description: >
    The Elementary Public API is a REST interface for programmatically reading

    Elementary's assets, columns, and lineage for one environment.


    **Authentication.** Send a bearer token (personal or account token) in the

    `Authorization` header. The token resolves to an account; results are scoped
    to

    the environments that token may view.


    **Environment scope.** Every resource lives under `/{env_id}`. Call

    `GET /environments` first to discover the ids you can access.


    **Pagination.** List endpoints are keyset-paginated: pass `limit` (default
    500,

    max 2000) and follow `next_cursor` until `has_more` is `false`. Cursors are
    opaque

    and bound to the filters that produced them — reusing a cursor with
    different

    filters returns `400`.


    **Incremental sync.** Every dataset supports a full scan (default). Assets
    and

    columns also expose two incremental feeds: `synced_since` (upserts) and

    `deleted_since` (soft-delete tombstones).


    **Rate limiting.** Requests are rate-limited per account; responses carry

    `RateLimit-*` headers and `429` responses include `Retry-After`.


    _Beta: the shape may change while we co-design with early adopters._
  title: Elementary Public API
  version: beta
servers:
  - url: https://prod.api.elementary-data.com
security:
  - bearerAuth: []
tags:
  - description: Discover accessible environments.
    name: Environments
  - description: Lineage assets — tables, views, BI assets.
    name: Assets
  - description: Columns of assets.
    name: Columns
  - description: Asset-to-asset lineage edges.
    name: Asset lineage
  - description: Column-level lineage edges.
    name: Column lineage
paths:
  /public/beta/{env_id}/assets/tables:
    get:
      tags:
        - Assets
      summary: List table assets
      description: >-
        Lists warehouse table assets with their warehouse-specific fields
        (`data_platform`, `db_name`, `schema_name`, `table_name`,
        `materialization`). Full scan by default; supports the `synced_since` /
        `deleted_since` feeds.
      operationId: list_table_assets_public_beta__env_id__assets_tables_get
      parameters:
        - description: Environment identifier that scopes the request.
          in: path
          name: env_id
          required: true
          schema:
            description: Environment identifier that scopes the request.
            title: Env Id
            type: string
        - description: Return only table assets with these ids.
          in: query
          name: ids
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: Return only table assets with these ids.
            title: Ids
        - description: >-
            Return only table assets from these source types (e.g. `dbt`,
            `fivetran`).
          in: query
          name: source_types
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: >-
              Return only table assets from these source types (e.g. `dbt`,
              `fivetran`).
            title: Source Types
        - description: Return only table assets tagged with any of these tags.
          in: query
          name: tags
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: Return only table assets tagged with any of these tags.
            title: Tags
        - description: Return only table assets in these databases.
          in: query
          name: db_names
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: Return only table assets in these databases.
            title: Db Names
        - description: Return only table assets in these schemas.
          in: query
          name: schema_names
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: Return only table assets in these schemas.
            title: Schema Names
        - description: >-
            Return only table assets with these materializations (e.g. `table`,
            `view`, `incremental`).
          in: query
          name: materializations
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                maxItems: 1000
                type: array
              - type: 'null'
            description: >-
              Return only table assets with these materializations (e.g.
              `table`, `view`, `incremental`).
            title: Materializations
        - description: >-
            Upserts feed: assets whose `synced_at` >= this time (inclusive).
            Orders by `synced_at`.
          in: query
          name: synced_since
          required: false
          schema:
            anyOf:
              - format: date-time
                type: string
              - type: 'null'
            description: >-
              Upserts feed: assets whose `synced_at` >= this time (inclusive).
              Orders by `synced_at`.
            title: Synced Since
        - description: >-
            Tombstones feed: assets whose `deleted_at` >= this time (inclusive).
            Orders by `deleted_at`.
          in: query
          name: deleted_since
          required: false
          schema:
            anyOf:
              - format: date-time
                type: string
              - type: 'null'
            description: >-
              Tombstones feed: assets whose `deleted_at` >= this time
              (inclusive). Orders by `deleted_at`.
            title: Deleted Since
        - description: >-
            Opaque cursor from a previous response's `next_cursor`. Reuse it
            only with the identical query parameters that produced it.
          in: query
          name: cursor
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: >-
              Opaque cursor from a previous response's `next_cursor`. Reuse it
              only with the identical query parameters that produced it.
            title: Cursor
        - description: Maximum items to return per page (1-2000).
          in: query
          name: limit
          required: false
          schema:
            default: 500
            description: Maximum items to return per page (1-2000).
            maximum: 2000
            minimum: 1
            title: Limit
            type: integer
        - description: >-
            Sort field for a full scan. Ignored when
            `synced_since`/`deleted_since` is set (those feeds always order by
            their own cursor).
          in: query
          name: order_by
          required: false
          schema:
            $ref: '#/components/schemas/OrderBy'
            default: id
            description: >-
              Sort field for a full scan. Ignored when
              `synced_since`/`deleted_since` is set (those feeds always order by
              their own cursor).
        - description: Sort direction for `order_by`.
          in: query
          name: direction
          required: false
          schema:
            $ref: '#/components/schemas/Direction'
            default: asc
            description: Sort direction for `order_by`.
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PaginatedResponse_TableAsset_'
          description: Successful Response
        '400':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: Invalid cursor or request parameters.
        '401':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: Authentication is required.
        '403':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: The token does not have permission to access the resource.
        '404':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: The requested resource was not found.
        '422':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: Request validation failed.
        '429':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: Rate limit exceeded.
          headers:
            RateLimit-Limit:
              description: Maximum requests allowed in the current window.
              schema:
                type: integer
            RateLimit-Remaining:
              description: Requests remaining in the current window.
              schema:
                type: integer
            RateLimit-Reset:
              description: Seconds until the current rate-limit window resets.
              schema:
                type: integer
            Retry-After:
              description: Seconds to wait before retrying.
              schema:
                type: integer
        '500':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ApiErrorResponse'
          description: An unexpected server error occurred.
components:
  schemas:
    OrderBy:
      enum:
        - id
        - synced_at
      title: OrderBy
      type: string
    Direction:
      enum:
        - asc
        - desc
      title: Direction
      type: string
    PaginatedResponse_TableAsset_:
      properties:
        has_more:
          default: false
          description: >-
            The only signal to continue pagination; a short page may still have
            more items because permission filtering can trim rows.
          title: Has More
          type: boolean
        items:
          description: Objects returned in the current page.
          items:
            $ref: '#/components/schemas/TableAsset'
          title: Items
          type: array
        next_cursor:
          anyOf:
            - type: string
            - type: 'null'
          description: >-
            Opaque cursor for the next page, valid only with identical query
            parameters.
          title: Next Cursor
      required:
        - items
      title: PaginatedResponse[TableAsset]
      type: object
    ApiErrorResponse:
      properties:
        error:
          $ref: '#/components/schemas/ApiError'
          description: Structured details about the error.
      required:
        - error
      title: ApiErrorResponse
      type: object
    TableAsset:
      properties:
        created_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: When the asset was created in the source platform, when available.
          title: Created At
        data_platform:
          description: >-
            Extensible enum. Data platform name. New values may be added over
            time.
          examples:
            - snowflake
            - bigquery
            - databricks
            - redshift
            - postgres
          title: Data Platform
          type: string
        db_name:
          description: Database (catalog) name.
          title: Db Name
          type: string
        deleted_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: Soft-delete timestamp. Present only in the `deleted_since` feed.
          title: Deleted At
        description:
          anyOf:
            - type: string
            - type: 'null'
          description: Description from the source platform.
          title: Description
        id:
          description: Unique asset identifier.
          title: Id
          type: string
        kind:
          description: >-
            Extensible enum. High-level asset category; picks the typed endpoint
            that exposes this asset's extra fields (`/assets/tables` for
            `table`, `/assets/bi` for `bi`). New values may be added over time —
            treat any unrecognized value as `other` and do not hard-fail.
          examples:
            - table
            - bi
            - semantic
            - etl
            - other
          title: Kind
          type: string
        materialization:
          description: >-
            Extensible enum. Materialization strategy. New values may be added
            over time.
          examples:
            - table
            - view
            - incremental
            - ephemeral
          title: Materialization
          type: string
        name:
          description: Asset name.
          title: Name
          type: string
        owners:
          default: []
          description: Owners assigned to the asset.
          items:
            type: string
          title: Owners
          type: array
        parent_id:
          anyOf:
            - type: string
            - type: 'null'
          description: ID of the parent asset (e.g. a BI dashboard containing this page).
          title: Parent Id
        path:
          anyOf:
            - type: string
            - type: 'null'
          description: Logical path of the asset in its project tree.
          title: Path
        schema_name:
          description: Schema name.
          title: Schema Name
          type: string
        source_type:
          description: >-
            Extensible enum. Integration that synced this asset. New values may
            be added over time.
          examples:
            - dbt
            - looker
            - sigma
            - fivetran
            - tableau
          title: Source Type
          type: string
        synced_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: >-
            When Elementary last synced this asset. Use with `synced_since` for
            incremental reads.
          title: Synced At
        table_name:
          description: Table or view name.
          title: Table Name
          type: string
        tags:
          default: []
          description: Tags assigned to the asset.
          items:
            type: string
          title: Tags
          type: array
        updated_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          description: When the asset was updated in the source platform, when available.
          title: Updated At
      required:
        - id
        - name
        - kind
        - source_type
        - data_platform
        - db_name
        - schema_name
        - table_name
        - materialization
      title: TableAsset
      type: object
    ApiError:
      properties:
        code:
          description: Stable code identifying the type of error.
          title: Code
          type: string
        message:
          description: Human-readable explanation of the error.
          title: Message
          type: string
      required:
        - code
        - message
      title: ApiError
      type: object
  securitySchemes:
    bearerAuth:
      description: Personal or account token.
      scheme: bearer
      type: http

````