<commit_before># bq_ddl>: Managing Google BigQuery Datasets and Tables

**bq_ddl>** operator can be used to create, delete and clear Google BigQuery Datasets and Tables.

    _export:
      bq:
        dataset: my_dataset

    +prepare:
      bq_ddl>:
        create_datasets:
          - my_dataset_${session_date_compact}
        empty_datasets:
          - my_dataset_${session_date_compact}
        delete_datasets:
          - my_dataset_${last_session_date_compact}
        create_tables:
          - my_table_${session_date_compact}
        empty_tables:
          - my_table_${session_date_compact}
        delete_tables:
          - my_table_${last_session_date_compact}


## Secrets

* **gcp.credential**: CREDENTIAL

  See [gcp.credential](../bq.html#secrets).

## Options

* **create_datasets**: LIST

  Create new datasets.

  For detailed information about dataset configuration parameters, see the [Google BigQuery Datasets Documentation](https://cloud.google.com/bigquery/docs/reference/v2/datasets#resource).

  Examples:

  ```
  create_datasets:
    - foo
    - other_project:bar<commit_msg>correct indent of subcommand in example<commit_after># bq_ddl>: Managing Google BigQuery Datasets and Tables

**bq_ddl>** operator can be used to create, delete and clear Google BigQuery Datasets and Tables.

    _export:
      bq:
        dataset: my_dataset

    +prepare:
      bq_ddl>:
      create_datasets:
        - my_dataset_${session_date_compact}
      empty_datasets:
        - my_dataset_${session_date_compact}
      delete_datasets:
        - my_dataset_${last_session_date_compact}
      create_tables:
        - my_table_${session_date_compact}
      empty_tables:
        - my_table_${session_date_compact}
      delete_tables:
        - my_table_${last_session_date_compact}


## Secrets

* **gcp.credential**: CREDENTIAL

  See [gcp.credential](../bq.html#secrets).

## Options

* **create_datasets**: LIST

  Create new datasets.

  For detailed information about dataset configuration parameters, see the [Google BigQuery Datasets Documentation](https://cloud.google.com/bigquery/docs/reference/v2/datasets#resource).

  Examples:

  ```
  create_datasets:
    - foo
    - other_project:bar
{'fraction_non_alphanumeric': 0.09360936093609361, 'fraction_numerical': 0.0009000900090009, 'mean_word_length': 3.1473880597014925, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 9, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5306378', 'n_tokens_mistral': 715, 'n_tokens_neox': 684, 'n_words': 142}