Bigquery Script

This Python Scripts allow you to rename the table name of the dataset in Big Query

Installation

1. Make sure you have Python installed on your system.
2. Install the required libraries using pip:

   pip install google-cloud-bigquery
   

changetablename.py

This Python Scripts allow you to rename the table name of the dataset in Big Query

Usage

1. Replace the placeholder values in the script with your actual project ID, dataset ID, and any columns you want to remove.
2. Run the script. It will connect to your BigQuery project, list the tables in the specified dataset, and rename them according to the defined rules.
3. Optionally, review the console output to ensure tables are renamed correctly.

deletetables.py

Usage

This Python Scripts allow you to delete the tables from the dataset in Big Query

1. Replace the placeholder values in the script with your actual project ID, dataset ID.

newdataset.py

Usage

This Python script allows you to create a new dataset with modified tables from an existing dataset in BigQuery.

1. Replace the placeholder values in the script with your actual project ID, dataset ID and columns to remove