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:
- Follow the instructions in
Import a CSV file
or
Import a SQL file.
The operation ID is returned in the
name
field of the response. - Make an
operations.list
call on the AlloyDB cluster.
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
- Learn how to import a CSV file.
- Learn how to import a SQL file.