Skip to Main Content
Preset Feature Feedback
Status Needs review
Categories New feature
Created by Customer Engagement
Created on Jul 16, 2026

Allow SQL Lab table Preview to show most-recent rows instead of default (physical/earliest) order

What is the problem or goal you're trying to solve or accomplish?

When a user selects a schema + table in SQL Lab, Superset shows a 100-row Preview so they can quickly inspect the table's shape and contents before writing a query. The customer's tables have evolved significantly over time — columns added, data patterns changed — so the earliest rows are no longer representative of what the table looks like today. They want the Preview to surface the most recent records, which better reflect the current schema and data they'll actually be querying.

How are you solving it currently?

Manually, by discarding the Preview and writing their own query in the editor — typically a SELECT * FROM schema.table ORDER BY <timestamp_col> DESC LIMIT 100 — which requires them to already know the relevant recency/timestamp column. This defeats the purpose of the one-click Preview as a quick inspection tool.

What is your recommended solution?

Have the Preview return the most recent records rather than the earliest.

  • Attach files
  • +1