Crash while writing to mySQL

[nileshm12]

I get the following crash while writing blob to a relational database (cloudSQL). Any suggestion on what could be issue here.

2020-12-16 16:55:13.027 PSTError message from worker: generic::unknown: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1204, in _execute_context context = constructor(dialect, self, conn, *args) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in _init_compiled for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/sqltypes.py", line 915, in process return DBAPIBinary(value) File "/usr/local/lib/python3.7/site-packages/pymysql/init.py", line 85, in Binary return bytes(x) TypeError: string argument without an encoding The above exception was the direct cause of the following exception: Traceback (most recent call last): File "apache_beam/runners/common.py", line 1213, in apache_beam.runners.common.DoFnRunner.process File "apache_beam/runners/common.py", line 570, in apache_beam.runners.common.SimpleInvoker.invoke_process File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db.py", line 182, in process self._db.write_record(self.table_config, element) File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db_api.py", line 288, in write_record record_dict=record_dict File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db_api.py", line 360, in write_record session.execute(insert_stmt) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1292, in execute clause, params or {} File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1207, in execute_context e, util.text_type(statement), parameters, None, None File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1511, in handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from=e File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182, in raise raise exception File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1204, in _execute_context context = constructor(dialect, self, conn, *args) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in _init_compiled for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/sqltypes.py", line 915, in process return DBAPIBinary(value) File "/usr/local/lib/python3.7/site-packages/pymysql/init.py", line 85, in Binary return bytes(x) sqlalchemy.exc.StatementError: (builtins.TypeError) string argument without an encoding [SQL: INSERT INTO region_master (edge_location_region_id, edge_location_region_name, cloud_provider, fwaas_display_name, public_subnets) VALUES (%(edge_location_region_id)s, %(edge_location_region_name)s, %(cloud_provider)s, %(fwaas_display_name)s, %(public_subnets)s) ON DUPLICATE KEY UPDATE edge_location_region_id = %(param_1)s, edge_location_region_name = %(param_2)s, cloud_provider = %(param_3)s, fwaas_display_name = %(param_4)s, public_subnets = %(param_5)s] [parameters: [{}]] During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/sdk_worker.py", line 258, in _execute response = task() File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/sdk_worker.py", line 315, in lambda: self.create_worker().do_instruction(request), request) File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/sdk_worker.py", line 484, in do_instruction getattr(request, request_type), request.instruction_id) File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/sdk_worker.py", line 519, in process_bundle bundle_processor.process_bundle(instruction_id)) File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/bundle_processor.py", line 985, in process_bundle element.data) File "/usr/local/lib/python3.7/site-packages/apache_beam/runners/worker/bundle_processor.py", line 221, in process_encoded self.output(decoded_value) File "apache_beam/runners/worker/operations.py", line 354, in apache_beam.runners.worker.operations.Operation.output File "apache_beam/runners/worker/operations.py", line 356, in apache_beam.runners.worker.operations.Operation.output File "apache_beam/runners/worker/operations.py", line 218, in apache_beam.runners.worker.operations.SingletonConsumerSet.receive File "apache_beam/runners/worker/operations.py", line 703, in apache_beam.runners.worker.operations.DoOperation.process File "apache_beam/runners/worker/operations.py", line 704, in apache_beam.runners.worker.operations.DoOperation.process File "apache_beam/runners/common.py", line 1215, in apache_beam.runners.common.DoFnRunner.process File "apache_beam/runners/common.py", line 1279, in apache_beam.runners.common.DoFnRunner._reraise_augmented File "apache_beam/runners/common.py", line 1213, in apache_beam.runners.common.DoFnRunner.process File "apache_beam/runners/common.py", line 742, in apache_beam.runners.common.PerWindowInvoker.invoke_process File "apache_beam/runners/common.py", line 860, in apache_beam.runners.common.PerWindowInvoker._invoke_process_per_window File "apache_beam/runners/common.py", line 1374, in apache_beam.runners.common._OutputProcessor.process_outputs File "apache_beam/runners/worker/operations.py", line 218, in apache_beam.runners.worker.operations.SingletonConsumerSet.receive File "apache_beam/runners/worker/operations.py", line 703, in apache_beam.runners.worker.operations.DoOperation.process File "apache_beam/runners/worker/operations.py", line 704, in apache_beam.runners.worker.operations.DoOperation.process File "apache_beam/runners/common.py", line 1215, in apache_beam.runners.common.DoFnRunner.process File "apache_beam/runners/common.py", line 1294, in apache_beam.runners.common.DoFnRunner._reraise_augmented File "/usr/local/lib/python3.7/site-packages/future/utils/init.py", line 446, in raise_with_traceback raise exc.with_traceback(traceback) File "apache_beam/runners/common.py", line 1213, in apache_beam.runners.common.DoFnRunner.process File "apache_beam/runners/common.py", line 570, in apache_beam.runners.common.SimpleInvoker.invoke_process File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db.py", line 182, in process self._db.write_record(self.table_config, element) File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db_api.py", line 288, in write_record record_dict=record_dict File "/usr/local/lib/python3.7/site-packages/beam_nuggets/io/relational_db_api.py", line 360, in write_record session.execute(insert_stmt) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1292, in execute clause, params or {} File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement distilled_params, File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1207, in execute_context e, util.text_type(statement), parameters, None, None File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1511, in handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from=e File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182, in raise raise exception File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1204, in _execute_context context = constructor(dialect, self, conn, *args) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in _init_compiled for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 865, in for key in compiled_params File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/sqltypes.py", line 915, in process return DBAPIBinary(value) File "/usr/local/lib/python3.7/site-packages/pymysql/init.py", line 85, in Binary return bytes(x) RuntimeError: sqlalchemy.exc.StatementError: (builtins.TypeError) string argument without an encoding [SQL: INSERT INTO region_master (edge_location_region_id, edge_location_region_name, cloud_provider, fwaas_display_name, public_subnets) VALUES (%(edge_location_region_id)s, %(edge_location_region_name)s, %(cloud_provider)s, %(fwaas_display_name)s, %(public_subnets)s) ON DUPLICATE KEY UPDATE edge_location_region_id = %(param_1)s, edge_location_region_name = %(param_2)s, cloud_provider = %(param_3)s, fwaas_display_name = %(param_4)s, public_subnets = %(param_5)s] [parameters: [{}]] [while running 'write_to_cloudsql_region_master/ParDo(_WriteToRelationalDBFn)-ptransform-25']

Data:
b'[{"edge_location_region_id": 1, "edge_location_region_name": "us-west-2", "cloud_provider": "aws", "fwaas_display_name": "US Northwest"}, {"edge_location_region_id": 2, "edge_location_region_name": "us-west-1", "cloud_provider": "aws", "fwaas_display_name": "US West"}, {"edge_location_region_id": 3, "edge_location_region_name": "us-east-2", "cloud_provider": "aws", "fwaas_display_name": "US Central"}, {"edge_location_region_id": 4, "edge_location_region_name": "ap-south-1", "cloud_provider": "aws", "fwaas_display_name": "India West"}, {"edge_location_region_id": 5, "edge_location_region_name": "ap-northeast-2", "cloud_provider": "aws", "fwaas_display_name": "South Korea"}, {"edge_location_region_id": 6, "edge_location_region_name": "ap-southeast-1", "cloud_provider": "aws", "fwaas_display_name": "Singapore"}, {"edge_location_region_id": 7, "edge_location_region_name": "ap-southeast-2", "cloud_provider": "aws", "fwaas_display_name": "Australia Southeast"}, {"edge_location_region_id": 8, "edge_location_region_name": "ap-northeast-1", "cloud_provider": "aws", "fwaas_display_name": "Japan Central"}, {"edge_location_region_id": 9, "edge_location_region_name": "eu-central-1", "cloud_provider": "aws", "fwaas_display_name": "Germany Central"}, {"edge_location_region_id": 10, "edge_location_region_name": "eu-west-1", "cloud_provider": "aws", "fwaas_display_name": "Ireland"}, {"edge_location_region_id": 11, "edge_location_region_name": "sa-east-1", "cloud_provider": "aws", "fwaas_display_name": "Brazil South"}, {"edge_location_region_id": 36, "edge_location_region_name": "us-east-1", "cloud_provider": "aws", "fwaas_display_name": "US East"}, {"edge_location_region_id": 61, "edge_location_region_name": "eu-west-2", "cloud_provider": "aws", "fwaas_display_name": "UK"}, {"edge_location_region_id": 64, "edge_location_region_name": "ca-central-1", "cloud_provider": "aws", "fwaas_display_name": "Canada East"}, {"edge_location_region_id": 98, "edge_location_region_name": "me-south-1", "cloud_provider": "aws", "fwaas_display_name": "Bahrain"}, {"edge_location_region_id": 100, "edge_location_region_name": "eu-west-3", "cloud_provider": "aws", "fwaas_display_name": "France North"}, {"edge_location_region_id": 104, "edge_location_region_name": "south-africa-west", "cloud_provider": "aws", "fwaas_display_name": "South Africa West"}, {"edge_location_region_id": 200, "edge_location_region_name": "us-west-2", "cloud_provider": "gcp", "fwaas_display_name": "US Northwest"}, {"edge_location_region_id": 201, "edge_location_region_name": "us-west-201", "cloud_provider": "gcp", "fwaas_display_name": "US Southwest"}, {"edge_location_region_id": 203, "edge_location_region_name": "us-west-1", "cloud_provider": "gcp", "fwaas_display_name": "US West"}, {"edge_location_region_id": 208, "edge_location_region_name": "canada-west", "cloud_provider": "gcp", "fwaas_display_name": "Canada West"}, {"edge_location_region_id": 209, "edge_location_region_name": "ap-southeast-2", "cloud_provider": "gcp", "fwaas_display_name": "Australia Southeast"}, {"edge_location_region_id": 210, "edge_location_region_name": "ap-south-1", "cloud_provider": "gcp", "fwaas_display_name": "India West"}, {"edge_location_region_id": 211, "edge_location_region_name": "ap-northeast-1", "cloud_provider": "gcp", "fwaas_display_name": "Japan Central"}, {"edge_location_region_id": 212, "edge_location_region_name": "eu-west-2", "cloud_provider": "gcp", "fwaas_display_name": "UK"}, {"edge_location_region_id": 213, "edge_location_region_name": "eu-central-1", "cloud_provider": "gcp", "fwaas_display_name": "Germany Central"}, {"edge_location_region_id": 214, "edge_location_region_name": "us-east-1", "cloud_provider": "gcp", "fwaas_display_name": "US East"}, {"edge_location_region_id": 215, "edge_location_region_name": "taiwan", "cloud_provider": "gcp", "fwaas_display_name": "Taiwan"}, {"edge_location_region_id": 216, "edge_location_region_name": "netherlands-central", "cloud_provider": "gcp", "fwaas_display_name": "Netherlands Central", "public_subnets": "[\"192.168.16.0/22\",\"193.15.10.0/24\"]"}, {"edge_location_region_id": 217, "edge_location_region_name": "us-southeast", "cloud_provider": "gcp", "fwaas_display_name": "US Southeast"}, {"edge_location_region_id": 218, "edge_location_region_name": "finland", "cloud_provider": "gcp", "fwaas_display_name": "Finland"}, {"edge_location_region_id": 219, "edge_location_region_name": "hong-kong", "cloud_provider": "gcp", "fwaas_display_name": "Hong Kong"}, {"edge_location_region_id": 220, "edge_location_region_name": "us-east-2", "cloud_provider": "gcp", "fwaas_display_name": "US Central"}, {"edge_location_region_id": 221, "edge_location_region_name": "ca-central-1", "cloud_provider": "gcp", "fwaas_display_name": "Canada East"}, {"edge_location_region_id": 222, "edge_location_region_name": "ap-southeast-1", "cloud_provider": "gcp", "fwaas_display_name": "Singapore"}, {"edge_location_region_id": 224, "edge_location_region_name": "ap-northeast-2", "cloud_provider": "gcp", "fwaas_display_name": "South Korea"}, {"edge_location_region_id": 225, "edge_location_region_name": "eu-west-1", "cloud_provider": "gcp", "fwaas_display_name": "Ireland"}, {"edge_location_region_id": 229, "edge_location_region_name": "eu-west-3", "cloud_provider": "gcp", "fwaas_display_name": "France North"}, {"edge_location_region_id": 233, "edge_location_region_name": "kenya", "cloud_provider": "gcp", "fwaas_display_name": "Kenya"}, {"edge_location_region_id": 235, "edge_location_region_name": "nigeria", "cloud_provider": "gcp", "fwaas_display_name": "Nigeria"}, {"edge_location_region_id": 237, "edge_location_region_name": "south-africa-central", "cloud_provider": "gcp", "fwaas_display_name": "South Africa Central"}, {"edge_location_region_id": 239, "edge_location_region_name": "south-africa-west", "cloud_provider": "gcp", "fwaas_display_name": "South Africa West"}, {"edge_location_region_id": 241, "edge_location_region_name": "australia-east", "cloud_provider": "gcp", "fwaas_display_name": "Australia East"}, {"edge_location_region_id": 245, "edge_location_region_name": "australia-south", "cloud_provider": "gcp", "fwaas_display_name": "Australia South"}, {"edge_location_region_id": 247, "edge_location_region_name": "bangladesh", "cloud_provider": "gcp", "fwaas_display_name": "Bangladesh"}, {"edge_location_region_id": 249, "edge_location_region_name": "cambodia", "cloud_provider": "gcp", "fwaas_display_name": "Cambodia"}, {"edge_location_region_id": 253, "edge_location_region_name": "india-north", "cloud_provider": "gcp", "fwaas_display_name": "India North"}, {"edge_location_region_id": 255, "edge_location_region_name": "india-south", "cloud_provider": "gcp", "fwaas_display_name": "India South"}, {"edge_location_region_id": 259, "edge_location_region_name": "indonesia", "cloud_provider": "gcp", "fwaas_display_name": "Indonesia"}, {"edge_location_region_id": 263, "edge_location_region_name": "japan-south", "cloud_provider": "gcp", "fwaas_display_name": "Japan South"}, {"edge_location_region_id": 265, "edge_location_region_name": "malaysia", "cloud_provider": "gcp", "fwaas_display_name": "Malaysia"}, {"edge_location_region_id": 267, "edge_location_region_name": "myanmar", "cloud_provider": "gcp", "fwaas_display_name": "Myanmar"}, {"edge_location_region_id": 269, "edge_location_region_name": "new-zealand", "cloud_provider": "gcp", "fwaas_display_name": "New Zealand"}, {"edge_location_region_id": 271, "edge_location_region_name": "pakistan-south", "cloud_provider": "gcp", "fwaas_display_name": "Pakistan South"}, {"edge_location_region_id": 273, "edge_location_region_name": "pakistan-west", "cloud_provider": "gcp", "fwaas_display_name": "Pakistan West"}, {"edge_location_region_id": 275, "edge_location_region_name": "papua-new-guinea", "cloud_provider": "gcp", "fwaas_display_name": "Papua New Guinea"}, {"edge_location_region_id": 277, "edge_location_region_name": "philippines", "cloud_provider": "gcp", "fwaas_display_name": "Philippines"}, {"edge_location_region_id": 285, "edge_location_region_name": "thailand", "cloud_provider": "gcp", "fwaas_display_name": "Thailand"}, {"edge_location_region_id": 287, "edge_location_region_name": "vietnam", "cloud_provider": "gcp", "fwaas_display_name": "Vietnam"}, {"edge_location_region_id": 289, "edge_location_region_name": "andorra", "cloud_provider": "gcp", "fwaas_display_name": "Andorra"}, {"edge_location_region_id": 291, "edge_location_region_name": "austria", "cloud_provider": "gcp", "fwaas_display_name": "Austria"}, {"edge_location_region_id": 293, "edge_location_region_name": "belarus", "cloud_provider": "gcp", "fwaas_display_name": "Belarus"}, {"edge_location_region_id": 295, "edge_location_region_name": "belgium", "cloud_provider": "gcp", "fwaas_display_name": "Belgium"}, {"edge_location_region_id": 297, "edge_location_region_name": "bulgaria", "cloud_provider": "gcp", "fwaas_display_name": "Bulgaria"}, {"edge_location_region_id": 299, "edge_location_region_name": "croatia", "cloud_provider": "gcp", "fwaas_display_name": "Croatia"}, {"edge_location_region_id": 301, "edge_location_region_name": "czech-republic", "cloud_provider": "gcp", "fwaas_display_name": "Czech Republic"}, {"edge_location_region_id": 303, "edge_location_region_name": "denmark", "cloud_provider": "gcp", "fwaas_display_name": "Denmark"}, {"edge_location_region_id": 305, "edge_location_region_name": "egypt", "cloud_provider": "gcp", "fwaas_display_name": "Egypt"}, {"edge_location_region_id": 309, "edge_location_region_name": "france-south", "cloud_provider": "gcp", "fwaas_display_name": "France South"}, {"edge_location_region_id": 315, "edge_location_region_name": "germany-north", "cloud_provider": "gcp", "fwaas_display_name": "Germany North"}, {"edge_location_region_id": 317, "edge_location_region_name": "germany-south", "cloud_provider": "gcp", "fwaas_display_name": "Germany South"}, {"edge_location_region_id": 319, "edge_location_region_name": "greece", "cloud_provider": "gcp", "fwaas_display_name": "Greece"}, {"edge_location_region_id": 321, "edge_location_region_name": "hungary", "cloud_provider": "gcp", "fwaas_display_name": "Hungary"}, {"edge_location_region_id": 325, "edge_location_region_name": "israel", "cloud_provider": "gcp", "fwaas_display_name": "Israel"}, {"edge_location_region_id": 327, "edge_location_region_name": "italy", "cloud_provider": "gcp", "fwaas_display_name": "Italy"}, {"edge_location_region_id": 329, "edge_location_region_name": "jordan", "cloud_provider": "gcp", "fwaas_display_name": "Jordan"}, {"edge_location_region_id": 331, "edge_location_region_name": "kuwait", "cloud_provider": "gcp", "fwaas_display_name": "Kuwait"}, {"edge_location_region_id": 333, "edge_location_region_name": "liechtenstein", "cloud_provider": "gcp", "fwaas_display_name": "Liechtenstein"}, {"edge_location_region_id": 335, "edge_location_region_name": "lithuania", "cloud_provider": "gcp", "fwaas_display_name": "Lithuania"}, {"edge_location_region_id": 337, "edge_location_region_name": "luxembourg", "cloud_provider": "gcp", "fwaas_display_name": "Luxembourg"}, {"edge_location_region_id": 339, "edge_location_region_name": "moldova", "cloud_provider": "gcp", "fwaas_display_name": "Moldova"}, {"edge_location_region_id": 341, "edge_location_region_name": "monaco", "cloud_provider": "gcp", "fwaas_display_name": "Monaco"}, {"edge_location_region_id": 345, "edge_location_region_name": "netherlands-south", "cloud_provider": "gcp", "fwaas_display_name": "Netherlands South"}, {"edge_location_region_id": 347, "edge_location_region_name": "norway", "cloud_provider": "gcp", "fwaas_display_name": "Norway"}, {"edge_location_region_id": 349, "edge_location_region_name": "poland", "cloud_provider": "gcp", "fwaas_display_name": "Poland"}, {"edge_location_region_id": 351, "edge_location_region_name": "portugal", "cloud_provider": "gcp", "fwaas_display_name": "Portugal"}, {"edge_location_region_id": 353, "edge_location_region_name": "romania", "cloud_provider": "gcp", "fwaas_display_name": "Romania"}, {"edge_location_region_id": 355, "edge_location_region_name": "russia-central", "cloud_provider": "gcp", "fwaas_display_name": "Russia Central"}, {"edge_location_region_id": 357, "edge_location_region_name": "russia-northwest", "cloud_provider": "gcp", "fwaas_display_name": "Russia Northwest"}, {"edge_location_region_id": 359, "edge_location_region_name": "saudi-arabia", "cloud_provider": "gcp", "fwaas_display_name": "Saudi Arabia"}, {"edge_location_region_id": 361, "edge_location_region_name": "slovakia", "cloud_provider": "gcp", "fwaas_display_name": "Slovakia"}, {"edge_location_region_id": 363, "edge_location_region_name": "slovenia", "cloud_provider": "gcp", "fwaas_display_name": "Slovenia"}, {"edge_location_region_id": 365, "edge_location_region_name": "spain-central", "cloud_provider": "gcp", "fwaas_display_name": "Spain Central"}, {"edge_location_region_id": 367, "edge_location_region_name": "spain-east", "cloud_provider": "gcp", "fwaas_display_name": "Spain East"}, {"edge_location_region_id": 369, "edge_location_region_name": "sweden", "cloud_provider": "gcp", "fwaas_display_name": "Sweden"}, {"edge_location_region_id": 371, "edge_location_region_name": "switzerland", "cloud_provider": "gcp", "fwaas_display_name": "Switzerland"}, {"edge_location_region_id": 373, "edge_location_region_name": "turkey", "cloud_provider": "gcp", "fwaas_display_name": "Turkey"}, {"edge_location_region_id": 377, "edge_location_region_name": "ukraine", "cloud_provider": "gcp", "fwaas_display_name": "Ukraine"}, {"edge_location_region_id": 379, "edge_location_region_name": "uae", "cloud_provider": "gcp", "fwaas_display_name": "United Arab Emirates"}, {"edge_location_region_id": 381, "edge_location_region_name": "uzbekistan", "cloud_provider": "gcp", "fwaas_display_name": "Uzbekistan"}, {"edge_location_region_id": 383, "edge_location_region_name": "canada-central", "cloud_provider": "gcp", "fwaas_display_name": "Canada Central"}, {"edge_location_region_id": 389, "edge_location_region_name": "costa-rica", "cloud_provider": "gcp", "fwaas_display_name": "Costa Rica"}, {"edge_location_region_id": 391, "edge_location_region_name": "mexico-central", "cloud_provider": "gcp", "fwaas_display_name": "Mexico Central"}, {"edge_location_region_id": 393, "edge_location_region_name": "mexico-west", "cloud_provider": "gcp", "fwaas_display_name": "Mexico West"}, {"edge_location_region_id": 395, "edge_location_region_name": "panama", "cloud_provider": "gcp", "fwaas_display_name": "Panama"}, {"edge_location_region_id": 401, "edge_location_region_name": "us-northeast", "cloud_provider": "gcp", "fwaas_display_name": "US Northeast"}, {"edge_location_region_id": 407, "edge_location_region_name": "us-south", "cloud_provider": "gcp", "fwaas_display_name": "US South"}, {"edge_location_region_id": 415, "edge_location_region_name": "argentina", "cloud_provider": "gcp", "fwaas_display_name": "Argentina"}, {"edge_location_region_id": 417, "edge_location_region_name": "bolivia", "cloud_provider": "gcp", "fwaas_display_name": "Bolivia"}, {"edge_location_region_id": 419, "edge_location_region_name": "sa-east-1", "cloud_provider": "gcp", "fwaas_display_name": "Brazil South"}, {"edge_location_region_id": 421, "edge_location_region_name": "brazil-east", "cloud_provider": "gcp", "fwaas_display_name": "Brazil East"}, {"edge_location_region_id": 423, "edge_location_region_name": "brazil-central", "cloud_provider": "gcp", "fwaas_display_name": "Brazil Central"}, {"edge_location_region_id": 425, "edge_location_region_name": "chile", "cloud_provider": "gcp", "fwaas_display_name": "Chile"}, {"edge_location_region_id": 427, "edge_location_region_name": "columbia", "cloud_provider": "gcp", "fwaas_display_name": "Colombia"}, {"edge_location_region_id": 429, "edge_location_region_name": "ecuador", "cloud_provider": "gcp", "fwaas_display_name": "Ecuador"}, {"edge_location_region_id": 431, "edge_location_region_name": "paraguay", "cloud_provider": "gcp", "fwaas_display_name": "Paraguay"}, {"edge_location_region_id": 433, "edge_location_region_name": "peru", "cloud_provider": "gcp", "fwaas_display_name": "Peru"}, {"edge_location_region_id": 435, "edge_location_region_name": "venezuela", "cloud_provider": "gcp", "fwaas_display_name": "Venezuela"}]'