Data preview & download

Field properties configuration

You, as an editor, can configure the field's properties in menu action when click on column header:

• Edit description: Add/ edit description to provide context or notes to the field (optional).

Description can be viewed by hovering tip icon next to field name.

• Edit field alias: Add/ edit alias to the field (optional). If no alias is added, header (field name) will be shown as-is (extracted from query).

Click the X icon on the right side of the text to revert to the original field name.

Filters & sorting

You can filter and sort data in the Data Service preview to conduct analysis, focus on specific details, or refine your data view.

Set filter conditions

1. Click Filter at the top of the preview table.

2. You can add multiple filter conditions.

   • Select a field (e.g., Customer, OrderID, Revenue, Date).

   • Choose an operator, available options based on data type of the field (see table below).

   • Enter the filter value.

Operator	STRING	INT	FLOAT	DATETIME	BOOLEAN
Equal Not equal	✓	✓	✓		✓
Greater than Greater than or equal to Less than Less than or equal to	✓	✓	✓
Contains Not contains	✓
Time range	✓			✓

Click the X icon on the right side of the filter condition to delete it.

1. You can choose whether Any or All needs to be met.

2. Click Confirm to apply filter conditions.

Set sort conditions

1. Click Filter at the top of the preview table.

2. You can add multiple sort conditions.

   1. Select a field to sort.

   2. Choose the sort method (Ascending or Descending).

Click the X icon on the right side of the sort condition to delete it.

1. Click Confirm to apply sort conditions.

Refresh to get latest data

You can click Refresh at the top right corner of the data preview table to extract latest data.

Clicking the Refresh button triggers to get the latest data based on current sort/ filter conditions that being applied, but takes no effect on reset or changing those configurations.

Download data

1. Click the Download button at the top of the data preview table.

2. You can rename the download file (optional). By default, file name is the Data Service's name.

3. Select file format (Excel or CSV).

1. Click Download.

2. Check download task in your browser.

Note:

• Field alias, filter and sort conditions will take effect on your download file.

• Total row number of your download file should not exceed 500,000 rows.