As dimensões contêm informações de referência que você pode cruzar com as tabelas de fatos usando JOINs. São atualizadas com maior frequência (a cada 10 minutos).
SELECT a.first_name, a.last_name, at.tag_name, at.team_nameFROM client_analytics.dim_agents aINNER JOIN client_analytics.dim_agent_tags at ON at.agent_id = a.idWHERE a.active = trueORDER BY at.team_name, a.first_name
Esta página foi útil?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Home","colors":{"primary":"#6464FF","light":"#F7F8FF","dark":"#6464FF"},"logo":{"light":"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/treble-light.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=0f7f2dba2b6ef63a34fe90483601df50","dark":"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/dark.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=fe4efb4ec225da5a3af57d9b539341c2"},"favicon":"https://mintcdn.com/trebleai/N7qFKPzh9cWmkY9Y/favicon-treble.svg?fit=max\u0026auto=format\u0026n=N7qFKPzh9cWmkY9Y\u0026q=85\u0026s=97fb999775e0a3d4632062af00a6dd3f","appearance":{"default":"light","strict":true},"navbar":{"links":[{"href":"https://wa.me/12058834230","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://app.treble.ai"}},"footer":{"socials":{"linkedin":"https://www.linkedin.com/company/treble-ai"}},"integrations":{"amplitude":{"apiKey":"73db3d1720f71527cf6882e5063e25b6"},"intercom":{"appId":"uye4idh4"}},"styling":{"latex":true},"navigation":{"languages":[{"language":"es","default":true,"href":"es/home"},{"language":"en","href":"en/home"},{"language":"pt","href":"pt/home"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"trebleai","hasAudioNarration":false,"actualSubdomain":"trebleai","customDomains":["help.treble.ai"],"gitSource":{"type":"github","owner":"treble-ai","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ada27e1180212ced3d89912","collectionId":"c164245a-0dfc-44a1-b465-24f001d1a76c","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ada27e1180212ced3d89912"},"feedback":{"thumbs":true,"edits":false},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6ada27e1180212ced3d89912","clientVersion":"0.0.3990","searchFilterCounts":[{"language":"en","tag":"Documentation","count":197},{"language":"es","tag":"Documentación","count":197},{"language":"pt","tag":"Documentação","count":197},{"language":"en","tag":"User Guide","count":165},{"language":"es","tag":"Guía de usuario","count":165},{"language":"pt","tag":"Guia do usuário","count":165},{"language":"en","tag":"Integrations","count":53},{"language":"es","tag":"Integraciones","count":53},{"language":"pt","tag":"Integrações","count":53},{"language":"en","tag":"API Reference","count":31},{"language":"es","tag":"Referencia de API","count":31},{"language":"pt","tag":"Referência da API","count":31},{"language":"en","tag":"Main Platform","count":22},{"language":"es","tag":"Plataforma Principal","count":22},{"language":"pt","tag":"Plataforma Principal","count":22},{"language":"en","tag":"Build with Treble","count":20},{"language":"en","tag":"Analytics Warehouse","count":20},{"language":"es","tag":"Construye con Treble","count":20},{"language":"es","tag":"Analytics Warehouse","count":20},{"language":"pt","tag":"Construa com o Treble","count":20},{"language":"pt","tag":"Analytics Warehouse","count":20},{"language":"en","tag":"Blocks","count":19},{"language":"en","tag":"HubSpot","count":19},{"language":"en","tag":"Salesforce","count":19},{"language":"es","tag":"Bloques","count":19},{"language":"es","tag":"HubSpot","count":19},{"language":"es","tag":"Salesforce","count":19},{"language":"pt","tag":"Blocos","count":19},{"language":"pt","tag":"HubSpot","count":19},{"language":"pt","tag":"Salesforce","count":19}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"per-site-search-delta","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-private-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-nav-generations","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":":root{--font-family:-apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif}.hero-container{text-align:center;padding:4rem 1rem;background-color:#fafafa}.hero-title{font-size:3rem;font-weight:600;margin-bottom:1rem;color:#111827}.hero-description{font-size:1.125rem;color:#4b5563;margin-bottom:2rem;max-width:600px;margin-left:auto;margin-right:auto}.search-input{width:100%;max-width:500px;padding:.75rem 1rem;border:1px solid #e5e7eb;border-radius:.5rem;font-size:1rem;margin-bottom:2rem;cursor:pointer;background-color:#fff;transition:all .2s ease}.search-input:hover{border-color:#d1d5db;background-color:#f9fafb;box-shadow:0 1px 3px rgba(0,0,0,.1)}.search-input:focus{outline:0;border-color:#d1d5db;box-shadow:0 1px 3px rgba(0,0,0,.1)}.explore-link{color:#111827;text-decoration:none;font-weight:500}.explore-link:hover{text-decoration:underline}.section-title{text-align:center;font-size:2rem;font-weight:600;color:#111827;margin:4rem 0 2rem}.tools-guides-container{margin:6rem auto 8rem;max-width:70rem;padding-left:1.25rem;padding-right:1.25rem}.tools-guides-header{text-align:center;margin-bottom:3rem}.tools-guides-grid{width:100%}.hr{border-color:rgb(var(--gray-100));border-top-width:1px;margin-top:3em;margin-bottom:3em}.loom-video{position:relative;padding-bottom:62.5%;height:0}.loom-video iframe{position:absolute;top:0;left:0;width:100%;height:100%}a.article-link{color:var(--tw-prose-links);text-decoration:none;font-weight:600;border-bottom:2px solid rgb(var(--primary-dark));transition:border-color .2s ease;position:relative;display:inline-flex;align-items:center}a.article-link p{margin:0}a.article-link svg{width:14px!important;height:14px!important;margin-left:4px}a.article-link:hover{color:rgb(var(--primary-dark));border-color:transparent;background-color:rgba(var(--primary-dark),.1);transition:color .3s ease,border-color .3s ease,background-color .3s ease}.interactive-guide .step-container{margin-bottom:2rem;padding:1.5rem;border:1px solid #e5e7eb;border-radius:.5rem;display:none;opacity:0;transform:translateY(10px);transition:opacity .3s ease,transform .3s ease}.interactive-guide .step-container h3{margin-top:0}.interactive-guide .step-container.active{display:block}.interactive-guide .step-container.current{opacity:1;transform:translateY(0)}.interactive-guide .step-container.completed{border-color:#10b981}.interactive-guide .step-navigation{display:flex;justify-content:flex-start;margin-bottom:2rem;gap:.5rem}.interactive-guide .step-indicator{width:2rem;height:2rem;border-radius:50%;background-color:#f3f4f6;border:2px solid #e5e7eb;display:flex;align-items:center;justify-content:center;font-size:.875rem;font-weight:500;color:#6b7280;cursor:pointer;transition:all .2s ease}.interactive-guide .step-indicator:hover{border-color:#d1d5db;background-color:#e5e7eb}.interactive-guide .step-indicator.current{background-color:#10b981;border-color:#059669;color:#fff}.interactive-guide .step-indicator.completed{background-color:#d1fae5;border-color:#10b981;color:#059669}.interactive-guide .step-indicator.completed:hover{background-color:#a7f3d0}.interactive-guide .choice-buttons{display:flex;gap:1rem;margin-top:1rem}.interactive-guide .choice-button{padding:.5rem 1rem;border:1px solid #e5e7eb;border-radius:.25rem;background-color:#fff;cursor:pointer;transition:all .2s}.interactive-guide .choice-button:hover{background-color:#f9fafb;border-color:#d1d5db}.interactive-guide .choice-button.yes{background-color:#10b981;color:#fff;border-color:#059669}.interactive-guide .choice-button.no{background-color:#ef4444;color:#fff;border-color:#dc2626}.interactive-guide .choice-button.yes:hover{background-color:#059669}.interactive-guide .choice-button.no:hover{background-color:#dc2626}.interactive-guide .result-message{margin-top:1rem;padding:1rem;border-radius:.25rem;display:none}.interactive-guide .result-message.success{background-color:#d1fae5;color:#065f46;display:block}.interactive-guide .result-message.error{background-color:#fee2e2;color:#991b1b;display:block}.interactive-guide .sub-steps{margin-top:1rem;display:none}.interactive-guide .sub-steps.active{display:block}.interactive-guide .checkbox-item{display:flex;flex-direction:column;margin-bottom:1rem;padding:.75rem;border-radius:.25rem;border:1px solid #e5e7eb;transition:all .2s}.interactive-guide .checkbox-item:hover{border-color:#d1d5db}.interactive-guide .checkbox-row{display:flex;align-items:center;justify-content:space-between}.interactive-guide .checkbox-label{display:flex;align-items:center;gap:.75rem}.interactive-guide .toggle-buttons{display:flex;gap:.5rem}.interactive-guide .toggle-button{padding:.25rem .75rem;border:1px solid #e5e7eb;border-radius:.25rem;background-color:#fff;font-size:.875rem;cursor:pointer;transition:all .2s}.interactive-guide .toggle-button.selected{background-color:#10b981;color:#fff;border-color:#059669}.interactive-guide .toggle-button.selected.no{background-color:#ef4444;border-color:#dc2626}.interactive-guide .sub-step-help{display:none;margin-top:.5rem;padding:.75rem;background-color:#fef3c7;border-radius:.25rem;color:#92400e}.interactive-guide .sub-step-help.active{display:block}.interactive-guide .sub-step-help a{color:#92400e}.interactive-guide .sub-step-help a:hover{color:#78350f}.interactive-guide .progress-indicator{margin-top:1rem;height:.5rem;background-color:#e5e7eb;border-radius:.25rem;overflow:hidden}.interactive-guide .progress-bar{height:100%;background-color:#10b981;transition:width .3s ease;width:0%}.interactive-guide .sub-steps-summary{margin-top:1rem;padding:.75rem;border-radius:.25rem;background-color:#f9fafb;display:none}.interactive-guide .sub-steps-summary.complete{display:block;background-color:#d1fae5;color:#065f46}"}],"page":{"pagePath":"pt/docs/data-warehouse/dimensions","slug":"/pt/docs/data-warehouse/dimensions","pageMetadata":{"title":"Tabelas de Dimensões","description":"Tabelas de referência: agentes, equipes, tags, templates HSM.","sidebarTitle":"Dimensões","href":"/pt/docs/data-warehouse/dimensions"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Tabelas de referência: agentes, equipes, tags, templates HSM.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,hr:`hr`,p:`p`,pre:`pre`,span:`span`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`1`,id:`tabelas-de-dimensões`,children:`Tabelas de Dimensões`}),`\n`,_jsx(_components.p,{children:`As dimensões contêm informações de referência que você pode cruzar com as tabelas de fatos usando JOINs. São atualizadas com maior frequência (a cada 10 minutos).`}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`dim_agents`,children:`dim_agents`}),`\n`,_jsx(_components.p,{children:`Informações de cada agente registrado na plataforma.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Coluna`}),_jsx(_components.th,{children:`Tipo`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador do agente`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`company_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da empresa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`first_name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`last_name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Sobrenome`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`email`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Email`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`active`})}),_jsx(_components.td,{children:`Bool`}),_jsx(_components.td,{children:`Se o agente está ativo`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`agent_type`})}),_jsx(_components.td,{children:`String`}),_jsxs(_components.td,{children:[`Tipo de agente: `,_jsx(_components.code,{children:`admin`}),`, `,_jsx(_components.code,{children:`agent`}),`, etc.`]})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`dim_tags`,children:`dim_tags`}),`\n`,_jsx(_components.p,{children:`Filas ou tags usadas para rotear conversas a grupos de agentes.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Coluna`}),_jsx(_components.th,{children:`Tipo`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da tag`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`company_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da empresa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome da tag`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`team_id`})}),_jsx(_components.td,{children:`Int32`}),_jsxs(_components.td,{children:[`Equipe à qual pertence. `,_jsx(_components.code,{children:`0`}),` se não tiver equipe`]})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`dim_teams`,children:`dim_teams`}),`\n`,_jsx(_components.p,{children:`Equipes de trabalho que agrupam tags.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Coluna`}),_jsx(_components.th,{children:`Tipo`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da equipe`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`company_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da empresa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome da equipe`})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`dim_hsm`,children:`dim_hsm`}),`\n`,_jsx(_components.p,{children:`Templates HSM (templates de WhatsApp) aprovados pela Meta.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Coluna`}),_jsx(_components.th,{children:`Tipo`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador do template`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`company_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da empresa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome do template`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`status`})}),_jsx(_components.td,{children:`String`}),_jsxs(_components.td,{children:[`Estado: `,_jsx(_components.code,{children:`APPROVED`}),`, `,_jsx(_components.code,{children:`REJECTED`}),`, `,_jsx(_components.code,{children:`PROCESSING`})]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`category`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Categoria do template`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`template_type`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Tipo de template`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`content`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Conteúdo do template`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`provider_id`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`ID do template na Meta`})]})]})]}),`\n`,_jsx(_components.hr,{}),`\n`,_jsx(Heading,{level:`2`,id:`dim_agent_tags`,children:`dim_agent_tags`}),`\n`,_jsx(_components.p,{children:`Relação entre agentes, tags e equipes. Um agente pode pertencer a múltiplas tags.`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Coluna`}),_jsx(_components.th,{children:`Tipo`}),_jsx(_components.th,{children:`Descrição`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`agent_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador do agente`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`company_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da empresa`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`tag_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da tag`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`tag_name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome da tag`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`team_id`})}),_jsx(_components.td,{children:`Int32`}),_jsx(_components.td,{children:`Identificador da equipe`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`team_name`})}),_jsx(_components.td,{children:`String`}),_jsx(_components.td,{children:`Nome da equipe`})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`exemplo-agentes-com-sua-equipe`,children:`Exemplo: agentes com sua equipe`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`9`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`9`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` a`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`first_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` a`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`last_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` at`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`tag_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`,`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` at`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`team_name`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` client_analytics`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`dim_agents`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` a`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`INNER JOIN`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` client_analytics`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`dim_agent_tags`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` at`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ON`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` at`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`agent_id`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` =`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` a`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`id`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WHERE`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` a`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`active`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` =`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` true`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ORDER BY`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:` at`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`team_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`a`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`.`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#D4D4D4`},children:`first_name`})]}),`\n`]})})})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Tabelas de Dimensões","description":"Tabelas de referência: agentes, equipes, tags, templates HSM.","sidebarTitle":"Dimensões","href":"/pt/docs/data-warehouse/dimensions"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Tabelas de Dimensões","slug":"tabelas-de-dimensões","depth":1,"children":[]},{"title":"dim_agents","slug":"dim_agents","depth":2,"children":[]},{"title":"dim_tags","slug":"dim_tags","depth":2,"children":[]},{"title":"dim_teams","slug":"dim_teams","depth":2,"children":[]},{"title":"dim_hsm","slug":"dim_hsm","depth":2,"children":[]},{"title":"dim_agent_tags","slug":"dim_agent_tags","depth":2,"children":[{"title":"Exemplo: agentes com sua equipe","slug":"exemplo-agentes-com-sua-equipe","depth":3,"children":[]}]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/trebleai/e8b64c48fcecfaa0/script.js"],"subdomain":"trebleai","siteName":"Home","title":"Tabelas de Dimensões - Home","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"es":{"href":"/es/docs/data-warehouse/dimensions","matchLevel":1},"en":{"href":"/en/docs/data-warehouse/dimensions","matchLevel":1},"pt":{"href":"/pt/docs/data-warehouse/dimensions","matchLevel":0}}},"lastModified":"2026-05-20T13:23:37.032Z","originalFileLocation":"pt/docs/data-warehouse/dimensions.mdx","locale":"pt"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=\"light\";if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Tabelas de referência: agentes, equipes, tags, templates HSM.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Home\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Tabelas de Dimensões - Home\">\u003cmeta data-mint-head property=\"og:description\" content=\"Tabelas de referência: agentes, equipes, tags, templates HSM.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Home\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://trebleai.mintlify.app/_mintlify/api/og/v2?division=Data+Warehouse+%28Legacy%29\u0026amp;title=Tabelas+de+Dimens%C3%B5es\u0026amp;description=Tabelas+de+refer%C3%AAncia%3A+agentes%2C+equipes%2C+tags%2C+templates+HSM.\u0026amp;theme=3f682625aa372d8383525fb3\u0026amp;signature=f5707142beab732cdaf3fd7f5059aad9e6be4ccc75c60414082e76fdd71dc349\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Tabelas de Dimensões - Home\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Tabelas de referência: agentes, equipes, tags, templates HSM.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://trebleai.mintlify.app/_mintlify/api/og/v2?division=Data+Warehouse+%28Legacy%29\u0026amp;title=Tabelas+de+Dimens%C3%B5es\u0026amp;description=Tabelas+de+refer%C3%AAncia%3A+agentes%2C+equipes%2C+tags%2C+templates+HSM.\u0026amp;theme=3f682625aa372d8383525fb3\u0026amp;signature=f5707142beab732cdaf3fd7f5059aad9e6be4ccc75c60414082e76fdd71dc349\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/trebleai/HNsHU13Wcqq09jY3/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Home\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#6464FF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/pt/docs/data-warehouse/dimensions.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"pt\" href=\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"es\" href=\"https://help.treble.ai/es/docs/data-warehouse/dimensions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://help.treble.ai/en/docs/data-warehouse/dimensions\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://help.treble.ai/es/docs/data-warehouse/dimensions\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://help.treble.ai/#organization\",\"name\":\"Home\",\"url\":\"https://help.treble.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/trebleai/5XNOo1Uq3QVPV6lD/logo/treble-light.svg?fit=max\u0026auto=format\u0026n=5XNOo1Uq3QVPV6lD\u0026q=85\u0026s=0f7f2dba2b6ef63a34fe90483601df50\"}},{\"@type\":\"WebSite\",\"@id\":\"https://help.treble.ai#website\",\"name\":\"Home\",\"url\":\"https://help.treble.ai\",\"publisher\":{\"@id\":\"https://help.treble.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions#webpage\",\"url\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\",\"name\":\"Tabelas de Dimensões\",\"description\":\"Tabelas de referência: agentes, equipes, tags, templates HSM.\",\"dateModified\":\"2026-05-20T13:23:37.032Z\",\"isPartOf\":{\"@id\":\"https://help.treble.ai#website\"},\"breadcrumb\":{\"@id\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Data Warehouse (Legacy)\",\"item\":\"https://help.treble.ai/pt/docs/data-warehouse/welcome\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabelas de Dimensões\",\"item\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions#article\",\"headline\":\"Tabelas de Dimensões\",\"name\":\"Tabelas de Dimensões\",\"description\":\"Tabelas de referência: agentes, equipes, tags, templates HSM.\",\"url\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions\",\"mainEntityOfPage\":{\"@id\":\"https://help.treble.ai/pt/docs/data-warehouse/dimensions#webpage\"},\"dateModified\":\"2026-05-20T13:23:37.032Z\",\"publisher\":{\"@id\":\"https://help.treble.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://help.treble.ai#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Home\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Home","nav":{"global":null,"languages":[{"language":"es","default":true,"pages":[{"title":"es","href":"/es/docs/data-warehouse/dimensions"}]},{"language":"en","pages":[{"title":"en","href":"/en/docs/data-warehouse/dimensions"}]},{"language":"pt","anchors":[{"anchor":"Documentação","icon":"book-open","tabs":[{"tab":"Bem-vindo","pages":[{"title":"Bem-vindo","href":"/pt/home"}]},{"tab":"Guia do usuário","groups":[{"group":"Começar","pages":[{"title":"Bem-vindo ao Treble","sidebarTitle":"Visão Geral","href":"/pt/docs/welcome"},{"title":"Conceitos Chave","href":"/pt/docs/key-concepts"},{"group":"Introdução ao Treble","pages":[{"title":"Primeiros Passos","href":"/pt/docs/intro-to-treble/welcome"},{"title":"Conversa Outbound","href":"/pt/docs/intro-to-treble/outbound-convo"},{"title":"Conversa Inbound","href":"/pt/docs/intro-to-treble/inbound-convo"},{"title":"Tutorial: Primeira Conversa Transferida para um Agente","href":"/pt/docs/intro-to-treble/first-agent-convo"}]}]},{"group":"Meta","pages":[{"title":"Meta e Treble","href":"/pt/docs/meta/overview"},{"title":"WhatsApp, WhatsApp Business e API do WhatsApp Business","href":"/pt/docs/meta/wa-wabiz-api"},{"group":"Conectar WhatsApp","pages":[{"title":"Conectar Linha do WhatsApp","sidebarTitle":"Primeiros Passos","href":"/pt/docs/meta/guide/welcome"},{"title":"Preparar seu site","href":"/pt/docs/meta/guide/preparing-website"},{"title":"Portfólio comercial da Meta","href":"/pt/docs/meta/guide/business-manager"},{"title":"Verificação da Meta","href":"/pt/docs/meta/guide/meta-verification"},{"title":"Número do WhatsApp","href":"/pt/docs/meta/guide/whatsapp-number"}]},{"group":"Modelos de Mensagens (HSM)","pages":[{"title":"Templates HSM","href":"/pt/docs/meta/hsm-templates/intro"},{"title":"Modelos de Utilidade","href":"/pt/docs/meta/hsm-templates/utility"},{"title":"Templates de Carrossel","href":"/pt/docs/meta/hsm-templates/carousel"}]},{"title":"Selo Verde da Linha do WhatsApp","href":"/pt/docs/meta/green-check"},{"title":"Saúde da Linha do WhatsApp","href":"/pt/docs/meta/whatsapp-line-health"},{"title":"Políticas da Plataforma do WhatsApp Business","href":"/pt/docs/meta/waba-policies"},{"title":"Nomes de usuário do WhatsApp e BSUID (Business-Scoped User ID)","href":"/pt/docs/meta/usernames-and-bsuid"},{"group":"Erros de WhatsApp","pages":[{"title":"Failure by unable to contact no WhatsApp","href":"/pt/docs/meta/error-descriptions/failure-by-unable-to-contact"},{"title":"Failure by payment issue no WhatsApp","href":"/pt/docs/meta/error-descriptions/failure-by-payment-issue"}]}]},{"group":"Construa com o Treble","pages":[{"title":"Objetivo da Campanha","href":"/pt/docs/build-with-treble/welcome"},{"group":"Funcionalidades","pages":[{"title":"Variáveis","href":"/pt/docs/build-with-treble/features/variables"},{"title":"Variáveis Nativas","href":"/pt/docs/build-with-treble/features/native-variables"},{"title":"Fluxo Alternativo","href":"/pt/docs/build-with-treble/features/alternate-flow"},{"title":"Segundo HSM","href":"/pt/docs/build-with-treble/features/second-hsm"},{"title":"Bloco de Objetivo","href":"/pt/docs/build-with-treble/features/goal-block"},{"title":"Imagens, documentos e vídeos nos seus blocos de mensagem","href":"/pt/docs/build-with-treble/features/media"}]},{"group":"Blocos","pages":[{"title":"Testes A/B","href":"/pt/docs/build-with-treble/blocks/ab-test"},{"group":"Métodos de transferência","pages":[{"title":"Métodos de transferência","href":"/pt/docs/build-with-treble/blocks/transfer-methods/overview"},{"title":"Métodos do Treble","href":"/pt/docs/build-with-treble/blocks/transfer-methods/treble"},{"title":"Métodos do HubSpot","href":"/pt/docs/build-with-treble/blocks/transfer-methods/hubspot"},{"title":"Atribuição por API","href":"/pt/docs/build-with-treble/blocks/transfer-methods/api"}]},{"title":"Transferência para agente","href":"/pt/docs/build-with-treble/blocks/agent"},{"title":"WhatsApp Flows","href":"/pt/docs/build-with-treble/blocks/whatsapp-flows"},{"title":"📣 Eventos da Meta — Meça o que realmente importa","sidebarTitle":"Eventos da Meta","href":"/pt/docs/build-with-treble/blocks/meta-events"},{"title":"Blocos de Mensagem - Botões, Lista Interativa, Simples e com Opções","href":"/pt/docs/build-with-treble/blocks/message-blocks"},{"title":"Bloco Condicional","href":"/pt/docs/build-with-treble/blocks/conditional"},{"title":"Bloco Enlace a Conversação","href":"/pt/docs/build-with-treble/blocks/jump-to-conversation"}]},{"group":"Guías","pages":[{"title":"Configuração de Horários e Condições de Tempo","href":"/pt/docs/build-with-treble/guides/schedules-and-time-configuration"},{"title":"Como medir o desempenho dos seus links","href":"/pt/docs/build-with-treble/guides/measure-links"}]}]},{"group":"Plataforma Principal","pages":[{"title":"Entendendo a Plataforma Principal","sidebarTitle":"Visão Geral","href":"/pt/docs/main-platform/welcome"},{"title":"Editor de Fluxos de Conversa","href":"/pt/docs/main-platform/conversation-editor"},{"title":"Enviar Conversa Outbound","href":"/pt/docs/main-platform/send-convo"},{"title":"Contatos","href":"/pt/docs/main-platform/contacts"},{"title":"Encurtador de links do Treble","href":"/pt/docs/main-platform/link-shortener"},{"group":"Agentes de IA","pages":[{"title":"Introdução","href":"/pt/docs/main-platform/ai-center/overview"},{"title":"Crie um agente","href":"/pt/docs/main-platform/ai-center/create-agent"},{"title":"Configure seu agente","href":"/pt/docs/main-platform/ai-center/configure-agent"},{"title":"Teste seu agente","href":"/pt/docs/main-platform/ai-center/playground"},{"title":"Base de Conhecimento","href":"/pt/docs/main-platform/ai-center/knowledge-base"},{"group":"Agentes","pages":[{"group":"Agente de IA","pages":[{"title":"Introdução","href":"/pt/docs/main-platform/ai-center/agents/ai-agent/overview"},{"title":"Ferramenta de Chamada de API","href":"/pt/docs/main-platform/ai-center/agents/ai-agent/api-tool"},{"title":"Integração com Google Calendar","href":"/pt/docs/main-platform/ai-center/agents/ai-agent/google-calendar"},{"title":"Configurar a integração com a Shopify","href":"/pt/docs/main-platform/ai-center/agents/ai-agent/shopify-install"},{"title":"Como usar a Shopify nas suas conversas","href":"/pt/docs/main-platform/ai-center/agents/ai-agent/shopify-usage"}]},{"group":"Agentes legados","pages":[{"title":"Leve seus clientes a um objetivo","href":"/pt/docs/main-platform/ai-center/agents/objective-ai"},{"title":"Qualificação de leads","href":"/pt/docs/main-platform/ai-center/agents/lead-qualification"}]}]}]},{"title":"Métricas de Conversação","href":"/pt/docs/main-platform/conversation-metrics"},{"title":"Links do WhatsApp","href":"/pt/docs/main-platform/whatsapp-links"},{"title":"Centro de Métricas","href":"/pt/docs/main-platform/analytics-center"},{"title":"Seção de Configurações","href":"/pt/docs/main-platform/settings"},{"title":"Base de conhecimento","href":"/pt/docs/main-platform/knowledge-base"}]},{"group":"Plataforma de Agentes","pages":[{"title":"Entendendo a Plataforma de Agentes","sidebarTitle":"Visão Geral","href":"/pt/docs/agent-platform/welcome"},{"title":"Visualização Principal","href":"/pt/docs/agent-platform/main-platform"},{"title":"Seção de Contatos","href":"/pt/docs/agent-platform/contacts"},{"group":"Admin","pages":[{"title":"Seção do Administrador","href":"/pt/docs/agent-platform/admin/admin-section"},{"title":"Métricas","href":"/pt/docs/agent-platform/admin/metrics"},{"title":"Agentes","href":"/pt/docs/agent-platform/admin/agents"},{"title":"Equipes de Agentes","href":"/pt/docs/agent-platform/admin/tags-teams"},{"title":"Modelos de Respostas Rápidas","href":"/pt/docs/agent-platform/admin/quick-responses"},{"title":"IA - Assistentes Inteligentes","href":"/pt/docs/agent-platform/admin/treble-boost"},{"title":"Configuração","href":"/pt/docs/agent-platform/admin/configuration"},{"title":"Recomendações e perguntas frequentes","href":"/pt/docs/agent-platform/admin/tips-and-questions"}]},{"title":"Aplicativo Móvel para Agentes","href":"/pt/docs/agent-platform/mobile-app"},{"title":"Como ordenar e filtrar conversas","href":"/pt/docs/agent-platform/filters"},{"title":"Configuração de Notificações Push","href":"/pt/docs/agent-platform/notifications"},{"title":"Detecção automática de inatividade","href":"/pt/docs/agent-platform/inactivity"},{"title":"Automações de SLA","href":"/pt/docs/agent-platform/sla-automations"}]},{"group":"Integrações","pages":[{"title":"Integrações","href":"/pt/docs/integrations/welcome"},{"group":"HubSpot","pages":[{"title":"Integração com HubSpot","href":"/pt/docs/integrations/hubspot/welcome"},{"title":"Instalar Treble no HubSpot","href":"/pt/docs/integrations/hubspot/install"},{"title":"Instalar a Extensão do Chrome","href":"/pt/docs/integrations/hubspot/chrome-extension"},{"title":"Primeiros Passos","href":"/pt/docs/integrations/hubspot/getting-started"},{"group":"Funcionalidades","pages":[{"title":"Workflows","href":"/pt/docs/integrations/hubspot/features/workflows"},{"title":"Variáveis","href":"/pt/docs/integrations/hubspot/features/variables"},{"title":"Propriedades do HubSpot no Treble","href":"/pt/docs/integrations/hubspot/features/properties"},{"title":"Implantar Conversa a partir do Perfil de Contato","href":"/pt/docs/integrations/hubspot/features/deploy"},{"title":"Histórico de Chat no HubSpot como Notas","href":"/pt/docs/integrations/hubspot/features/chat-history"},{"title":"Atividades do HubSpot","href":"/pt/docs/integrations/hubspot/features/activities"}]},{"group":"Blocos","pages":[{"title":"Bloco de Ação no CRM","href":"/pt/docs/integrations/hubspot/blocks/crm-action"},{"title":"Bloco Objeto CRM","href":"/pt/docs/integrations/hubspot/blocks/crm-variable-assignment"},{"title":"Bloco de Ticket","href":"/pt/docs/integrations/hubspot/blocks/ticket"},{"title":"Bloco Condicional","href":"/pt/docs/integrations/hubspot/blocks/conditional"},{"title":"Bloco de Transferência para Humano","href":"/pt/docs/integrations/hubspot/blocks/human-transfer"}]},{"group":"HubSpot + AI","pages":[{"title":"Integração do HubSpot com IA","href":"/pt/docs/integrations/hubspot/hubspot-ai/welcome"},{"title":"Instalação da integração do HubSpot com IA","href":"/pt/docs/integrations/hubspot/hubspot-ai/installation"},{"title":"Funcionalidades da integração do HubSpot com IA","href":"/pt/docs/integrations/hubspot/hubspot-ai/features"},{"title":"Exemplos de uso da integração do HubSpot com IA","href":"/pt/docs/integrations/hubspot/hubspot-ai/examples"}]}]},{"group":"Salesforce","pages":[{"title":"Integração com Salesforce","href":"/pt/docs/integrations/salesforce/welcome"},{"title":"Instalar Treble no Salesforce","href":"/pt/docs/integrations/salesforce/install"},{"title":"Sincronizar objetos do Salesforce","href":"/pt/docs/integrations/salesforce/object-sync"},{"group":"Blocos","pages":[{"title":"Bloco de Ação no CRM","href":"/pt/docs/integrations/salesforce/blocks/crm-action"},{"title":"Bloco de leitura do Salesforce","href":"/pt/docs/integrations/salesforce/blocks/crm-variable-assignment"},{"title":"Transferir para um assessor a partir do Salesforce","href":"/pt/docs/integrations/salesforce/blocks/human-transfer"}]},{"group":"Funcionalidades","pages":[{"title":"Histórico de conversa no CRM","href":"/pt/docs/integrations/salesforce/features/activities"},{"title":"Objeto personalizado de conversas","href":"/pt/docs/integrations/salesforce/features/custom-object"},{"title":"Tipos de registro (Record Types)","href":"/pt/docs/integrations/salesforce/features/record-types"},{"title":"Person Accounts","href":"/pt/docs/integrations/salesforce/features/person-accounts"},{"title":"Contatos do Salesforce no Sales","href":"/pt/docs/integrations/salesforce/features/sales-view"},{"title":"Configurações avançadas","href":"/pt/docs/integrations/salesforce/features/advanced-settings"}]},{"group":"Treble dentro do Salesforce","pages":[{"title":"WhatsApp dentro do Salesforce","href":"/pt/docs/integrations/salesforce/embed/custom-tab"},{"title":"Iniciar conversas a partir de um Flow","href":"/pt/docs/integrations/salesforce/embed/automation-flow-package"},{"title":"Marketing Cloud","href":"/pt/docs/integrations/salesforce/embed/marketing-cloud"}]},{"group":"Salesforce AI","pages":[{"title":"Integração do Salesforce com IA","href":"/pt/docs/integrations/salesforce/salesforce-ai/welcome"},{"title":"Instalação da integração do Salesforce com IA","href":"/pt/docs/integrations/salesforce/salesforce-ai/installation"},{"title":"Funcionalidades da integração do Salesforce com IA","href":"/pt/docs/integrations/salesforce/salesforce-ai/features"},{"title":"Exemplos de uso da integração do Salesforce com IA","href":"/pt/docs/integrations/salesforce/salesforce-ai/examples"}]}]},{"group":"Sheets","pages":[{"title":"Integração do Treble.ai com Google Sheets","href":"/pt/docs/integrations/sheets/welcome"},{"title":"Perguntas Frequentes","href":"/pt/docs/integrations/sheets/faq"}]},{"group":"Zoho","pages":[{"title":"Integração com Zoho","href":"/pt/docs/integrations/zoho/welcome"},{"title":"Instalação da integração com Zoho","href":"/pt/docs/integrations/zoho/installation"},{"title":"Funcionalidades da integração com Zoho","href":"/pt/docs/integrations/zoho/features"},{"title":"Exemplos de uso da integração com Zoho","href":"/pt/docs/integrations/zoho/examples"}]},{"group":"Pipedrive","pages":[{"title":"Integração com Pipedrive","href":"/pt/docs/integrations/pipedrive/welcome"},{"title":"Instalação da integração com Pipedrive","href":"/pt/docs/integrations/pipedrive/installation"},{"title":"Funcionalidades da integração com Pipedrive","href":"/pt/docs/integrations/pipedrive/features"},{"title":"Exemplos de uso da integração com Pipedrive","href":"/pt/docs/integrations/pipedrive/examples"}]},{"group":"Active Campaign","pages":[{"title":"Integração com Active Campaign","href":"/pt/docs/integrations/activecampaign/welcome"},{"title":"Instalação da integração com Active Campaign","href":"/pt/docs/integrations/activecampaign/installation"},{"title":"Funcionalidades da integração com Active Campaign","href":"/pt/docs/integrations/activecampaign/features"},{"title":"Exemplos de uso da integração com Active Campaign","href":"/pt/docs/integrations/activecampaign/examples"}]}]},{"group":"Analytics Warehouse","pages":[{"title":"Analytics Warehouse","sidebarTitle":"Introdução","href":"/pt/docs/data-warehouse-v2/welcome"},{"group":"Uso do Warehouse","pages":[{"title":"Guia de Migração","sidebarTitle":"Guia de Migração","href":"/pt/docs/data-warehouse-v2/migration-guide"},{"title":"Sincronização Incremental","sidebarTitle":"Sincronização Incremental","href":"/pt/docs/data-warehouse-v2/incremental-sync"},{"title":"Otimização de Consultas","sidebarTitle":"Otimização","href":"/pt/docs/data-warehouse-v2/query-optimization"}]},{"group":"Fluxos de Conversa","pages":[{"title":"fact_treble_sessions","sidebarTitle":"Sessões","href":"/pt/docs/data-warehouse-v2/fact-treble-sessions"},{"title":"fact_treble_session_messages","sidebarTitle":"Mensagens","href":"/pt/docs/data-warehouse-v2/fact-treble-session-messages"},{"title":"fact_treble_session_nodes","sidebarTitle":"Percursos","href":"/pt/docs/data-warehouse-v2/fact-treble-session-nodes"},{"title":"fact_treble_session_variables","sidebarTitle":"Variáveis","href":"/pt/docs/data-warehouse-v2/fact-treble-session-variables"}]},{"group":"Campanhas","pages":[{"title":"fact_campaign_sends","sidebarTitle":"Envios","href":"/pt/docs/data-warehouse-v2/fact-campaign-sends"},{"title":"fact_campaign_daily","sidebarTitle":"Resumo Diário","href":"/pt/docs/data-warehouse-v2/fact-campaign-daily"},{"title":"fact_hsm_responses","sidebarTitle":"Respostas de Templates","href":"/pt/docs/data-warehouse-v2/fact-hsm-responses"}]},{"group":"Espaço de Agentes","pages":[{"title":"fact_agent_conversations","sidebarTitle":"Conversas","href":"/pt/docs/data-warehouse-v2/fact-agent-conversations"},{"title":"fact_agent_conversation_messages","sidebarTitle":"Mensagens","href":"/pt/docs/data-warehouse-v2/fact-agent-conversation-messages"},{"title":"fact_agent_conversation_transfers","sidebarTitle":"Transferências","href":"/pt/docs/data-warehouse-v2/fact-agent-conversation-transfers"},{"title":"fact_agent_status_changes","sidebarTitle":"Disponibilidade","href":"/pt/docs/data-warehouse-v2/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Resumo Diário","href":"/pt/docs/data-warehouse-v2/fact-agent-daily"}]},{"group":"Conversões e Atribuição","pages":[{"title":"fact_target_events","sidebarTitle":"Eventos de Conversão","href":"/pt/docs/data-warehouse-v2/fact-target-events"},{"title":"fact_ad_sessions","sidebarTitle":"Meta Ads (CTWA)","href":"/pt/docs/data-warehouse-v2/fact-ad-sessions"},{"title":"fact_whatsapp_link_events","sidebarTitle":"Links de WhatsApp","href":"/pt/docs/data-warehouse-v2/fact-whatsapp-link-events"}]},{"title":"Dimensões","sidebarTitle":"Dimensões","href":"/pt/docs/data-warehouse-v2/dimensions"}]},{"group":"Data Warehouse (Legacy)","pages":[{"title":"Data Warehouse (Legacy)","sidebarTitle":"Introdução","href":"/pt/docs/data-warehouse/welcome"},{"title":"fact_conversations","sidebarTitle":"Conversas","href":"/pt/docs/data-warehouse/fact-conversations"},{"title":"fact_agent_messages","sidebarTitle":"Mensagens","href":"/pt/docs/data-warehouse/fact-agent-messages"},{"title":"fact_redirections","sidebarTitle":"Transferências","href":"/pt/docs/data-warehouse/fact-redirections"},{"title":"fact_agent_status_changes","sidebarTitle":"Disponibilidade de Agentes","href":"/pt/docs/data-warehouse/fact-agent-status-changes"},{"title":"fact_agent_daily","sidebarTitle":"Produtividade por Agente","href":"/pt/docs/data-warehouse/fact-agent-daily"},{"title":"fact_sessions","sidebarTitle":"Fluxos de Conversa","href":"/pt/docs/data-warehouse/fact-sessions"},{"title":"fact_deployment_status","sidebarTitle":"Detalhe de Envios","href":"/pt/docs/data-warehouse/fact-deployment-status"},{"title":"fact_deployment_daily","sidebarTitle":"Métricas de Envios","href":"/pt/docs/data-warehouse/fact-deployment-daily"},{"title":"fact_hsm_responses","description":"Uma linha por cada resposta de usuário a um template HSM.","sidebarTitle":"Respostas HSM","href":"/pt/docs/data-warehouse/fact-hsm-responses"},{"title":"Tabelas de Dimensões","sidebarTitle":"Dimensões","href":"/pt/docs/data-warehouse/dimensions"},{"title":"Otimização de Consultas","description":"Como escrever consultas eficientes no Data Warehouse.","sidebarTitle":"Otimização","href":"/pt/docs/data-warehouse/query-optimization"}]}]},{"tab":"Referência da API","pages":[{"title":"Referência da API","href":"/pt/api-reference/intro/intro"}]}]},{"anchor":"Comunidade","icon":"slack","href":"https://trebleai.slack.com"},{"anchor":"Blog","icon":"newspaper","href":"https://blog.treble.ai"}]}]},"title":"Tabelas de Dimensões - Home","buildId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","deploymentId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","dynamics":[],"chunks":[]}