Analytics allows you to export data to a file in CSV format for external use.

Before you export a set of data, consider these guidelines:

• The maximum number of records exported for a non-aggregation query is 65000. Use the LIMIT clause to restrict the records to a number below the upper bound. The LIMIT clause does not return any additional records that satisfy the export selection criteria.
• The number of records exported for an aggregation query by default is 10. If you want more than 10 records, use the LIMIT clause. You can export up to 1000 records by using the LIMIT clause.
• The CSV file format is RFC4180.

• Response from all valid ADQL queries can be exported. The method of writing ADQL queries remains the same.

• Only the fields that you specify in the SELECT clause export to the CSV file. ADQL query supersedes the Controller Tenant UI selection. The fields you select to display in the Data tab have no impact on the exported data even if the query includes SELECT *.
• Fields having nested representation are flattened and appear as separate fields in the CSV file. Additionally, the corresponding unflattened nested fields also appear in the exported records. Flattening fields refers to separating nested fields into individual fields.
• The supported DateTime format is ISO, yyyy -MM-dd’T’HH:mm:ssZZ , without the millisecond value. The timezone is local to the browser from which export is requested. A timestamp field in a nested field is converted to the local timezone only in the flattened fields, not in the unflattened nested field. The format in the UI, that is MM/DD/YYYY HH:MM :SS AM/PM, is different from the format that you see in the exported data.
• The time required to export data varies with the record size you are trying to export. Exporting tends to slow down for a larger set of records because executing the query on and retrieving a large data set takes longer to complete.

You can export metrics to the Metric Browser and search results from the Searches screen. Use the Export option under Actions on the toolbar to do so. While you are on the Searches panel, use the Data mode to export your search result.