내 커뮤니티 업적 표시줄을 확대합니다.

Adobe Experience Platform (AEP) & Apps User Groups are live to Network, learn, and share in your regional locations.

Export data query output results to a csv file

Avatar

Level 2

21. 10. 18.

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 의견

Avatar

Level 3

21. 10. 25.

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

25. 1. 29.

@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.