Develop your notebook
The Notebook view is where you query, transform, visualize, and explore your data.
Develop your analysis
Once you've created your project, you're ready to start developing the Notebook view.
Start with SQL or Python
Hex projects typically begin by adding a SQL cell or Python cell that pulls data from a warehouse connection, CSV file, or API. Add a single cell, or start with a template for a little extra structure.
Choose your data source
Browse available data connections in the Data sources sidebar. You can also upload files as a data source from the Files sidebar.
Bring data into your project
To quickly bring data into your project from a data connection, click on the data connection from the Data sources sidebar, and click Query next to any table name. This will automatically create and run a SQL cell with a select *
limited to 100 rows.
You can also add a SQL cell from the Actions bar at the bottom of your Notebook view, and write your own query from scratch. Click the Run button in the upper right of the cell (or cmd-return
) to run the cell.
If you're querying an uploaded CSV file, you'll need to set your SQL cell's data source dropdown to "dataframes".