Export and Download Query Results

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

The topics in this section explain how to export and download your query results from Compose into various formats.

These features may be enabled or disabled by an Alation administrator. See Manage Access to Data Export and Download.

The following table shows a summary of the different formats you can export to and the amount of data that can be exported. For more details, see the individual sections below.

Export Format

Data Limit

CSV (download)

16 MB

CSV (export)

100 million rows

Excel Live Report

1 million rows

Pipe-delimited

100 million rows

Plot.ly

16 MB

Tableau

16 MB

TSV

100 million rows

XLSX

1 million rows

Download Query Results

Anytime you run a query, Alation automatically saves a limited set of the results. Saved results are limited to 16 MB of data by default but can be configured to save a maximum of 100 MB. You can download these limited saved results as a CSV file.

Export Query Results to a File

To get more data in your results, you can export the query results instead. Exported data is downloaded directly to a file on your computer. You can export to CSV, TSV, pipe-delimited, or XLSX format.

Export Query Results to Plot.ly or Tableau

Alation also offers the ability to export query results directly into Tableau or Plot.ly.

Excel Live Reports

With the Excel Live Reports feature, you can link a query to an Excel spreadsheet. Spreadsheet users can then execute the query and get the latest results directly in their spreadsheet.