Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[fix] Ajustes na base do comex #557

Closed
8 tasks done
laura-l-amaral opened this issue Apr 3, 2024 · 0 comments · Fixed by #558
Closed
8 tasks done

[fix] Ajustes na base do comex #557

laura-l-amaral opened this issue Apr 3, 2024 · 0 comments · Fixed by #558
Assignees
Labels
bug Something isn't working

Comments

@laura-l-amaral
Copy link
Contributor

laura-l-amaral commented Apr 3, 2024

Dados

  • verificar dados duplicados
  • incluir testes
  • remover id_ncm e id_sh4, id_unidade do dicionário
  • Conectar id_pais com diretório de paises
  • Tirar post hook

Metadados

  • arrumar nivel de observação
  • Ajustar fonte original
  • ajustar colunas (alguns dados estão faltando, outros estão errados para a informação de dicionários)

Essa query

SELECT * 
FROM `basedosdados.br_me_comex_stat.ncm_exportacao` 
WHERE ano = 2023 
AND mes = 10 
AND id_ncm = '30049037' 
AND id_unidade = '10' 
AND id_pais = '505' 
AND sigla_uf_ncm='GO' 
AND id_via= '4' 
AND id_urf = '117600'

Retorna duas linhas identicas

@laura-l-amaral laura-l-amaral added the bug Something isn't working label Apr 3, 2024
@laura-l-amaral laura-l-amaral changed the title [fix] dados duplicados na base do comex [fix] Ajustes na base do comex Apr 3, 2024
@laura-l-amaral laura-l-amaral transferred this issue from basedosdados/pipelines Apr 24, 2024
@folhesgabriel folhesgabriel linked a pull request Apr 24, 2024 that will close this issue
@github-project-automation github-project-automation bot moved this from 🏗 Em andamento to ✅ Finalizada! in Roadmap de dados Apr 24, 2024
@folhesgabriel folhesgabriel moved this from ✅ Finalizada! to 🏗 Em andamento in Roadmap de dados Apr 24, 2024
@folhesgabriel folhesgabriel moved this from 🏗 Em andamento to ✅ Finalizada! in Roadmap de dados Apr 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Status: ✅ Finalizada!
Development

Successfully merging a pull request may close this issue.

2 participants