Cancel an import operation

To stop an in-progress CSV or SQL import and free up cluster resources, you can cancel the AlloyDB for PostgreSQL import operation using the Google Cloud CLI or the REST API.

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 the following:

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

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 operations.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

    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 following:

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

REST v1

Run the following:

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

For more information, see operations.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)" \
       "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

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

What's next