docs: update query_external_sheets_permanent_table.py to use query_and_wait API (#1778)

SalemJorden · Salem Boyland · kiraksi · web-flow · commit a7be88adf8a4 · 2024-01-25T23:18:11.000-08:00
Co-authored-by: Salem Boyland &lt;salemb@google.com&gt;
Co-authored-by: Kira &lt;kirnendra@google.com&gt;
diff --git a/samples/query_external_sheets_permanent_table.py b/samples/query_external_sheets_permanent_table.py
@@ -69,10 +69,10 @@ def query_external_sheets_permanent_table(dataset_id: str) -> None:
     # Example query to find states starting with "W".
     sql = 'SELECT * FROM `{}.{}` WHERE name LIKE "W%"'.format(dataset_id, table_id)
 
-    query_job = client.query(sql)  # Make an API request.
+    results = client.query_and_wait(sql)  # Make an API request.
 
     # Wait for the query to complete.
-    w_states = list(query_job)
+    w_states = list(results)
     print(
         "There are {} states with names starting with W in the selected range.".format(
             len(w_states)
