|
A table component to show the result of user's sql query.
There should be two tabs to switch
- Results: show results of the sql query get from the editor.
- Data preview: Show data preview when user select `Preview Data` or `View Details` options in the table list sidebar.
In Data Preview tab, user should be able to see table data with two buttons to choose to show either `Preview Data` or `View Details`
- Data for `Preview Data` is getting by:
SELECT * FROM schema.table_name;
|
- Data for `View Details` option is getting by:
DESCRIBE schema.table_name;
|
Table functionalities:
- Table column should be re-sizable
- User can export and download query result to different file formats such as csv, xlsx, json
- Table can be filtered
- Able to sort and filter result
- Able to toggle table columns
|