hasura / hasura/graphql-engine

Export function in the RAW SQL page and options for results pagination.

Open
#7,503 3 comments 4 reactions 0 assignees View on GitHub
c/console estimate/M k/enhancement p/longterm
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

From a Hasura Cloud user ticket:

```
Hi, this is a feature request. With the Hasura 2.0.7 cloud I would love to have an export function in the RAW SQL view to export the data as a datasheet or CSV. In previous versions of 1.3.X the I could simply copy and paste the table directly into a sheet (Google Sheets, Excel and Numbers) placing the data nicely into organized columns.

Today with Hasura 2.0.X this is not possible and the data is all put into one column on separate rows. Also, in previous versions you could also have unlimited number of rows in the result of your RAW SQL query which is now capped to 100 rows. I understand this is done for performance reasons, but it would awesome if this could set as an option to show up to 1000 rows on one page.
```

Contributor guide

Open the contributing guide

Research direction

The issue concerns the RAW SQL page, its result export, and the current 100-row cap. Start by locating the RAW SQL page and its result rendering or pagination entry points; define how CSV or datasheet output and an optional 1,000-row page should behave, then verify both requests in the relevant UI tests.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
frontend
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.