dosubot[bot] commented on issue #36042:
URL: https://github.com/apache/superset/issues/36042#issuecomment-3504265969
<!-- Answer -->
For SQL Lab query results, the most reliable way to preserve whitespace is
to add a custom CSS rule that targets the table cells. Superset doesn't provide
a built-in setting for this, and any CSS override for `.ag-cell` will apply
globally to all ag-Grid tables (including dashboards and charts), since there
isn't a unique selector for just SQL Lab tables.
You can add something like this to your custom CSS:
```css
.ag-cell {
white-space: pre-wrap;
}
```
If you want to minimize side effects, try to scope the rule to a parent
container unique to SQL Lab (for example, `.SqlLab .ag-cell { white-space:
pre-wrap; }`), but out of the box, SQL Lab tables don't have a unique parent
class—so the global rule is the most straightforward approach.
There’s currently no per-column or per-table cellClass/cellRenderer config
in the SQL Lab UI for more granular control. If you need more targeted
behavior, it would require a code change to add custom classes or cell
renderers for specific columns.
This approach is the standard workaround for whitespace-sensitive data in
Superset query results and is safe for most use cases as long as you’re aware
it affects all ag-Grid tables in the app.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do?
[Good](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=great_response)
|
[Irrelevant](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=irrelevant_answer)
|
[Incorrect](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=incorrect_sources)
|
[Verbose](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=hallucination)
| [Report
🐛](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/073089ea-7786-4eeb-9660-aed9defe6075?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu
b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/36042)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
