> [!WARNING]
>
> **Beta**
>
>
> This feature is
>
> subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the
> [Service Specific
> Terms](https://docs.cloud.google.com/terms/service-terms#1).
>
> Pre-GA features are available "as is" and might have limited support.
>
> For more information, see the
> [launch stage descriptions](https://cloud.google.com/products/#product-launch-stages).

This template is **deprecated** and will be removed in Q3 2023.
Please migrate to [Firestore Bulk Delete](https://docs.cloud.google.com/dataflow/docs/guides/templates/provided/firestore-bulk-delete) template.

The Datastore Bulk Delete template is a pipeline which reads in Entities from Datastore with a given GQL query and then deletes all matching Entities in the selected target project. The pipeline can optionally pass the JSON encoded Datastore Entities to your Javascript UDF, which you can use to filter out Entities by returning null values.

## Pipeline requirements

- Datastore must be set up in the project prior to running the template.
- If reading and deleting from separate Datastore instances, the Dataflow [Worker Service Account](https://docs.cloud.google.com/dataflow/docs/concepts/security-and-permissions#worker-service-account) must have permission to read from one instance and delete from the other.
- [Database writes](https://docs.cloud.google.com/datastore/docs/console/datastore-admin-console#enabling_datastore_writes) must be enabled on the Datastore instance.

## Template parameters

| Parameter | Description |
|---|---|
| `datastoreReadGqlQuery` | GQL query which specifies which entities to match for deletion. Using a keys-only query may improve performance. For example: "SELECT __key__ FROM MyKind". |
| `datastoreReadProjectId` | Project ID of the Datastore instance from which you want to read entities (using your GQL query) that are used for matching. |
| `datastoreDeleteProjectId` | Project ID of the Datastore instance from which to delete matching entities. This can be the same as `datastoreReadProjectId` if you want to read and delete within the same Datastore instance. |
| `datastoreReadNamespace` | (Optional) Namespace of requested Entities. Set as "" for default namespace. |
| `datastoreHintNumWorkers` | (Optional) Hint for the expected number of workers in the Datastore ramp-up throttling step. Default is `500`. |
| `javascriptTextTransformGcsPath` | (Optional) The Cloud Storage URI of the `.js` file that defines the JavaScript user-defined function (UDF) you want to use. For example, `gs://my-bucket/my-udfs/my_file.js`. |
| `javascriptTextTransformFunctionName` | (Optional) The name of the JavaScript user-defined function (UDF) that you want to use. For example, if your JavaScript function code is `myTransform(inJson) { /*...do stuff...*/ }`, then the function name is `myTransform`. For sample JavaScript UDFs, see [UDF Examples](https://github.com/GoogleCloudPlatform/DataflowTemplates#udf-examples). If this function returns a value of undefined or null for a given Datastore entity, then that entity is not deleted. |

## Run the template

### Console

1. Go to the Dataflow **Create job from template** page.
[Go to Create job from template](https://console.cloud.google.com/dataflow/createjob)
2. In the **Job name** field, enter a unique job name.
3. Optional: For **Regional endpoint** , select a value from the drop-down menu. The default region is `us-central1`.


   For a list of regions where you can run a Dataflow job, see
   [Dataflow locations](https://docs.cloud.google.com/dataflow/docs/resources/locations).
4. From the **Dataflow template** drop-down menu, select the **Bulk Delete Entities in Datastore** template.
5. In the provided parameter fields, enter your parameter values.
6. Click **Run job**.

### gcloud

> [!NOTE]
> **Note:** To use the Google Cloud CLI to run classic templates, you must have [Google Cloud CLI](https://docs.cloud.google.com/sdk/docs/install) version 138.0.0 or later.

In your shell or terminal, run the template:

```bash
gcloud dataflow jobs run JOB_NAME \
    --gcs-location gs://dataflow-templates/VERSION/Datastore_to_Datastore_Delete \
    --region REGION_NAME \
    --parameters \
datastoreReadGqlQuery="GQL_QUERY",\
datastoreReadProjectId=DATASTORE_READ_AND_DELETE_PROJECT_ID,\
datastoreDeleteProjectId=DATASTORE_READ_AND_DELETE_PROJECT_ID
```

Replace the following:

- `JOB_NAME`: a unique job name of your choice
- `REGION_NAME`: the [region](https://docs.cloud.google.com/dataflow/docs/resources/locations) where you want to deploy your Dataflow job---for example, `us-central1`
- `VERSION`: the version of the template that you want to use

  You can use the following values:
  - `latest` to use the latest version of the template, which is available in the **non-dated** parent folder in the bucket--- [gs://dataflow-templates/latest/](https://console.cloud.google.com/storage/browser/dataflow-templates/latest)
  - the version name, like `2023-09-12-00_RC00`, to use a specific version of the template, which can be found nested in the respective dated parent folder in the bucket--- [gs://dataflow-templates/](https://console.cloud.google.com/storage/browser/dataflow-templates)

  > [!CAUTION]
  > **Caution:** The **latest** version of templates might update with breaking changes. Your production environments should use templates kept in the most recent **dated** parent folder to prevent these breaking changes from affecting your production workflows.

- `GQL_QUERY`: the query you'll use to match entities for deletion
- `DATASTORE_READ_AND_DELETE_PROJECT_ID`: your Datastore instance project ID. This example both reads and deletes from the same Datastore instance.

### API

To run the template using the REST API, send an HTTP POST request. For more information on the
API and its authorization scopes, see
[`projects.templates.launch`](https://docs.cloud.google.com/dataflow/docs/reference/rest/v1b3/projects.templates/launch).

```json
POST https://dataflow.googleapis.com/v1b3/projects/PROJECT_ID/locations/LOCATION/templates:launch?gcsPath=gs://dataflow-templates/VERSION/Datastore_to_Datastore_Delete
{
   "jobName": "JOB_NAME",
   "parameters": {
       "datastoreReadGqlQuery": "GQL_QUERY",
       "datastoreReadProjectId": "DATASTORE_READ_AND_DELETE_PROJECT_ID",
       "datastoreDeleteProjectId": "DATASTORE_READ_AND_DELETE_PROJECT_ID"
   },
   "environment": { "zone": "us-central1-f" }
   }
}
```

Replace the following:

- `PROJECT_ID`: the Google Cloud project ID where you want to run the Dataflow job
- `JOB_NAME`: a unique job name of your choice
- `LOCATION`: the [region](https://docs.cloud.google.com/dataflow/docs/resources/locations) where you want to deploy your Dataflow job---for example, `us-central1`
- `VERSION`: the version of the template that you want to use

  You can use the following values:
  - `latest` to use the latest version of the template, which is available in the **non-dated** parent folder in the bucket--- [gs://dataflow-templates/latest/](https://console.cloud.google.com/storage/browser/dataflow-templates/latest)
  - the version name, like `2023-09-12-00_RC00`, to use a specific version of the template, which can be found nested in the respective dated parent folder in the bucket--- [gs://dataflow-templates/](https://console.cloud.google.com/storage/browser/dataflow-templates)

  > [!CAUTION]
  > **Caution:** The **latest** version of templates might update with breaking changes. Your production environments should use templates kept in the most recent **dated** parent folder to prevent these breaking changes from affecting your production workflows.

- `GQL_QUERY`: the query you'll use to match entities for deletion
- `DATASTORE_READ_AND_DELETE_PROJECT_ID`: your Datastore instance project ID. This example both reads and deletes from the same Datastore instance.

## Template source code

### Java

    /*
     * Copyright (C) 2018 Google LLC
     *
     * Licensed under the Apache License, Version 2.0 (the "License"); you may not
     * use this file except in compliance with the License. You may obtain a copy of
     * the License at
     *
     *   http://www.apache.org/licenses/LICENSE-2.0
     *
     * Unless required by applicable law or agreed to in writing, software
     * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
     * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
     * License for the specific language governing permissions and limitations under
     * the License.
     */
    package com.google.cloud.teleport.templates;

    import com.google.cloud.teleport.metadata.Template;
    import com.google.cloud.teleport.metadata.TemplateCategory;
    import com.google.cloud.teleport.templates.DatastoreToDatastoreDelete.DatastoreToDatastoreDeleteOptions;
    import com.google.cloud.teleport.templates.common.DatastoreConverters.DatastoreDeleteEntityJson;
    import com.google.cloud.teleport.templates.common.DatastoreConverters.DatastoreDeleteOptions;
    import com.google.cloud.teleport.templates.common.DatastoreConverters.DatastoreReadOptions;
    import com.google.cloud.teleport.templates.common.DatastoreConverters.ReadJsonEntities;
    import com.google.cloud.teleport.templates.common.FirestoreNestedValueProvider;
    import com.google.cloud.teleport.templates.common.JavascriptTextTransformer.JavascriptTextTransformerOptions;
    import com.google.cloud.teleport.templates.common.JavascriptTextTransformer.TransformTextViaJavascript;
    import org.apache.beam.sdk.Pipeline;
    import org.apache.beam.sdk.options.PipelineOptions;
    import org.apache.beam.sdk.options.PipelineOptionsFactory;
    import org.apache.beam.sdk.options.ValueProvider;

    /**
     * Dataflow template which deletes pulled Datastore Entities.
     *
     * <p>Check out <a
     * href="https://github.com/GoogleCloudPlatform/DataflowTemplates/blob/main/v1/README_Datastore_to_Datastore_Delete.md">README
     * Datastore</a> or <a
     * href="https://github.com/GoogleCloudPlatform/DataflowTemplates/blob/main/v1/README_Firestore_to_Firestore_Delete.md">README
     * Firestore</a> for instructions on how to use or modify this template.
     */
    @Template(
        name = "Datastore_to_Datastore_Delete",
        category = TemplateCategory.LEGACY,
        displayName = "Bulk Delete Entities in Datastore [Deprecated]",
        description =
            "A pipeline which reads in Entities (via a GQL query) from Datastore, optionally passes in the JSON encoded "
                + "Entities to a JavaScript UDF, and then deletes all matching Entities in the selected target project.",
        optionsClass = DatastoreToDatastoreDeleteOptions.class,
        skipOptions = {
          "firestoreReadGqlQuery",
          "firestoreReadProjectId",
          "firestoreReadNamespace",
          "firestoreDeleteProjectId",
          "firestoreHintNumWorkers",
          "javascriptTextTransformReloadIntervalMinutes"
        },
        documentation =
            "https://cloud.google.com/dataflow/docs/guides/templates/provided/datastore-bulk-delete",
        contactInformation = "https://cloud.google.com/support",
        requirements = {
          "Datastore must be set up in the project prior to running the template.",
          "If reading and deleting from separate Datastore instances, the Dataflow <a href=\"https://cloud.google.com/dataflow/docs/concepts/security-and-permissions#worker-service-account\">Worker Service Account</a> must have permission to read from one instance and delete from the other."
        })
    @Template(
        name = "Firestore_to_Firestore_Delete",
        category = TemplateCategory.UTILITIES,
        displayName = "Bulk Delete Entities in Firestore (Datastore mode)",
        description =
            "A pipeline which reads in Entities (via a GQL query) from Firestore, optionally passes in the JSON encoded "
                + "Entities to a JavaScript UDF, and then deletes all matching Entities in the selected target project.",
        optionsClass = DatastoreToDatastoreDeleteOptions.class,
        optionsOrder = {
          DatastoreReadOptions.class,
          DatastoreDeleteOptions.class,
          JavascriptTextTransformerOptions.class
        },
        skipOptions = {
          "datastoreReadGqlQuery",
          "datastoreReadProjectId",
          "datastoreReadNamespace",
          "datastoreDeleteProjectId",
          "datastoreHintNumWorkers",
          "javascriptTextTransformReloadIntervalMinutes"
        },
        documentation =
            "https://cloud.google.com/dataflow/docs/guides/templates/provided/firestore-bulk-delete",
        contactInformation = "https://cloud.google.com/support",
        requirements = {
          "Firestore must be set up in the project prior to running the template.",
          "If reading and deleting from separate Firestore instances, the Dataflow <a href=\"https://cloud.google.com/dataflow/docs/concepts/security-and-permissions#worker-service-account\">Worker Service Account</a> must have permission to read from one instance and delete from the other."
        })
    public class DatastoreToDatastoreDelete {

      public static <T> ValueProvider<T> selectProvidedInput(
          ValueProvider<T> datastoreInput, ValueProvider<T> firestoreInput) {
        return new FirestoreNestedValueProvider<T>(datastoreInput, firestoreInput);
      }

      /** Custom PipelineOptions. */
      public interface DatastoreToDatastoreDeleteOptions
          extends PipelineOptions,
              DatastoreReadOptions,
              JavascriptTextTransformerOptions,
              DatastoreDeleteOptions {}

      /**
       * Runs a pipeline which reads in Entities from datastore, passes in the JSON encoded Entities to
       * a Javascript UDF, and deletes all the Entities.
       *
       * <p>If the UDF returns value of undefined or null for a given Entity, then that Entity will not
       * be deleted.
       *
       * @param args arguments to the pipeline
       */
      public static void main(String[] args) {
        DatastoreToDatastoreDeleteOptions options =
            PipelineOptionsFactory.fromArgs(args)
                .withValidation()
                .as(DatastoreToDatastoreDeleteOptions.class);

        Pipeline pipeline = Pipeline.create(options);

        pipeline
            .apply(
                ReadJsonEntities.newBuilder()
                    .setGqlQuery(
                        selectProvidedInput(
                            options.getDatastoreReadGqlQuery(), options.getFirestoreReadGqlQuery()))
                    .setProjectId(
                        selectProvidedInput(
                            options.getDatastoreReadProjectId(), options.getFirestoreReadProjectId()))
                    .setNamespace(
                        selectProvidedInput(
                            options.getDatastoreReadNamespace(), options.getFirestoreReadNamespace()))
                    .build())
            .apply(
                TransformTextViaJavascript.newBuilder()
                    .setFileSystemPath(options.getJavascriptTextTransformGcsPath())
                    .setFunctionName(options.getJavascriptTextTransformFunctionName())
                    .build())
            .apply(
                DatastoreDeleteEntityJson.newBuilder()
                    .setProjectId(
                        selectProvidedInput(
                            options.getDatastoreDeleteProjectId(),
                            options.getFirestoreDeleteProjectId()))
                    .setHintNumWorkers(
                        selectProvidedInput(
                            options.getDatastoreHintNumWorkers(), options.getFirestoreHintNumWorkers()))
                    .build());

        pipeline.run();
      }
    }

## What's next

- Learn about [Dataflow templates](https://docs.cloud.google.com/dataflow/docs/concepts/dataflow-templates).
- See the list of [Google-provided templates](https://docs.cloud.google.com/dataflow/docs/guides/templates/provided-templates).

<br />

<br />