---
title: "Find Database assets"
method: GET
path: "/databases"
tags: ["Database"]
---

# Find Database assets

`GET /databases`

Finds Databases based on the provided criteria.

The response can include Databases whose underlying connection has been soft-deleted
in Collibra or removed from the data source. These are flagged with
`edgeConnectionStatus = DELETED` in the response.

Use the `edgeConnectionStatus` query parameter to filter them out (`ACTIVE`)
or to retrieve only the deleted ones (`DELETED`).

## Query parameters

- `parentSystemId` string, uuid
- `edgeConnectionId` string, uuid
- `databaseConnectionId` string, uuid
- `edgeConnectionStatus` string — Status of the connection used by a Database. Known values (additional values may be introduced in future API versions; clients should treat unknown values as opaque strings): - `ACTIVE`: the database connection and its parent Edge connection are both available. - `DELETED`: the database connection or its parent Edge connection has been soft-deleted in Collibra or removed from the data source.
- `offset` integer
- `limit` integer

## Response `200`

Databases successfully retrieved.

- DatabasePagedResponse
  - `results` Database[] — The list of results.
    - `provider` string, required — Value must be "Snowflake", "GoogleBigQuery, or "AWSLakeFormation"
    - `providerDetails` ProviderDetails — The provider specific details. For example, AWSLakeFormation contains the property awsRegion, which denotes in which region the database is located.
    - `id` string, required — The id of the database
    - `name` string, required — The name of the database
    - `schemas` DatabaseSchema[]
      - `id` string, required — The id of the database schema
      - `name` string, required — The name of the database schema
      - `tables` DatabaseTable[], required
        - `id` string, required — The id of the database table
        - `name` string, required — The name of the database table
        - `columns` DatabaseColumn[], required
          - `id` string, required — The id of the database column
          - `name` string, required — The name of the database column
          - `dataType` string — The data type as it is declared by the provider. For example: String, Integer, Varchar, Blob, Boolean, ...
          - `precision` integer — The precision of the column.
          - `scale` integer — The scale of the column.
          - `tags` DatabaseColumnTag[], required
            - `id` string, required — The id of database column tag
            - `name` string, required — The name of database column tag
          - `accesses` DatabaseColumnAccessRule[], required
            - `group` string, required — The name of protect group
            - `access` string, required — Possible values are: `Read` or `NoChange`.
            - `masking` union
              - …
            - `rowFilter` RowFilter
              - …
        - `accesses` DatabaseTableAccessRule[], required
          - `group` string, required — The name of protect group
          - `access` string, required — Possible values are: `Read` or `NoChange`.
    - `tags` DatabaseTag[], required
      - `id` string, required — The id of database tag
      - `name` string — The name of database tag
      - `maskings` GroupMasking[], required
        - `group` string, required — The name of protect group
        - `masking` union, required
          - NoMasking
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
          - DefaultMasking
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
          - ConstantMasking — This masked strategy is not supported by the Protect application therefore it is deprecated and it will be removed in new versions of the API. Use DefaultMasking instead.
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
            - `constant` string
          - HashMasking
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
          - ShowLastMasking
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
            - `numberOfCharacters` integer — The number of characters to display
          - CustomMasking
            - `type` string, required — Possible values are: `None`, `Default`, `Constant`, `Hash` or `ShowLast`.
            - `customMaskingId` string, uuid — The id of custom masking
            - `customMaskingName` string — The name of custom masking
    - `customMaskings` DatabaseCustomMasking[], required
      - `id` string, uuid — The id of database custom masking
      - `name` string — The name of database custom masking
      - `mappings` MaskingMappings[]
        - `dataType` string, required — The name of the data type (String, Number, Date ...). Data types name depend on the provider, a list of compatible types per provider is available in the documentation.
        - `functionName` string, required — The name of the function that will be used on the provider to provide the custom masking.

## Other responses

- `400` — The request is not valid.
- `401` — The client is not authenticated.
- `403` — The user lacks permissions.

---

[API](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api.md) · [All operations](https://skmtc.net/collibra/apis/collibra-data-governance-center-core-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/collibra/collibra-data-governance-center-core-api/revisions/6d091bc86a33/schema)