Configuring Query Result Size¶
Alation Cloud Service Applies to Alation Cloud Service instances of Alation
Customer Managed Applies to customer-managed instances of Alation
When you run a query in Compose or export query results to Tableau or Plot.ly, the amount of data that can be included is limited to to 16 MB by default. This limit can be increased to a maximum of 100 MB. To change the limit, you must have the role of a Server Admin.
Note
Full query results can be viewed by exporting the query results.
Note
Depending on your Alation instance setup, increasing the result size limit may cause a decline in Alation performance when multiple users simultaneously run queries that render large result sets.
To increase query result size:
Log in to Alation and in the upper-right corner, click the Admin Settings icon to open the Admin Settings page:
In the Admin Settings area, click Compose Settings.
On Compose Settings tab, find the parameter Maximum Result Size in Megabytes. The default value is 16 MB, but you can increase this value to the maximum of 100 MB. You can start by doubling the default size and setting the limit to 32 MB.
On top right, click Save changes to apply the change.
Large execution results may take time to load. If that is the case, you will see the streaming results message on both the results pane in Compose and on the result table and query form pages in the catalog. Until the query is complete, the export functionality won’t be available.
In Compose, there is also a counter of rows that are loaded so far. Streaming large results in Compose:
