{"id":2307,"date":"2025-06-09T17:43:32","date_gmt":"2025-06-09T20:43:32","guid":{"rendered":"https:\/\/antunes.digital\/?p=2307"},"modified":"2025-06-11T14:38:57","modified_gmt":"2025-06-11T17:38:57","slug":"databricks-usage","status":"publish","type":"post","link":"https:\/\/antunes.digital\/fabio\/2025\/06\/09\/databricks-usage\/","title":{"rendered":"Databricks Usage"},"content":{"rendered":"\n<iframe title=\"Usage Databricks YTD\" width=\"100%\" height=\"600\" src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiMmVjOWM0NjUtMTYzYi00MmRiLWI0NTktNzI1YTY5NTE0Yjc2IiwidCI6ImU3ZGU4YTE4LTYxZGEtNDc5Ny04ZmJiLTM5ZjliZGU3NTQ0ZCJ9\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe>\n\n\n\n<p class=\"wp-block-paragraph\">*Dados Fict\u00edcios<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\udded <strong>Dashboard: Usage Monitor | YTD 2025 \u2013 Databricks<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\ud83d\udccc <strong>Objetivo<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Este dashboard tem como principal fun\u00e7\u00e3o <strong>monitorar o uso de tabelas dentro do ambiente Databricks<\/strong>, com foco em auditoria, seguran\u00e7a e governan\u00e7a de dados. Ele permite identificar <em>quem acessa o qu\u00ea, quando e com qual frequ\u00eancia<\/em>, segmentando por tipo de acesso (e-mail pessoal, e-mail de servi\u00e7o ou token).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd0d <strong>Principais funcionalidades<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>1. Filtros Interativos (Slicers)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Access Type<\/strong> (Email | Service | Token)<\/li>\n\n\n\n<li><strong>Month<\/strong>, <strong>User Email<\/strong><\/li>\n\n\n\n<li><strong>Group Name<\/strong>, <strong>Team Name<\/strong><\/li>\n\n\n\n<li><strong>Catalog Name<\/strong>, <strong>Schema Name<\/strong>, <strong>Table Name<\/strong><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Esses filtros permitem <strong>explora\u00e7\u00e3o din\u00e2mica<\/strong> dos dados, possibilitando an\u00e1lises espec\u00edficas por usu\u00e1rio, equipe ou tabela.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udcca <strong>Indicadores de Alto N\u00edvel (KPIs)<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Total Tables<\/strong>: N\u00famero total de tabelas acessadas.<\/li>\n\n\n\n<li><strong>Distinct Users<\/strong>: Quantidade de usu\u00e1rios \u00fanicos.<\/li>\n\n\n\n<li><strong>Access<\/strong>: Total de acessos registrados.<\/li>\n\n\n\n<li><strong>Distribui\u00e7\u00e3o por tipo de acesso<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Personal E-mail<\/li>\n\n\n\n<li>Service E-mail<\/li>\n\n\n\n<li>Token<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Permite avaliar o uso por tipo de identidade, com foco especial em acessos via <strong>token<\/strong> e <strong>servi\u00e7o<\/strong>, \u00fateis para monitorar integra\u00e7\u00f5es e automa\u00e7\u00f5es.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udcc8 <strong>An\u00e1lises Temporais<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Access Month Over Month<\/strong>: Volume de acessos por m\u00eas com varia\u00e7\u00e3o percentual.<\/li>\n\n\n\n<li><strong>Access Distinct User | MoM<\/strong>: Evolu\u00e7\u00e3o mensal de usu\u00e1rios distintos.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Esses gr\u00e1ficos ajudam a identificar <strong>tend\u00eancias de uso<\/strong> e comportamentos fora do padr\u00e3o (picos ou quedas).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udc65 <strong>An\u00e1lise por Grupo<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Visualiza\u00e7\u00e3o da distribui\u00e7\u00e3o de acessos por <strong>Group Name<\/strong>, facilitando o entendimento do <strong>engajamento por \u00e1reas de neg\u00f3cio<\/strong>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udce7 <strong>Top Usu\u00e1rios<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tabela com os <strong>usu\u00e1rios ou tokens que mais acessaram<\/strong>, fornecendo visibilidade para auditoria e prioriza\u00e7\u00e3o de an\u00e1lise de comportamento.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc <strong>Diferenciais<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Design clean com \u00eanfase em <strong>cores para categoriza\u00e7\u00e3o de acessos<\/strong> (vermelho para service\/token).<\/li>\n\n\n\n<li>Vis\u00e3o detalhada <strong>de cima para baixo<\/strong>: vis\u00e3o geral \u2192 tend\u00eancias \u2192 detalhamento por grupo\/usu\u00e1rio.<\/li>\n\n\n\n<li>Preparado para <strong>auditoria de seguran\u00e7a de dados<\/strong>, facilitando o rastreamento de acessos suspeitos ou excessivos.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>*Dados Fict\u00edcios \ud83e\udded Dashboard: Usage Monitor | YTD 2025 \u2013 Databricks \ud83d\udccc Objetivo Este dashboard tem como principal fun\u00e7\u00e3o monitorar o uso de tabelas dentro<a href=\"https:\/\/antunes.digital\/fabio\/2025\/06\/09\/databricks-usage\/\" class=\"read-more\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":2311,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[58,31,60,59],"class_list":["post-2307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dashboards","tag-databricks","tag-power-bi","tag-power-bi-databricks-usage","tag-usage-monitor"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/2307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/comments?post=2307"}],"version-history":[{"count":2,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/2307\/revisions"}],"predecessor-version":[{"id":2325,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/posts\/2307\/revisions\/2325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/media\/2311"}],"wp:attachment":[{"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/media?parent=2307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/categories?post=2307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/antunes.digital\/fabio\/wp-json\/wp\/v2\/tags?post=2307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}