Self customize the limit rows

[shiveries]

For the query limit rows are provided as a fix value in dropdown, how can i use my wanted value such as i want to get top 3 values in SQL LAB or NEW CHARTS displayed?

[dosubot[bot]]

Hi @shiveries! I'm Dosu and I'm helping the Apache Superset team.

There are two different places where row limits apply, and each works differently:

SQL Lab

The LIMIT: dropdown in SQL Lab generates options as increasing powers of 10 (10, 100, 1000, …) up to SQL_MAX_ROW [1]. It is not free-form, so you can't type a custom value like 3 directly into it.

The simplest workaround is to write the LIMIT clause directly in your SQL query:

SELECT * FROM my_table
ORDER BY my_column DESC
LIMIT 3;

SQL Lab will respect whatever LIMIT you specify in the query itself. The dropdown just sets an upper-bound cap that gets appended automatically if your SQL doesn't already include one.

Charts (Explore / New Chart)

The Row limit control in the chart editor is a SelectControl with freeForm: true [2]. This means you can type any custom value directly into the dropdown — click the field, type 3, and press Enter. The predefined choices are [10, 50, 100, 250, 500, 1000, 5000, 10000, 50000] [3], but any integer up to SQL_MAX_ROW is accepted.

In short:

• SQL Lab → write LIMIT 3 directly in your SQL query.
• Charts → type 3 directly into the "Row limit" dropdown (it accepts free-form values).

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.

[shiveries]

I am trying to add limit words at the end of sql words, but it seems will ignore what i wrote and add the choosed limit value replaced...