I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow.
Also, the tooltip also doesn't show the entire cell contents when hovering over a cell.
Please make it possible to see the entire contents of a cell in the SQL Analytics Endpoint user interface.
7 Comments
- The idea is to make it possible to adjust the column width by dragging a handle (similar to Excel).
- I've always thought this was a UI/UX bug on my side; but no - it's actually like this.. by design? by oversight? Yes please! +1
- Status changed:NewtoPlanned
- The inability to adjust the column width is a significant drawback to using the web front end and a major contributor to a poor data analyst experience. The workarounds suggested by Copilot (listed below) are correct. Another method is to use a SQL client. However, a user shouldn't have to go through hoops to see and work with the results of their query. What's the point of having a web front-end when you need additional tools/methods to complete your work? Workarounds from Copilot 🔧 Workarounds Download the Results: You can export the query results to Excel, CSV, or JSON formats using the download button in the results tab. This allows you to view and manipulate the data with full column widths32. Use "Open in Excel": This feature runs the query and opens the results directly in Excel, where you can easily adjust column widths and explore the data2. Copy Results to Clipboard: Use the "Copy" dropdown to copy results with column names and paste them into a spreadsheet or text editor for better visibility 2. Explore Data (Preview): This feature provides a matrix and visual view of your query results, which may offer better readability for certain types of data 2.
Along the same lines, if a query only returns 3 or 4 rows, they should auto-fit to the data, not end up so wide they take up the entire window width.
Default should be 'auto-fit' to results and let users drag a handle to change width as desired. Select all columns button (or upper left corner next to first column name) should be available like in Excel or SSMS and then allow for changing width of all columns at once.
- This issue is also present in the Fabric Warehouse. Hoping for an update soon
