config row limit for preview table in sqllab

[AnTapTanhCode]

I want config row limit for preview table in sqllab. what can i do?

[dosubot[bot]]

Hey @AnTapTanhCode! I'm here to help you with any issues or questions you have. Let's tackle this config row limit together!

To configure the row limit for the preview table in SQL Lab, you can adjust the DISPLAY_MAX_ROW setting in the Superset configuration file. This setting controls the maximum number of rows displayed in the SQL Lab UI to prevent out-of-memory issues in browsers. The default value is set to 10,000 ^[1].

Additionally, users can adjust the row limit directly in the SQL Lab interface using the QueryLimitSelect component, which allows selecting a row limit from a dropdown menu ^[2].

To continue talking to Dosu, mention @dosu.

[AnTapTanhCode]

'DISPLAY_MAX_ROW' and 'DISPLAY_MAX_ROW' will affect to all query. I want config to preview in sqllab. @dosu