Restore tables

POST /api/meta/entity/bulk#restoreTables

Restore one or more soft-deleted (archived) tables.

The restoration relies on matches being found for the provided qualifiedNames. If the this does not exactly match (case-sensitive) a soft-deleted table's qualifiedName, the request will fail.

Note that the guid is also required to avoid accidentally creating a new table. If the qualifiedName does not match an existing table, and no guid is supplied in the request, then this endpoint will create a new table with the provided details.

Body Required

List of tables to restore.

Responses

  • • 200 object

    Tables that were successfully restored (undeleted).

    • mutatedEntities object | null

      Tables that were restored.

      • UPDATE array[object]

        Instance of a table in Atlan, with its detailed response-specific information.

        • typeName string

          Should always be Table.

        • attributes object | null

          Attributes that can exist in table assets in Atlan.

        • classifications array[object] | null

          Instance of a classification in Atlan, with its detailed information.

          • typeName string

            Name of the classification. Note that this is the static-hashed unique name of the classification, not the human-readable displayName.

          • entityGuid string

            Unique identifier of the entity to which this classification is attached.

          • propagate boolean | null

            Whether to propagate this classification to other entities related to the entity to which the classification is attached.

          • removePropagationsOnEntityDelete boolean | null

            Whether to remove this classification from other entities to which it has been propagated when the classification is removed from this entity.

          • entityStatus string | null

            Status of the entity to which this classification is attached.

            Values are ACTIVE or DELETED.

        • displayText string | null

          Human-readable name of the entity.

        • guid string

          Unique identifier of the entity instance.

        • isIncomplete boolean | null

          Default value is false.

        • createdBy string | null

          Username of the user who created the object.

        • updatedBy string | null

          Username of the user who last updated the object.

        • createTime integer | null

          Time (epoch) at which this object was created, in milliseconds.

        • updateTime integer | null

          Time (epoch) at which this object was last updated, in milliseconds.

        • version integer | null

          Version of this object.

        • classificationNames array[string] | null

          List of classifications for this entity. Note that these are the internal hashed names used in Atlan, not the displayText of the classification.

        • labels array[string] | null

          Internal use only.

        • status string

          Status of the entity, either ACTIVE or DELETED.

          Values are ACTIVE or DELETED.

        • relationshipAttributes object | null

          Map of the relationships to this table.

          • links array[object] | null

            Details to use within an asset when referring to a link (resource).

          • readme object

            Details to use within an asset when referring to a readme.

            • typeName string

              Should always be Readme.

            • guid string | null

              Unique identifier of the related readme. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related readme. If the guid is not provided, these must be provided.

          • meanings array[object] | null

            Details to use within an asset when referring to a term.

            • typeName string

              Should always be AtlasnGlossaryTerm.

            • guid string | null

              Unique identifier of the related term. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related term. If the guid is not provided, these must be provided.

              • qualifiedName string

                Unique name of the related term. Note that in Atlan this unique name is a hashed value, not the name you see in the UI.

          • inputToProcesses array[object] | null

            Details to use within an asset when referring to a process.

            • typeName string

              Should either be Process or a subtype of Process.

              Values are Process, ColumnProcess, or BIProcess.

            • guid string | null

              Unique identifier of the related process. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related process. If the guid is not provided, these must be provided.

          • outputFromProcesses array[object] | null

            Details to use within an asset when referring to a process.

            • typeName string

              Should either be Process or a subtype of Process.

              Values are Process, ColumnProcess, or BIProcess.

            • guid string | null

              Unique identifier of the related process. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related process. If the guid is not provided, these must be provided.

          • atlanSchema object

            Details to use within an asset when referring to a schema.

            • typeName string

              Should always be Schema.

            • guid string | null

              Unique identifier of the related schema. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related schema. If the guid is not provided, these must be provided.

          • partitions array[object] | null

            Details to use within an asset when referring to a table partition.

            • typeName string

              Should always be TablePartition.

            • guid string | null

              Unique identifier of the related table partition. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related table partition. If the guid is not provided, these must be provided.

          • columns array[object] | null

            Details to use within an asset when referring to a column.

            • typeName string

              Should always be Column.

            • guid string | null

              Unique identifier of the related column. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related column. If the guid is not provided, these must be provided.

          • queries array[object] | null

            Details to use within an asset when referring to a query.

            • typeName string

              Should always be Query.

            • guid string | null

              Unique identifier of the related query. If the uniqueAttributes are not provided, this must be provided.

            • uniqueAttributes object | null

              Attribute(s) that uniquely identify the related query. If the guid is not provided, these must be provided.

    • guidAssignments object

      Map of assigned unique identifiers for any created tables (should be empty for restored tables).

  • • 404 object

    Table could not be found by the qualifiedName or guid provided.

    • errorCode string

      Unique code for the type of error that occurred.

    • errorMessage string

      Human-readable description of the error that occurred.

    • entityGuid string

      GUID that could not be found

POST /api/meta/entity/bulk#restoreTables 
curl \
 -X POST https://tenant.atlan.com/api/meta/entity/bulk#restoreTables \
 -H "Authorization: Bearer $ACCESS_TOKEN" \
 -H "Content-Type: application/json" \
 -d '{"entities":[{"typeName":"Table","attributes":{"name":"customer","qualifiedName":"default/mongodb/mongodb.atlan.com/test_db/default/customer","connectorName":"mongodb","schemaName":"default","schemaQualifiedName":"default/mongodb/mongodb.atlan.com/test_db/default","databaseName":"test_db","databaseQualifiedName":"default/mongodb/mongodb.atlan.com/test_db","connectionQualifiedName":"default/mongodb/mongodb.atlan.com"},"relationshipAttributes":{"atlanSchema":{"typeName":"Schema","uniqueAttributes":{"qualifiedName":"default/mongodb/mongodb.atlan.com/test_db/default"}}},"guid":"dc14ffca-bf43-4731-b641-51408c4d892c","status":"ACTIVE"}]}'
Request example 
{
  "entities": [
    {
      "typeName": "Table",
      "attributes": {
        "name": "customer",
        "qualifiedName": "default/mongodb/mongodb.atlan.com/test_db/default/customer",
        "connectorName": "mongodb",
        "schemaName": "default",
        "schemaQualifiedName": "default/mongodb/mongodb.atlan.com/test_db/default",
        "databaseName": "test_db",
        "databaseQualifiedName": "default/mongodb/mongodb.atlan.com/test_db",
        "connectionQualifiedName": "default/mongodb/mongodb.atlan.com"
      },
      "relationshipAttributes": {
        "atlanSchema": {
          "typeName": "Schema",
          "uniqueAttributes": {
            "qualifiedName": "default/mongodb/mongodb.atlan.com/test_db/default"
          }
        }
      },
      "guid": "dc14ffca-bf43-4731-b641-51408c4d892c",
      "status": "ACTIVE"
    }
  ]
}
Response example (200) 
{
  "mutatedEntities": {
    "UPDATE": [
      {
        "typeName": "Table",
        "attributes": {
          "popularityScore": 1.17549435e-38,
          "sourceCreatedAt": 0,
          "viewerUsers": [],
          "viewScore": 1.17549435e-38,
          "lastSyncRunAt": 0,
          "adminGroups": [],
          "qualifiedName": "default/mongodb/mongodb.atlan.com/test_db/default/customer",
          "__hasLineage": false,
          "adminUsers": [],
          "ownerGroups\"": [],
          "isEditable": true,
          "sourceUpdatedAt": 0,
          "announcementUpdatedAt": 0,
          "name": "customer",
          "certificateUpdatedAt": 0,
          "connectorName": "mongodb",
          "schemaName": "default",
          "schemaQualifiedName": "default/mongodb/mongodb.atlan.com/test_db/default",
          "databaseName": "test_db",
          "databaseQualifiedName": "default/mongodb/mongodb.atlan.com/test_db",
          "connectionQualifiedName": "default/mongodb/mongodb.atlan.com",
          "isDiscoverable": true,
          "viewerGroups": [],
          "ownerUsers": []
        },
        "guid": "dc14ffca-bf43-4731-b641-51408c4d892c",
        "status": "ACTIVE",
        "displayText": "default",
        "classificationNames": [],
        "classifications": [],
        "meaningNames": [],
        "meanings": [],
        "isIncomplete": false,
        "labels": [],
        "createdBy": "service-account-apikey-bea1e1d1-e4e7-465e-8adf-7c61c227a59b",
        "updatedBy": "service-account-apikey-bea1e1d1-e4e7-465e-8adf-7c61c227a59b",
        "createTime": 1652795647900,
        "updateTime": 1652795647900
      }
    ]
  },
  "guidAssignments": {}
}
Response example (404) 
{
  "errorCode": "ATLAS-404-00-00A",
  "errorMessage": "Referenced entity dc14ffca-bf43-4731-b641-51408c4d892c is not found",
  "entityGuid": "dc14ffca-bf43-4731-b641-51408c4d892c"
}