Stay organized with collections
Save and categorize content based on your preferences.
Permanently drop/delete a row range from a specified table. The request can specify whether to delete all rows in a table, or only those that match a particular prefix. Note that row key prefixes used here are treated as service data. For more information about how service data is handled, see the Google Cloud Privacy Notice.
HTTP request
POST https://bigtableadmin.googleapis.com/v2/{name=projects/*/instances/*/tables/*}:dropRowRange
Required. The unique name of the table on which to drop a range of rows. Values are of the form projects/{project}/instances/{instance}/tables/{table}.
Authorization requires the following IAM permission on the specified resource name:
bigtable.tables.mutateRows
Request body
The request body contains data with the following structure:
JSON representation
{// Union field target can be only one of the following:"rowKeyPrefix": string,"deleteAllDataFromTable": boolean// End of list of possible types for union field target.}
Fields
Union field target. Delete all rows or by prefix. target can be only one of the following:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-05-08 UTC."],[[["\u003cp\u003eThis operation permanently deletes a range of rows from a specified table in Google Cloud Bigtable.\u003c/p\u003e\n"],["\u003cp\u003eYou can choose to delete all rows within a table, or only those rows that start with a specific row key prefix.\u003c/p\u003e\n"],["\u003cp\u003eThe request URL requires the table's unique name in the format \u003ccode\u003eprojects/{project}/instances/{instance}/tables/{table}\u003c/code\u003e, and the operation needs the \u003ccode\u003ebigtable.tables.mutateRows\u003c/code\u003e IAM permission.\u003c/p\u003e\n"],["\u003cp\u003eThe request body allows you to specify either a \u003ccode\u003erowKeyPrefix\u003c/code\u003e (base64-encoded string) or \u003ccode\u003edeleteAllDataFromTable\u003c/code\u003e (boolean) to define which rows are to be deleted.\u003c/p\u003e\n"],["\u003cp\u003eThe operation requires one of several OAuth scopes for authorization including \u003ccode\u003ehttps://www.googleapis.com/auth/bigtable.admin\u003c/code\u003e, \u003ccode\u003ehttps://www.googleapis.com/auth/cloud-platform\u003c/code\u003e, and others.\u003c/p\u003e\n"]]],[],null,["# Method: projects.instances.tables.dropRowRange\n\nPermanently drop/delete a row range from a specified table. The request can specify whether to delete all rows in a table, or only those that match a particular prefix. Note that row key prefixes used here are treated as service data. For more information about how service data is handled, see the [Google Cloud Privacy Notice](https://cloud.google.com/terms/cloud-privacy-notice).\n\n### HTTP request\n\n`POST https://bigtableadmin.googleapis.com/v2/{name=projects/*/instances/*/tables/*}:dropRowRange`\n\nThe URL uses [gRPC Transcoding](https://google.aip.dev/127) syntax.\n\n### Path parameters\n\n### Request body\n\nThe request body contains data with the following structure:\n\n### Response body\n\nIf successful, the response body is an empty JSON object.\n\n### Authorization scopes\n\nRequires one of the following OAuth scopes:\n\n- `https://www.googleapis.com/auth/bigtable.admin`\n- `https://www.googleapis.com/auth/bigtable.admin.table`\n- `https://www.googleapis.com/auth/cloud-bigtable.admin`\n- `https://www.googleapis.com/auth/cloud-bigtable.admin.table`\n- `https://www.googleapis.com/auth/cloud-platform`\n\nFor more information, see the [Authentication Overview](/docs/authentication#authorization-gcp)."]]