Data browser
Explore the data connections in your workspace.
- Users will need Can Edit permissions.
Can't remember available table names, column names, or column data types? Don't know where to start your analysis?
Browse your database and dataframe schemas using the Data browser tab of the left sidebar. From there, you can explore a connection's databases, schemas, tables, and columns by selecting the > button and expanding the contents of your database. Click on a table name to see the table's column names and types in the pop up at the bottom of the sidebar.
You can also access the Data browser by hovering over your data source in a SQL cell and selecting Browse schema to the current data connection in the Data browser.
Expanded Data browser modal
Expand the Data browser for a wider view that includes table previews.
You can also access to the Data browser modal from the add cell bar or by selecting the purple Browse all data button in a new project.
Schema metadata
Any schema metadata configured in your warehouse, dbt integration, or the Data manager will be displayed in the Data browser. If the selected table is part of a dbt model or defined as a source in dbt, you can see the model's most recent job execution date, source freshness, and the status of any tests configured on the model.
Recently used tables
Hex keeps track of the tables you’ve recently used, across data connections, so that they’re just a click away. Access the Recently used tab from the sidebar or expanded Data browser modal to preview or query your recently used tables.
Data browser search
Search the contents of your data connection in the search bar at the top of the Data browser. View databases, schemas, and tables that match your search in the Objects tab, and columns that match your search in the Columns tab. You can filter your search results to one type of database object by preceding your search with database:, schema:, or table:.
Hover over a table in a SQL cell query and select Search for table in data browser to launch a search.
Pin databases and schemas
Filter which databases and schemas show up in the Data browser using the pinning feature. To pin a database or schema, hover over the database object in the Data browser and select the pin icon to the right. You can also right click on the object and select Pin this database or Pin this schema. To display only pinned objects in your search result, select the Pinned button below the search bar at the top of the Data browser.
Pinned objects are preserved across projects for each user and data connection. If you pin a few tables and a schema in one project, these objects will be pinned when using the same data connection in a different project, but only for your Hex user.
Data browser shortcuts
Click the three-dot menu next to your selected table in order to see the additional shortcuts.
Preview: Launch the Data browser modal displaying a 100 row preview of the selected table.
Query: Open a SQL cell querying the selected table with a limit 100 clause.
Copy qualified table name: Copy the qualified table name including the database, schema and table.
Copy all columns: Copy a SQL query that selects all columns from the selected table to your clipboard. This shortcut can be useful if you need to select all but a few columns.
Search within table: Launch a Data browser search filtered to the selected table.
Refresh the data browser
The contents of the Data browser are generated upon creation of a data connection, and will be cached until the Data browser is manually refreshed. To refresh, click the refresh icon next to the data connection name at the top of the Data browser.
Hex Admins can schedule automated refreshes for each workspace Data connection.