Overview:
The SQL Query Panel is an impressive addition to the Directus Insights toolset, allowing users to visualize and interact with their SQL query results in a user-friendly tabular format. This extension enhances the way data is handled in Directus by providing powerful capabilities for querying, filtering, and reporting. Its accessibility and configurability make it a must-have for those who want to gain deeper insights from their data.
This feature enables users to execute SQL queries directly and view results with options for sorting, searching, and even downloading in CSV format. With security features that restrict access based on user permissions, the SQL Query Panel is designed to cater to various data governance needs while still offering extensive functionality.
Features:
- Global Variables Support: Allows dynamic queries by incorporating global variables wrapped in {{/* */}} for more flexible data retrieval.
- Static Queries Option: Users can choose to create static panels for fixed queries, ensuring that the results remain unchanged unless manually altered.
- CSV Download Capability: Easily download the query results in CSV format, facilitating further analysis or sharing with stakeholders.
- Summary Row Options: Automatically generates a summary row with insights such as count, sum, average, and count unique, making data analysis straightforward.
- Customizable Columns: Users can manually add and configure columns to be displayed, ensuring that the most relevant data is visible.
- Searchable and Sortable Columns: Enhances user experience by allowing users to quickly find and sort through data.
- Row Actions: Enables the addition of actions either to an entire row or as buttons at the end of each row, providing flexibility in how data can be interacted with.
- Security Control: Access permissions can be customized per panel, ensuring that sensitive data remains secure and accessible only to authorized users.
