Expand my Community achievements bar.

Export data query output results to a csv file

Avatar

Level 2

10/18/21

Description - There should be a way to export the query results to a .csv file.

Why is this feature important to you -

It will help analyzing the data easily. Make any bulk changes and ingest back into AEP. 


How would you like the feature to work -

Ability to save the output data to a file in your local drive. However there should be a limit to avoid storage space issue. 

Current Behavior -

You can view them in the output window which is very small to review or copy. 

 

4 Comments

Avatar

Level 2

10/25/21

SQL tools typically have a way to export query results to a local file system, e.g. the psql tool has a \g option for this that works with Query Service.

Avatar

Employee

1/29/25

@MarcSt4 

 

Data can be exported via Query service using a third part tool.  You are limited to a 50K record limit.  

 

Another option is to create a new dataSet with the results and then export the dataSet to storage location.