natural-language-to-sql code generation with semantic model awareness
The Notebook Agent accepts natural language queries and generates executable SQL code by searching endorsed semantic models and table schemas in connected data warehouses. The agent serializes notebook context (available tables, previous queries, semantic definitions) and uses an LLM to synthesize SQL that references specific tables and metrics by name, then executes the generated code server-side on Hex infrastructure with configurable compute profiles (Small to 4XL CPU/GPU options).
Unique: Integrates with dbt semantic models to make agents aware of endorsed metrics and standardized definitions, enabling queries that reference business logic rather than raw tables. Most competitors (Jupyter + ChatGPT, Databricks SQL Assistant) lack semantic layer awareness and generate queries against raw schemas.
vs alternatives: Generates SQL that respects your company's metric definitions and semantic models, whereas ChatGPT or Copilot would generate queries against raw tables without understanding business logic.
natural-language-to-python code generation with notebook context
The Notebook Agent generates executable Python code from natural language requests by analyzing the current notebook state (previous cell outputs, imported libraries, variable definitions) and synthesizing code that integrates with existing analysis. Generated code executes server-side on Hex compute infrastructure, with access to standard Python libraries and the ability to reference upstream cell outputs as DataFrames or other objects.
Unique: Generates Python code with awareness of notebook state (upstream cell outputs, variable definitions), enabling agents to write code that integrates with existing analysis rather than standalone scripts. Jupyter + ChatGPT requires manual context passing; Copilot for VS Code lacks notebook-specific context awareness.
vs alternatives: Understands your notebook's execution state and can reference upstream DataFrames and variables, whereas ChatGPT or Copilot would generate isolated code snippets without knowledge of what's already computed.
visual data exploration with drill-down in published apps
Published apps (Team+ feature) support visual data exploration where users can drill down into underlying data by clicking on chart elements or table rows. The system automatically generates drill-down queries based on the selected data point, enabling users to explore data hierarchies without manual query writing. Drill-down is only available in published apps, not in edit mode.
Unique: Automatically generates drill-down queries from chart interactions, enabling users to explore data hierarchies without manual query writing. Tableau and Looker require explicit drill-down configuration; Hex appears to infer drill-down paths automatically.
vs alternatives: Users can click on charts to drill down to detail without writing queries, whereas Tableau requires explicit drill-down path configuration and Jupyter requires manual query writing.
configurable compute profiles with pay-as-you-go scaling
Hex offers six compute tiers (Small: 2GB RAM/0.25 CPU through 4XL: 96GB RAM/24 CPU) plus optional GPU acceleration. Free tier limited to Small compute; Medium compute (8GB RAM/1 CPU) included on all paid plans; Large+ tiers incur per-minute charges ($0.32-$2.58/hr for CPU, $2.93-$4.06/hr for GPU). Users select compute profile per notebook, and costs are billed per-minute of execution time beyond included allowances.
Unique: Offers granular compute tier selection with per-minute billing for Large+ tiers, enabling users to scale compute without changing plans. Most notebook tools (Jupyter, Databricks) either have fixed compute or require plan changes; Hex's per-minute billing is closer to cloud function pricing (AWS Lambda, Google Cloud Functions).
vs alternatives: Users can scale compute on-demand without changing plans, whereas Databricks requires plan changes and Jupyter requires local infrastructure management.
git-based project export and package import for code reuse
Team+ tier enables exporting notebooks as Git projects and importing packages (shared components, templates) from other notebooks. This allows teams to version control notebooks in Git, share reusable components across projects, and maintain a library of analysis templates. Export format and Git integration details not fully documented.
Unique: Enables Git export and package import for notebooks, allowing version control and code reuse across projects. Jupyter has nbdime for Git diffing but no native package system; Databricks has workspace versioning but not Git integration.
vs alternatives: Notebooks can be version controlled in Git and components can be shared across projects, whereas Jupyter requires manual Git setup and Databricks has limited Git integration.
enterprise authentication and compliance with oidc sso and audit logs
Enterprise plan includes OIDC single sign-on (SSO) for centralized authentication, OAuth database connections for warehouse access, audit logs for compliance tracking, and HIPAA compliance certification. These features enable organizations to enforce authentication policies, track user actions, and meet regulatory requirements without managing credentials in Hex.
Unique: Provides OIDC SSO and audit logs for enterprise authentication and compliance, enabling organizations to enforce centralized identity policies. Most notebook tools (Jupyter, Databricks) require separate identity management; Hex integrates SSO natively.
vs alternatives: Enforces single sign-on and provides audit logs for compliance, whereas Jupyter requires external identity management and Databricks has limited audit capabilities.
embedded analytics and custom docker images for enterprise deployments
Enterprise plan enables embedding Hex apps in external websites (embedded analytics) and deploying custom Docker images with pre-installed packages or custom runtime environments. Single-tenant deployment option available for organizations requiring isolated infrastructure.
Unique: Enables embedded analytics and custom Docker deployments for Enterprise customers, allowing integration into external websites and custom runtime environments. Most notebook tools lack embedded analytics; Tableau and Looker have embedded analytics but require separate licensing.
vs alternatives: Dashboards can be embedded in external websites and custom Docker images can be deployed, whereas Jupyter has no embedded analytics and Databricks requires separate embedding infrastructure.
single-tenant enterprise deployment with hipaa compliance and custom branding
Enterprise plan option for deploying Hex in a single-tenant environment with HIPAA compliance, custom branding (white-label), and dedicated support. Enables embedding Hex analytics in customer-facing applications without Hex branding. Requires custom contract and pricing.
Unique: Offers single-tenant deployment with white-label branding and HIPAA compliance, enabling SaaS companies to embed Hex as a white-label analytics solution. Unlike most notebooks (which are multi-tenant only), Hex provides enterprise deployment options for customer-facing products.
vs alternatives: More suitable for SaaS embedding than Tableau because it's designed for code-first analytics and can be white-labeled without separate data modeling.
+8 more capabilities