{"id":98438,"date":"2020-11-26T15:50:56","date_gmt":"2020-11-26T14:50:56","guid":{"rendered":"https:\/\/blog.jetbrains.com\/?post_type=datagrip&#038;p=98438"},"modified":"2020-11-26T16:08:45","modified_gmt":"2020-11-26T15:08:45","slug":"datagrip-2020-3-sql-para-mongodb-azure-ad-auth-novos-extratores-e-muito-mais","status":"publish","type":"datagrip","link":"https:\/\/blog.jetbrains.com\/pt-br\/datagrip\/2020\/11\/26\/datagrip-2020-3-sql-para-mongodb-azure-ad-auth-novos-extratores-e-muito-mais\/","title":{"rendered":"DataGrip 2020.3: SQL para MongoDB, Azure AD Auth, novos extratores e muito mais"},"content":{"rendered":"<p>Temos o prazer de apresentar o\u00a0<a href=\"https:\/\/www.jetbrains.com\/pt-br\/datagrip\/whatsnew\/\" target=\"_blank\" rel=\"noopener\"><strong>DataGrip 2020.3<\/strong><\/a>. Esta \u00e9 a terceira grande atualiza\u00e7\u00e3o de 2020 e vem com v\u00e1rios aprimoramentos. Vejamos o que ele tem a oferecer!<\/p>\n<h2>SQL para MongoDB<\/h2>\n<ul>\n<li>Cl\u00e1usulas <i>SELECT, FROM, JOIN, WHERE, HAVING, GROUP BY<\/i><\/li>\n<li>Suporte para fun\u00e7\u00f5es e construtores de objetos<\/li>\n<li>Visualiza\u00e7\u00e3o de consultas JS<\/li>\n<li>Copiar consulta JS para a \u00e1rea de transfer\u00eancia<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1870\" height=\"978\" class=\"alignnone size-large wp-image-95318\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/MongDBSQLGeneral.png\" alt=\"\" \/><\/p>\n<h2>Conectividade<\/h2>\n<ul>\n<li>Suporte para Couchbase<\/li>\n<li>Autentica\u00e7\u00e3o do Azure AD<\/li>\n<li>Diret\u00f3rio de trabalho<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"1006\" class=\"alignnone size-large wp-image-95358\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/AzureAD.png\" alt=\"\" \/><\/p>\n<h2>Editor de dados<\/h2>\n<ul>\n<li>Editor separado para valores de c\u00e9lulas: Valor formatado<\/li>\n<li>Editor separado para valores de c\u00e9lulas: Posi\u00e7\u00e3o inferior<\/li>\n<li>Editor separado para valores de c\u00e9lulas: Imagens<\/li>\n<li>Abrindo tabelas transpostas<\/li>\n<li>Encolhendo uma sele\u00e7\u00e3o<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"858\" class=\"alignnone size-large wp-image-95328\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/ImagesInValueEditor.png\" alt=\"\" \/><\/p>\n<h2>Importa\u00e7\u00e3o\/exporta\u00e7\u00e3o<\/h2>\n<ul>\n<li>Apresentando dois novos extratores: <i>One-row<\/i> e <i>SQL-Insert-Multirow<\/i><\/li>\n<li>Op\u00e7\u00e3o <i>Never quote values<\/i> (nunca colocar valores entre aspas)<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"1093\" class=\"alignnone size-large wp-image-95348\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/NewExtractors.png\" alt=\"\" \/><\/p>\n<h2>Introspec\u00e7\u00e3o<\/h2>\n<ul>\n<li>Coletar informa\u00e7\u00f5es de diagn\u00f3sticos de introspec\u00e7\u00e3o<\/li>\n<li>Grants (concess\u00f5es)<\/li>\n<li>Mudan\u00e7as na \u00e1rvore do banco de dados<\/li>\n<li>[PostgreSQL] Mais propriedades para tabelas<\/li>\n<li>[Greenplum] Novos objetos<\/li>\n<li>[Oracle] Exibi\u00e7\u00e3o correta de procedimentos sobrecarregados<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"638\" class=\"alignnone size-large wp-image-95388\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/Grants-1.png\" alt=\"\" \/><\/p>\n<h2>Assist\u00eancia para codifica\u00e7\u00e3o<\/h2>\n<ul>\n<li>Formatador para dialeto Generic<\/li>\n<li>Op\u00e7\u00f5es para renomear<\/li>\n<li>Corre\u00e7\u00f5es para erros de digita\u00e7\u00e3o<\/li>\n<li>[Oracle] Inspe\u00e7\u00e3o para uma chamada de conflito<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"445\" class=\"alignnone size-large wp-image-95338\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/GenericFormater-1.png\" alt=\"\" \/><\/p>\n<h2>Execu\u00e7\u00e3o de consultas<\/h2>\n<ul>\n<li>Configura\u00e7\u00f5es de execu\u00e7\u00e3o: Comuta\u00e7\u00e3o de esquema<\/li>\n<li>Configura\u00e7\u00f5es de execu\u00e7\u00e3o: Exibindo o esquema padr\u00e3o<\/li>\n<li>Configura\u00e7\u00f5es de execu\u00e7\u00e3o: Destinos de hist\u00f3rico<\/li>\n<li>[SQL Server] Nomes de guias<\/li>\n<li>Sa\u00edda do console em uma guia separada<\/li>\n<li>Dicas para \u00edndices em \u2018Explain plan\u2019<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1566\" height=\"753\" class=\"alignnone size-large wp-image-95378\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/WarningRunConfig-1.png\" alt=\"\" \/><\/p>\n<h2>Edi\u00e7\u00e3o DDL<\/h2>\n<ul>\n<li>Aviso para estrutura de tabela desatualizada<\/li>\n<li>Aviso se o objeto foi exclu\u00eddo<\/li>\n<li>A\u00e7\u00f5es de migra\u00e7\u00e3o est\u00e3o dispon\u00edveis em qualquer lugar<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"666\" class=\"alignnone size-large wp-image-95368\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/DDLWarning.png\" alt=\"\" \/><\/p>\n<h2>IDE geral<\/h2>\n<ul>\n<li>A tela de boas-vindas est\u00e1 de volta<\/li>\n<li>Plug-ins por projeto<\/li>\n<li>Sincronizando o tema atual com as configura\u00e7\u00f5es do SO<\/li>\n<li>Atalhos do macOS como palavras<\/li>\n<li>Guia de visualiza\u00e7\u00e3o<\/li>\n<li>Calculadora simples<\/li>\n<li>Associa\u00e7\u00f5es de arquivos<\/li>\n<li>Expandir tudo na exibi\u00e7\u00e3o em \u00e1rvore do banco de dados<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"1270\" height=\"694\" class=\"alignnone size-large wp-image-95398\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2020\/11\/SplitTabs.gif\" alt=\"\" \/><\/p>\n<p>Para conhecer todos os novos recursos com descri\u00e7\u00f5es completas, acesse a\u00a0<a href=\"https:\/\/www.jetbrains.com\/datagrip\/whatsnew\/\" target=\"_blank\" rel=\"noopener\">p\u00e1gina de Novidades<\/a>. Voc\u00ea j\u00e1 sabe de tudo isso, mas s\u00f3 como um r\u00e1pido lembrete:<\/p>\n<ul>\n<li>Obtenha sua vers\u00e3o de avalia\u00e7\u00e3o por 30 dias do DataGrip\u00a0<a href=\"https:\/\/www.jetbrains.com\/pt-br\/datagrip\/download\/\" target=\"_blank\" rel=\"noopener\">aqui<\/a>.<\/li>\n<li><a href=\"https:\/\/twitter.com\/datagrip\" target=\"_blank\" rel=\"noopener\">Envie-nos um tweet!<\/a><\/li>\n<li>Participe das <a href=\"https:\/\/intellij-support.jetbrains.com\/hc\/en-us\/community\/topics\/200381555-DataGrip\" target=\"_blank\" rel=\"noopener\">discuss\u00f5es\ufffc no f\u00f3rum<\/a>.<\/li>\n<li>Informe bugs no nosso\u00a0<a href=\"https:\/\/youtrack.jetbrains.com\/issues\/DBE\" target=\"_blank\" rel=\"noopener\">rastreador de issues<\/a>.<\/li>\n<\/ul>\n<p>Agradecemos pela sua aten\u00e7\u00e3o! A Equipe do DataGrip<\/p>\n","protected":false},"author":1086,"featured_media":98001,"comment_status":"closed","ping_status":"closed","template":"","categories":[907],"tags":[2033,91],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/datagrip\/98438"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/datagrip"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/types\/datagrip"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/users\/1086"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/comments?post=98438"}],"version-history":[{"count":3,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/datagrip\/98438\/revisions"}],"predecessor-version":[{"id":98451,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/datagrip\/98438\/revisions\/98451"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/media\/98001"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/media?parent=98438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/categories?post=98438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/tags?post=98438"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/cross-post-tag?post=98438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}