Understand your SQL exploration
The SQL Explorer UI has the following configurations:
Catalog
The Catalog for an application is a repository of metadata objects arranged in folders. Users can see portions of the Catalog based on their permissions.
In the SQL Explorer, use the Catalog section to browse and select data for exploration in the following ways:
- Double-click the columns in the tree-view.
- Drag and drop the columns into the Query Builder.
- Click More (...) next to each catalog item and select an option.
You can use Show/Hide Catalog to adjust the view based on your preference.
Query builder
The query builder provides a query shelf that lets you add the SQL query for exploration. An auto-complete feature lets you add objects quickly.
Note
In an SQL exploration, single quotes (') are a string literal and double quotes (") are an identifier (that is, column name).
Visualization Module
The Visualization module lets you view the results of executing the defined query. It also lets you edit the visualization section, examine the underlying SQL query, and add the chart to a dashboard.
Edit the visualization section
Click More (⋮) to display a drop-down list with the following options:
- Inspect Query – Opens a query inspector with the following tabs.
- SQL
- Warehouse SQL
- NetScript
Note
You can change the SQL and NetScript queries by clicking the Open as SQL Explore and Open as NetScript Explore buttons in the respective sections.
- Add to Dashboard**** – Add your exploration to a dashboard.
- Pick a dashboard
- New Dashboard
- Edit visualization – Contains the following chart settings.
- Visualization –
- Automatic refresh for your chart
- Chart type
- X-axis and Y-axis configuration
- Tooltip
- Size configuration
- Sorting –
- Enable the sorting option on the graph
- Configure sorting rules and the limit
- Download As - Download your analysis in CSV or EXCEL format. The column formatting is preserved for the downloaded files as well.
