1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Public API
      1. Public API v2
        1. Create External Schema
        2. Extract to External Table
        3. Append to External Table
        4. Delete External Table
        5. Delete External Schema
        6. List Catalog Content
        7. List Catalog Folder Content
        8. Search Catalog Content
        9. Get SQLi Connectiont
        10. Schedule Dashboard Report
        11. Dashboard Prompts
        12. Insight Query
        13. Execute Load Plan
        14. Load Plan Execution Status
        15. Query a Business View
        16. Load Schema
        17. Schema Status
        18. List Schemas
        19. List Schema Objects
        20. Reset Passwords
        21. Transfer Ownership
    7. Security
    8. SQL Interface
    9. Visualizations
    10. Other
  8. Integrations
  9. Data applications
  10. Releases

Public API v2 → Delete External Table Endpoint

About the /extraction/table/{table} endpoint

The /extraction/table/{table} endpoint removes the definition of the specified external table from the Spark Metastore.

Note
  • Deleting external tables only removes their definition from the Spark Maetastore. You must delete the respective Parquet files manually from the related paths.
  • You must first remove the definition of all external tables in a schema before trying to delete it.

Only the Super admin user (and users with the SuperRole when the Super User Mode is enabled) can use this endpoint.

For information about how to get started with Public API v2, refer to References → Public API v2.

Note

Use the HTTPS or HTTP scheme according to your installation. You must use the HTTPS scheme to successfully run the API endpoints on Cloud installations.

Request URL

https://<cluster_URL>/incorta/api/v2/{tenant}/extraction/table/{table}

Examples:

  • https://mycluster.incorta.com/incorta/api/v2/default/extraction/table/externalTable1
  • https://10.1.2.3:8080/incorta/api/v2/default/extraction/table/externalTable1

Request URL Parameters

ParameterDescriptionTypeRequired
tenantThe tenant name (case-sensitive)StringRequired
tableThe fully qualified name of the external table you want to delete in the following format: external_schema.external_table.StringRequired

HTTP method

DELETE

Request headers

{
"Content-Type": "application/json",
"Accept": "application/json",
"Authorization": "Bearer {access_token}"
}

You must use a valid access token for the Super admin user (or a user with the SuperRole if the Super User Mode is enabled). For information about creating an access token, refer to Public API v2 → Create an API access token.

Endpoint response

The following table shows the HTTP response status codes for this endpoint.

CodeDescriptionPayload Response
200OK The endpoint successfully ran and deleted the external table.
400Bad Request
You provided invalid values.		{"message": "string"}
401Unauthenticated
The endpoint couldn’t run successfully due to authentication errors, such as an invalid or expired access token.		{"message": "string"}
Example:
{"message": "INC_09030108: Invalid authentication header. Invalid Token [abcd1234]"}
404Not Found
The tenant doesn't exist or is disabled.		{"message": "string"}
Example:
{"message": "Invalid [DEFAULT] tenant in resource path"}
500Internal Server Error
The endpoint couldn’t run successfully due to a server error.		{"message": "string"}
Example:
{"message": "The target table name should have schema specified"}