Pivot offers functionality to export the data in the currently selected view.
All data export actions require the user to have the
You can export the aggregated data as a CSV, TSV, JSON, or XLSX (Excel) file from the data cube view.
download button on the header bar as shown below.
From the download modal is is possible to select the number of rows to be returned as determined by the permissions and configuration of the data cube. See Configuring download limits for more info.
You can also export the raw data for the selected filter by selecting
View raw data in the
options menu and clicking
When running a multi-tenant application it is important to configure the limits placed on downloads to balance the users need to export a lot of data and the stability of the cluster.
There are two algorithms used by Pivot to download aggregated data:
Since the second method places more load on the cluster it is not always available to users based on the time range that the user has selected and the permissions that the user possess.
Specifically the user must have the
DownloadLargeData permission and be selecting a smaller time range than what is defined in the data cube options (JSON) as
largeDownloadInterval defaults to
P1M (1 month).
So if you wanted to enable your users to download over 5k rows for a specific data cube for up to 2 years of data
you would give them the
DownloadLargeData permission and set
"largeDownloadInterval": "P2Y" in the data cube options (JSON) in the Advanced tab.
Lastly you can also set
maxDownloadLimit (default: none) on a per data cube level to specify an absolute maximum number of rows that can be exported.
You can configure the amount of data that gets exported when the user downloads raw data from the raw data view by setting
rawDownloadLimit in the data cube options (JSON) defaults to