René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Python to construct CASE WHEN update SQL statement","articleBody":"I try to update 2K rows in BQ \r\n\r\n\r\n\r\n\r\n```\r\ndef update_bq_ads_status_failed(self, update_ads):\r\n        affected_rows = 0\r\n        for update_ads_chunk in split(update_ads, _UPDATE_CHUNK_SIZE):\r\n            ad_ids = [item[\"ad_id\"] for item in update_ads_chunk]\r\n            removal_errors = [item[\"removal_error\"] for item in update_ads_chunk]\r\n\r\n            update_removal_error = \"\"\r\n            for ad_id, removal_error in zip(ad_ids, removal_errors):\r\n                update_removal_error = update_removal_error + \\\r\n                                       f''' WHEN ad_id = '{ad_id}' Then '{removal_error}' '''\r\n            affected_rows += self.update_bq_ads_status(f\"\"\"\r\n                            UPDATE '{table_full_name}' \r\n                            SET status = 'Failed Removing'  \r\n                SET removal_error = CASE {update_removal_error} END \r\n                WHERE ad_id IN {str(ad_ids)}\r\n                \"\"\")\r\n        return affected_rows\r\n```\r\n\r\n\r\nI'm getting this error. I know it's too vague and not possible to debug like this.\r\n\r\n\u003e timeout=300.0, headers={'X-Server-Timeout': '300.0',\r\n\u003e 'Accept-Encoding': 'gzip', 'Content-Type': 'application/json',\r\n\u003e 'X-Goog-API-Client': 'gl-python/3.8.10 grpc/1.39.0 gax/2.0.0\r\n\u003e gapic/2.26.0 gccl/2.26.0', 'User-Agent': 'gl-python/3.8.10 grpc/1.39.0\r\n\u003e gax/2.0.0 gapic/2.26.0 gccl/2.26.0'})), last exception: ('Connection\r\n\u003e aborted.', RemoteDisconnected('Remote end closed connection without\r\n\u003e response'))\r\n\r\n\r\nI'm trying to eliminate errors. Is my BQ update syntactically correct? \r\n\r\nWhat's the BQ update timeout?","author":{"url":"https://github.com/elad2109","@type":"Person","name":"elad2109"},"datePublished":"2021-09-14T00:26:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/970/python-bigquery/issues/970"}