Master Hex with our step-by-step tutorial, detailed feature walkthrough, and expert tips.
Explore the key features that make Hex powerful for ai data workflows.
Hex Magic is an AI assistant integrated directly into the notebook environment. It can generate SQL queries and Python code from natural language descriptions, debug errors by analyzing your code and stack traces, explain complex query results or code logic in plain English, and suggest visualizations based on your data. Magic understands the context of your project including your schema, prior cells, and connected data sources, so its suggestions are tailored to your specific analysis rather than generic code completions.
Hex offers native connectors for major cloud data warehouses and databases including Snowflake, Databricks, Google BigQuery, Amazon Redshift, PostgreSQL, MySQL, SQL Server, and Amazon Athena. It also supports connections through generic JDBC/ODBC drivers for other databases. Data connections are configured at the workspace level by admins, and individual users can query any data source they have been granted access to without needing to manage credentials themselves.
Yes, Hex is designed to bridge technical and non-technical users. Business stakeholders can interact with published Hex apps through parameterized input controls like dropdowns, date pickers, and text fields without ever seeing the underlying code. They can explore interactive charts, filter dashboards, and download results. The viewer role allows non-technical users to consume and interact with analyses at no additional editor seat cost on most plans.
Hex includes built-in version control that automatically tracks every change to a project, allowing users to view diffs, restore previous versions, and understand who changed what and when. Multiple users can edit the same project simultaneously with real-time cursors and presence indicators, similar to Google Docs. Projects also support threaded comments on individual cells, status workflows for review and approval, and branching for developing changes without affecting the published version.
Yes, Hex supports scheduled runs that automatically re-execute your notebooks on a cron-based schedule — hourly, daily, weekly, or custom intervals. Scheduled runs can trigger email notifications or Slack alerts when they complete or when specific conditions are met in your data. This makes Hex suitable for production reporting workflows, automated data quality checks, and recurring analytical pipelines that need to stay up to date without manual intervention.
Now that you know how to use Hex, it's time to put this knowledge into practice.
Sign up and follow the tutorial steps
Check pros, cons, and user feedback
See how it stacks against alternatives
Follow our tutorial and master this powerful ai data tool in minutes.
Tutorial updated March 2026