dosubot[bot] commented on issue #37091: URL: https://github.com/apache/superset/issues/37091#issuecomment-3743302895
<!-- Answer --> The difference comes down to how Superset processes and exports data for each option. **Export to CSV** exports the raw query result, so it can include the entire dataset (up to the SQL_MAX_ROW limit, or more if you enable the `ALLOW_FULL_CSV_EXPORT` feature flag) [source](https://github.com/apache/superset/pull/33214), [source](https://github.com/apache/superset/issues/35139). **Export to Pivoted CSV** works differently: it exports the post-processed, pivoted data as rendered in the chart. This process is handled on the frontend and is subject to browser memory and rendering limits. If the pivot table can't render all rows due to performance constraints, the export will only include the visible (or processed) subset, not the full dataset. Also, the pivoted CSV export flattens multi-level columns, which can further limit what gets exported [source](https://github.com/apache/superset/issues/34731). If you need the full dataset with column hierarchy, use **Export to Pivoted Excel** (which preserves multi-level columns), then convert to CSV if needed. For large raw exports, adjust `SQL_MAX_ROW` and enable `ALLOW_FULL_CSV_EXPORT` for CSV [source](https://github.com/apache/superset/issues/35139). Let me know if you want details on configuring these options or workarounds for large exports. <!-- 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/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/00ec3fc5-3215-44a1-95e4-02f0c49bdf0c?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=The%20difference%20comes%20down%20to%20how%20Superset%20processes%20and%20exports%20data%20for%20each%20option.%20%2A%2AExport%20to%20CSV%2A%2A%20exports%20the%20raw%20query%20result%2C%20so%20it%20can%20include%20the%20entire%20dataset%20%28up%20to%20the%20SQL_MAX_ROW%20limit%2C%20or%20more%20if%20you%20enable%20the%20%60ALLOW_FULL_CSV_EXPORT%60%20feature%20flag%29%20%5Bsource%5D%28https%3A//github.com/apache/superset/pull/33214%29%2C%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35139%29.%0A%0A%2A%2AExport%20to%20Pivoted%20CSV%2A%2A%20works%20differently%3A%20it%20exports%20the%20post-processed%2C%20pivoted%20data%20as%20rendered%20in%20the%20chart.%20This%20process%20is%20handled%20on%20the%20frontend%20and%20is%20subject%20to%20b rowser%20memory%20and%20rendering%20limits.%20If%20the%20pivot%20table%20can%27t%20render%20all%20rows%20due%20to%20performance%20constraints%2C%20the%20export%20will%20only%20include%20the%20visible%20%28or%20processed%29%20subset%2C%20not%20the%20full%20dataset.%20Also%2C%20the%20pivoted%20CSV%20export%20flattens%20multi-level%20columns%2C%20which%20can%20further%20limit%20what%20gets%20exported%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/34731%29.%0A%0AIf%20you%20need%20the%20full%20dataset%20with%20column%20hierarchy%2C%20use%20%2A%2AExport%20to%20Pivoted%20Excel%2A%2A%20%28which%20preserves%20multi-level%20columns%29%2C%20then%20convert%20to%20CSV%20if%20needed.%20For%20large%20raw%20exports%2C%20adjust%20%60SQL_MAX_ROW%60%20and%20enable%20%60ALLOW_FULL_CSV_EXPORT%60%20for%20CSV%20%5Bsource%5D%28https%3A//github.com/apache/superset/issues/35139%29.%0A%0ALet%20me%20know%20if%20you%20want%20details%20on%20configuring%20these%20options%20or%20workarounds%20for%20l arge%20exports.) [](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/37091) -- 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]
