You can download or export query results to S3, SFTP, Google Cloud Platform, Azure Blob, or email and define an ongoing schedule.
Required Editions
| User Permissions Needed | |
|---|---|
| To export query results: | Admin |
- From the Connect & Mix tab, select Granular Data Center, and then Query Granular Data.
- Create a query or select a saved one.
- Run the query.
- To download the query results locally, select Download. Only the first 20,000 rows are downloaded.
-
To export all the data, click Export To and select the format.
Note- If you select Email, by default the file format is CSV Friendly Formatting.
- In general, for all export formats, CSV Friendly Formatting is limited to 2.3M rows in the results.
- To export on a scheduled basis, click Scheduled Export. The options change according to the format you select. After you set the delivery method and enter your credentials, set the frequency. For example, set daily to export the results on a daily basis.