[Bug] Missing country mapping in silver.tb_iso3166_dimCountry from updated Google Ads geotargets data

Resolved 💬 1 comment Opened Feb 27, 2026 by wisneytaas Closed Feb 27, 2026

Bug Description
Ao realizar uma nova extração identificamos um pais que não está mapeado na tabela silver.tb_iso3166_dimCountry pois estavamos usando o CSV retornado na url https://developers.google.com/ad-manager/api/geotargets?hl=pt-br mas temos um arquivo mais atualizado na https://developers.google.com/google-ads/api/data/geotargets que já tenho no meu local /Users/etus_0179/Downloads/third_party/devsite/developers/en/google-ads/api/data/geo/geotargets-2026-02-25.csv me ajude a atualizar a tabela com os novos paises para que seja possivel identificar o nome do pais do google caso seja diferente do padrão internacional na lista temos cidades, estados e paises, mas a tabela deve ter apenas paises

Environment Info

  • Platform: darwin
  • Terminal: Apple_Terminal
  • Version: 2.1.59
  • Feedback ID: 7b506c1f-0f45-474e-b070-78f2541eb3af

Errors

[{"error":"SyntaxError: JSON Parse error: Unrecognized token '<'\n    at <parse> (:0)\n    at parse (unknown)\n    at DA (/$bunfs/root/claude:11:52592)\n    at Te_ (/$bunfs/root/claude:1774:310)\n    at async DTB (/$bunfs/root/claude:1787:7943)\n    at async call (/$bunfs/root/claude:1796:6047)\n    at async <anonymous> (/$bunfs/root/claude:6200:1856)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T19:03:30.704Z"},{"error":"SyntaxError: JSON Parse error: Unrecognized token '<'\n    at <parse> (:0)\n    at parse (unknown)\n    at DA (/$bunfs/root/claude:11:52592)\n    at Te_ (/$bunfs/root/claude:1774:310)\n    at async DTB (/$bunfs/root/claude:1787:7943)\n    at async call (/$bunfs/root/claude:1796:6047)\n    at async <anonymous> (/$bunfs/root/claude:6200:1856)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T19:03:32.821Z"},{"error":"Error: Failed to fetch version from https://storage.googleapis.com/claude-code-dist-86c565f3-f756-42ad-8dfa-d59b1c096819/claude-code-releases/latest: ECONNREFUSED\n    at o38 (/$bunfs/root/claude:2439:2072)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:15:11.703Z"},{"error":"Error: Failed to fetch version from https://storage.googleapis.com/claude-code-dist-86c565f3-f756-42ad-8dfa-d59b1c096819/claude-code-releases/latest: ECONNREFUSED\n    at o38 (/$bunfs/root/claude:2439:2072)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:15:11.769Z"},{"error":"Error: 1P event logging: 3 events failed to export (code=FailedToOpenSocket, Was there a typo in the url or port?)\n    at queueFailedEvents (/$bunfs/root/claude:6252:2350)\n    at async doExport (/$bunfs/root/claude:6252:1257)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:15:16.723Z"},{"error":"Error: {\"message\":\"Failed to export 3 events (code=FailedToOpenSocket, Was there a typo in the url or port?)\",\"originalLine\":\"6252\",\"originalColumn\":\"1409\",\"line\":\"6252\",\"column\":\"1409\",\"sourceURL\":\"/$bunfs/root/claude\",\"stack\":\"Error: Failed to export 3 events (code=FailedToOpenSocket, Was there a typo in the url or port?)\\n    at doExport (/$bunfs/root/claude:6252:1409)\\n    at processTicksAndRejections (native:7:39)\",\"name\":\"Error\"}\n    at error (/$bunfs/root/claude:2407:25028)\n    at <anonymous> (/$bunfs/root/claude:119:92467)\n    at l$D (/$bunfs/root/claude:119:93011)\n    at <anonymous> (/$bunfs/root/claude:120:17366)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:31:42.778Z"},{"error":"Error: Failed to fetch version from https://storage.googleapis.com/claude-code-dist-86c565f3-f756-42ad-8dfa-d59b1c096819/claude-code-releases/latest: ECONNREFUSED\n    at o38 (/$bunfs/root/claude:2439:2072)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:48:22.780Z"},{"error":"Error: Failed to fetch version from https://storage.googleapis.com/claude-code-dist-86c565f3-f756-42ad-8dfa-d59b1c096819/claude-code-releases/latest: ECONNREFUSED\n    at o38 (/$bunfs/root/claude:2439:2072)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:48:22.780Z"},{"error":"Error: 1P event logging: 3 events failed to export (code=FailedToOpenSocket, Was there a typo in the url or port?)\n    at queueFailedEvents (/$bunfs/root/claude:6252:2350)\n    at async doExport (/$bunfs/root/claude:6252:1257)\n    at processTicksAndRejections (native:7:39)","timestamp":"2026-02-26T22:48:27.679Z"},{"error":"Error: {\"message\":\"Failed to export 3 events (code=FailedToOpenSocket, Was there a typo in the url or port?)\",\"originalLine\":\"6252\",\"originalColumn\":\"1409\",\"line\":\"6252\",\"column\":\"1409\",\"sourceURL\":\"/$bunfs/root/claude\",\"stack\":\"Error: Failed to export 3 events (code=FailedToOpenSocket, Was…

Note: Content was truncated.

View original on GitHub ↗

This issue has 1 comment on GitHub. Read the full discussion on GitHub ↗