Cancel an import operation

This page describes how to cancel an AlloyDB for PostgreSQL import operation for CSV files and SQL files.

Before you begin

To cancel the import of data, find the ID of the import operation that you want to cancel. To find the ID, do one of the following:

Cancel the import operation

You can use the Google Cloud CLI or REST API commands to cancel an import operation.

gcloud

Use the gcloud alloydb operations cancel command to cancel the operation:

gcloud alloydb operations cancel OPERATION_ID --region=REGION

Replace OPERATION_ID with the ID of the operation. For more information, see Before you begin.

REST v1

Use the following HTTP method and URL:

POST https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID:cancel

For more information, see cancel.

Before you use any of the request data, make the following replacements:

  • PROJECT_ID: the project ID.
  • REGION: the region in which the AlloyDB cluster is deployed.

  • OPERATION_ID: the ID of the import operation. For more information, see Before you begin.

    To send your request, expand one of these options:

    curl (Linux, macOS, or Cloud Shell)

    Save the request body in a file named request.json and execute the following command:

       curl -X POST \
         -H "Authorization: Bearer $(gcloud auth print-access-token)" \
         -H "Content-Type: application/json; charset=utf-8" \
         -d @request.json \
         "https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID:cancel"

    PowerShell (Windows)

    Save the request body in a file named request.json and execute the following command:

    $cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
  -Method POST `
  -Headers $headers `
  -ContentType: "application/json; charset=utf-8" `
  -InFile request.json `
  -Uri "https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID:cancel"| Select-Object -Expand Content

    You receive a JSON response similar to the following:

    This REST API call doesn't return any response. For more information about checking the cancellation status of the import, see Check the cancelled status.

Check the cancelled status

You can use the gcloud CLI or REST API commands to check the status of a cancelled import operation.

gcloud

Use the gcloud alloydb operations describe command to check the status of the cancelled operation.

gcloud alloydb operations describe OPERATION_ID --region=REGION

Replace the OPERATION_ID variable with the ID of the cancelled operation. For more information, see Before you begin.

REST v1

Run the following:

GET https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID

For more information, see get.

Before you use any of the request data, make the following replacements:

  • REGION: the region in which the AlloyDB cluster is deployed.
  • PROJECT_ID: the project ID.
  • OPERATION_ID: the ID of the import operation. For more information, see Before you begin.

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

  curl -X GET \
       -H "Authorization: Bearer $(gcloud auth print-access-token)" \
       -H "Content-Type: application/json; charset=utf-8" \
       -d @request.json \
  POST https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
  -Method GET `
  -Headers $headers `
  -Uri "https://alloydb.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/operations/OPERATION_ID" | Select-Object -Expand Content

You receive a JSON response similar to the following:

If successful, the response body contains an instance of Operation.

What's next