comments update

emar-kar · Oct 15, 2019 · Aug 9, 2019 · Aug 9, 2019 · Aug 9, 2019 · Aug 12, 2019
commit 6d533b30b9800ef85411a78b8e6f16c8a69b5435
diff --git a/bigquery/samples/add_empty_column.py b/bigquery/samples/add_empty_column.py
@@ -25,14 +25,14 @@ def add_empty_column(client, table_id):
     #                  to add an empty column.
     # table_id = "your-project.your_dataset.your_table_name"
 
-    table = client.get_table(table_id)  # Make an API request.
+    table = client.get_table(table_id)  # Makes an API request.
 
     original_schema = table.schema
     new_schema = original_schema[:]  # Creates a copy of the schema.
     new_schema.append(bigquery.SchemaField("phone", "STRING"))
 
     table.schema = new_schema
-    table = client.update_table(table, ["schema"])  # Make an API request.
+    table = client.update_table(table, ["schema"])  # Makes an API request.
 
     if len(table.schema) == len(original_schema) + 1 == len(new_schema):
         print("A new column has been added.")

diff --git a/bigquery/samples/browse_table_data.py b/bigquery/samples/browse_table_data.py
@@ -26,7 +26,7 @@ def browse_table_data(client, table_id):
     # table_id = "your-project.your_dataset.your_table_name"
 
     # Download all rows from a table.
-    rows_iter = client.list_rows(table_id)  # Make an API request.
+    rows_iter = client.list_rows(table_id)  # Makes an API request.
 
     # Iterate over rows to make the API requests to fetch row data.
     rows = list(rows_iter)
@@ -38,7 +38,7 @@ def browse_table_data(client, table_id):
     print("Downloaded {} rows from table {}".format(len(rows), table_id))
 
     # Specify selected fields to limit the results to certain columns.
-    table = client.get_table(table_id)  # Make an API request.
+    table = client.get_table(table_id)  # Makes an API request.
     fields = table.schema[:2]  # First two columns.
     rows_iter = client.list_rows(table_id, selected_fields=fields, max_results=10)
     rows = list(rows_iter)

diff --git a/bigquery/samples/client_query.py b/bigquery/samples/client_query.py
@@ -32,7 +32,7 @@ def client_query(client):
     """
     query_job = client.query(
         query, location="US"  # Must match the destination dataset(s) location.
-    )  # Make an API request.
+    )  # Makes an API request.
 
     print("The query data:")
     for row in query_job:

diff --git a/bigquery/samples/create_dataset.py b/bigquery/samples/create_dataset.py
@@ -33,6 +33,6 @@ def create_dataset(client, dataset_id):
     # Send the dataset to the API for creation.
     # Raises google.api_core.exceptions.Conflict if the Dataset already
     # exists within the project.
-    dataset = client.create_dataset(dataset)  # Make an API request.
+    dataset = client.create_dataset(dataset)  # Makes an API request.
     print("Created dataset {}.{}".format(client.project, dataset.dataset_id))
     # [END bigquery_create_dataset]
diff --git a/bigquery/samples/create_job.py b/bigquery/samples/create_job.py
@@ -33,7 +33,7 @@ def create_job(client):
         # The client libraries automatically generate a job ID. Override the
         # generated ID with either the job_id_prefix or job_id parameters.
         job_id_prefix="code_sample_",
-    )  # Make an API request.
+    )  # Makes an API request.
 
     print("Started job: {}".format(query_job.job_id))
     # [END bigquery_create_job]

diff --git a/bigquery/samples/create_routine.py b/bigquery/samples/create_routine.py
@@ -40,7 +40,7 @@ def create_routine(client, routine_id):
         ],
     )
 
-    routine = client.create_routine(routine)  # Make an API request.
+    routine = client.create_routine(routine)  # Makes an API request.
 
     print("Created routine {}".format(routine.reference))
     # [END bigquery_create_routine]

diff --git a/bigquery/samples/create_routine_ddl.py b/bigquery/samples/create_routine_ddl.py
@@ -34,7 +34,7 @@ def create_routine_ddl(client, routine_id):
     """.format(
         routine_id
     )
-    query_job = client.query(sql)  # Make an API request.
+    query_job = client.query(sql)  # Makes an API request.
     query_job.result()  # Waits for the job to complete.
 
     print("Created routine {}".format(query_job.ddl_target_routine))

diff --git a/bigquery/samples/create_table.py b/bigquery/samples/create_table.py
@@ -30,7 +30,7 @@ def create_table(client, table_id):
     ]
 
     table = bigquery.Table(table_id, schema=schema)
-    table = client.create_table(table)  # Make an API request.
+    table = client.create_table(table)  # Makes an API request.
     print(
         "Created table {}.{}.{}".format(table.project, table.dataset_id, table.table_id)
     )

diff --git a/bigquery/samples/dataset_exists.py b/bigquery/samples/dataset_exists.py
@@ -22,7 +22,7 @@ def dataset_exists(client, dataset_id):
     # dataset_id = "your-project.your_dataset"
 
     try:
-        client.get_dataset(dataset_id)  # Make an API request.
+        client.get_dataset(dataset_id)  # Makes an API request.
         print("Dataset {} already exists".format(dataset_id))
     except NotFound:
         print("Dataset {} is not found".format(dataset_id))

diff --git a/bigquery/samples/delete_dataset.py b/bigquery/samples/delete_dataset.py
@@ -29,7 +29,7 @@ def delete_dataset(client, dataset_id):
     # Use the not_found_ok parameter to not receive an error if the dataset has already been deleted.
     client.delete_dataset(
         dataset_id, delete_contents=True, not_found_ok=True
-    )  # Make an API request.
+    )  # Makes an API request.
 
     print("Deleted dataset '{}'.".format(dataset_id))
     # [END bigquery_delete_dataset]
diff --git a/bigquery/samples/delete_dataset_labels.py b/bigquery/samples/delete_dataset_labels.py
@@ -25,12 +25,12 @@ def delete_dataset_labels(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = "your-project.your_dataset"
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
 
     # To delete a label from a dataset, set its value to None.
     dataset.labels["color"] = None
 
-    dataset = client.update_dataset(dataset, ["labels"])  # Make an API request.
+    dataset = client.update_dataset(dataset, ["labels"])  # Makes an API request.
     print("Labels deleted from {}".format(dataset_id))
     # [END bigquery_delete_label_dataset]
     return dataset
diff --git a/bigquery/samples/delete_model.py b/bigquery/samples/delete_model.py
@@ -26,7 +26,7 @@ def delete_model(client, model_id):
     # TODO(developer): Set model_id to the ID of the model to fetch.
     # model_id = 'your-project.your_dataset.your_model'
 
-    client.delete_model(model_id)  # Make an API request.
+    client.delete_model(model_id)  # Makes an API request.
 
     print("Deleted model '{}'.".format(model_id))
     # [END bigquery_delete_model]
diff --git a/bigquery/samples/delete_routine.py b/bigquery/samples/delete_routine.py
@@ -25,7 +25,7 @@ def delete_routine(client, routine_id):
     # TODO(developer): Set the fully-qualified ID for the routine.
     # routine_id = "my-project.my_dataset.my_routine"
 
-    client.delete_routine(routine_id)  # Make an API request.
+    client.delete_routine(routine_id)  # Makes an API request.
 
     print("Deleted routine {}.".format(routine_id))
     # [END bigquery_delete_routine]
diff --git a/bigquery/samples/delete_table.py b/bigquery/samples/delete_table.py
@@ -27,6 +27,6 @@ def delete_table(client, table_id):
 
     # If the table does not exist, delete_table raises
     # google.api_core.exceptions.NotFound unless not_found_ok is True.
-    client.delete_table(table_id, not_found_ok=True)  # Make an API request.
+    client.delete_table(table_id, not_found_ok=True)  # Makes an API request.
     print("Deleted table '{}'.".format(table_id))
     # [END bigquery_delete_table]
diff --git a/bigquery/samples/get_dataset.py b/bigquery/samples/get_dataset.py
@@ -25,7 +25,7 @@ def get_dataset(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = 'your-project.your_dataset'
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
 
     full_dataset_id = "{}.{}".format(dataset.project, dataset.dataset_id)
     friendly_name = dataset.friendly_name

diff --git a/bigquery/samples/get_dataset_labels.py b/bigquery/samples/get_dataset_labels.py
@@ -25,7 +25,7 @@ def get_dataset_labels(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = "your-project.your_dataset"
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
 
     # View dataset labels.
     print("Dataset ID: {}".format(dataset_id))

diff --git a/bigquery/samples/get_model.py b/bigquery/samples/get_model.py
@@ -26,7 +26,7 @@ def get_model(client, model_id):
     # TODO(developer): Set model_id to the ID of the model to fetch.
     # model_id = 'your-project.your_dataset.your_model'
 
-    model = client.get_model(model_id)  # Make an API request.
+    model = client.get_model(model_id)  # Makes an API request.
 
     full_model_id = "{}.{}.{}".format(model.project, model.dataset_id, model.model_id)
     friendly_name = model.friendly_name

diff --git a/bigquery/samples/get_routine.py b/bigquery/samples/get_routine.py
@@ -25,7 +25,7 @@ def get_routine(client, routine_id):
     # TODO(developer): Set the fully-qualified ID for the routine.
     # routine_id = "my-project.my_dataset.my_routine"
 
-    routine = client.get_routine(routine_id)  # Make an API request.
+    routine = client.get_routine(routine_id)  # Makes an API request.
 
     print("Routine '{}':".format(routine.reference))
     print("\tType: '{}'".format(routine.type_))

diff --git a/bigquery/samples/get_table.py b/bigquery/samples/get_table.py
@@ -25,7 +25,7 @@ def get_table(client, table_id):
     # TODO(developer): Set table_id to the ID of the model to fetch.
     # table_id = 'your-project.your_dataset.your_table'
 
-    table = client.get_table(table_id)  # Make an API request.
+    table = client.get_table(table_id)  # Makes an API request.
 
     # View table properties
     print(

diff --git a/bigquery/samples/label_dataset.py b/bigquery/samples/label_dataset.py
@@ -25,9 +25,9 @@ def label_dataset(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = "your-project.your_dataset"
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
     dataset.labels = {"color": "green"}
-    dataset = client.update_dataset(dataset, ["labels"])  # Make an API request.
+    dataset = client.update_dataset(dataset, ["labels"])  # Makes an API request.
 
     print("Labels added to {}".format(dataset_id))
     # [END bigquery_label_dataset]
diff --git a/bigquery/samples/list_datasets.py b/bigquery/samples/list_datasets.py
@@ -22,7 +22,7 @@ def list_datasets(client):
     # TODO(developer): Construct a BigQuery client object.
     # client = bigquery.Client()
 
-    datasets = list(client.list_datasets())  # Make an API request.
+    datasets = list(client.list_datasets())  # Makes an API request.
     project = client.project
 
     if datasets:

diff --git a/bigquery/samples/list_datasets_by_label.py b/bigquery/samples/list_datasets_by_label.py
@@ -23,7 +23,7 @@ def list_datasets_by_label(client):
     # client = bigquery.Client()
 
     label_filter = "labels.color:green"
-    datasets = list(client.list_datasets(filter=label_filter))  # Make an API request.
+    datasets = list(client.list_datasets(filter=label_filter))  # Makes an API request.
 
     if datasets:
         print("Datasets filtered by {}:".format(label_filter))

diff --git a/bigquery/samples/list_models.py b/bigquery/samples/list_models.py
@@ -27,7 +27,7 @@ def list_models(client, dataset_id):
     #                  the models you are listing.
     # dataset_id = 'your-project.your_dataset'
 
-    models = client.list_models(dataset_id)  # Make an API request.
+    models = client.list_models(dataset_id)  # Makes an API request.
 
     print("Models contained in '{}':".format(dataset_id))
     for model in models:

diff --git a/bigquery/samples/list_routines.py b/bigquery/samples/list_routines.py
@@ -26,7 +26,7 @@ def list_routines(client, dataset_id):
     #                  the routines you are listing.
     # dataset_id = 'your-project.your_dataset'
 
-    routines = client.list_routines(dataset_id)  # Make an API request.
+    routines = client.list_routines(dataset_id)  # Makes an API request.
 
     print("Routines contained in dataset {}:".format(dataset_id))
     for routine in routines:

diff --git a/bigquery/samples/list_tables.py b/bigquery/samples/list_tables.py
@@ -26,7 +26,7 @@ def list_tables(client, dataset_id):
     #                  the tables you are listing.
     # dataset_id = 'your-project.your_dataset'
 
-    tables = client.list_tables(dataset_id)  # Make an API request.
+    tables = client.list_tables(dataset_id)  # Makes an API request.
 
     print("Tables contained in '{}':".format(dataset_id))
     for table in tables:

diff --git a/bigquery/samples/load_table_dataframe.py b/bigquery/samples/load_table_dataframe.py
@@ -65,10 +65,10 @@ def load_table_dataframe(client, table_id):
         table_id,
         job_config=job_config,
         location="US",  # Must match the destination dataset location.
-    )  # Make an API request.
+    )  # Makes an API request.
     job.result()  # Waits for the job to complete.
 
-    table = client.get_table(table_id)  # Make an API request.
+    table = client.get_table(table_id)  # Makes an API request.
     print(
         "Loaded {} rows and {} columns to {}".format(
             table.num_rows, len(table.schema), table_id

diff --git a/bigquery/samples/query_to_arrow.py b/bigquery/samples/query_to_arrow.py
@@ -41,7 +41,7 @@ def query_to_arrow(client):
     CROSS JOIN UNNEST(r.participants) as participant;
     """
     query_job = client.query(sql)
-    arrow_table = query_job.to_arrow()  # Make an API request.
+    arrow_table = query_job.to_arrow()  # Makes an API request.
 
     print(
         "Downloaded {} rows, {} columns.".format(

diff --git a/bigquery/samples/table_exists.py b/bigquery/samples/table_exists.py
@@ -22,7 +22,7 @@ def table_exists(client, table_id):
     # table_id = "your-project.your_dataset.your_table"
 
     try:
-        client.get_table(table_id)  # Make an API request.
+        client.get_table(table_id)  # Makes an API request.
         print("Table {} already exists.".format(table_id))
     except NotFound:
         print("Table {} is not found.".format(table_id))

diff --git a/bigquery/samples/table_insert_rows.py b/bigquery/samples/table_insert_rows.py
@@ -25,10 +25,10 @@ def table_insert_rows(client, table_id):
     # TODO(developer): Set table_id to the ID of the model to fetch.
     # table_id = "your-project.your_dataset.your_table"
 
-    table = client.get_table(table_id)  # Make an API request.
+    table = client.get_table(table_id)  # Makes an API request.
     rows_to_insert = [(u"Phred Phlyntstone", 32), (u"Wylma Phlyntstone", 29)]
 
-    errors = client.insert_rows(table, rows_to_insert)  # Make an API request.
+    errors = client.insert_rows(table, rows_to_insert)  # Makes an API request.
     if errors == []:
         print("New rows have been added.")
     # [END bigquery_table_insert_rows]
diff --git a/bigquery/samples/update_dataset_access.py b/bigquery/samples/update_dataset_access.py
@@ -24,7 +24,7 @@ def update_dataset_access(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = 'your-project.your_dataset'
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
 
     entry = bigquery.AccessEntry(
         role="READER",
@@ -36,7 +36,7 @@ def update_dataset_access(client, dataset_id):
     entries.append(entry)
     dataset.access_entries = entries
 
-    dataset = client.update_dataset(dataset, ["access_entries"])  # Make an API request.
+    dataset = client.update_dataset(dataset, ["access_entries"])  # Makes an API request.
 
     full_dataset_id = "{}.{}".format(dataset.project, dataset.dataset_id)
     print(

diff --git a/bigquery/samples/update_dataset_default_table_expiration.py b/bigquery/samples/update_dataset_default_table_expiration.py
@@ -25,12 +25,12 @@ def update_dataset_default_table_expiration(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = 'your-project.your_dataset'
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
     dataset.default_table_expiration_ms = 24 * 60 * 60 * 1000  # In milliseconds.
 
     dataset = client.update_dataset(
         dataset, ["default_table_expiration_ms"]
-    )  # Make an API request.
+    )  # Makes an API request.
 
     full_dataset_id = "{}.{}".format(dataset.project, dataset.dataset_id)
     print(

diff --git a/bigquery/samples/update_dataset_description.py b/bigquery/samples/update_dataset_description.py
@@ -25,9 +25,9 @@ def update_dataset_description(client, dataset_id):
     # TODO(developer): Set dataset_id to the ID of the dataset to fetch.
     # dataset_id = 'your-project.your_dataset'
 
-    dataset = client.get_dataset(dataset_id)  # Make an API request.
+    dataset = client.get_dataset(dataset_id)  # Makes an API request.
     dataset.description = "Updated description."
-    dataset = client.update_dataset(dataset, ["description"])  # Make an API request.
+    dataset = client.update_dataset(dataset, ["description"])  # Makes an API request.
 
     full_dataset_id = "{}.{}".format(dataset.project, dataset.dataset_id)
     print(

diff --git a/bigquery/samples/update_model.py b/bigquery/samples/update_model.py
@@ -26,9 +26,9 @@ def update_model(client, model_id):
     # TODO(developer): Set model_id to the ID of the model to fetch.
     # model_id = 'your-project.your_dataset.your_model'
 
-    model = client.get_model(model_id)  # Make an API request.
+    model = client.get_model(model_id)  # Makes an API request.
     model.description = "This model was modified from a Python program."
-    model = client.update_model(model, ["description"])  # Make an API request.
+    model = client.update_model(model, ["description"])  # Makes an API request.
 
     full_model_id = "{}.{}.{}".format(model.project, model.dataset_id, model.model_id)
     print(