Exporting conversations using query service and terminal
Learn how to save and export Adobe Brand Concierge conversations using Adobe Experience Platform Query Service and Terminal. This video shows how to find dataset table names, configure the PostgreSQL command-line client, and export conversation data for a date range to a CSV file.
Who is this video for?
- Developers who need to export Brand Concierge conversation data using command-line tools
Video content
- Find conversation datasets in Experience Platform and copy their table names
- Install the PostgreSQL client with Homebrew and configure its command-line path
- Copy the PSQL connection command from the Query Service Credentials tab
- Select a dataset and date range, then export query results to a local CSV file
- Check the exported results and refresh expired credentials when needed
psql "sslmode=require host=... password=..." --csv -o ~/brand-concierge-conversation-export/oct-1-2026-till-today-responses.csv -c "SELECT * FROM cja_brand_concierge_responses_dataset_b4c15126_bd9b_4d52_8151_26 WHERE timestamp >= TIMESTAMP '2026-10-01 00:00:00' AND timestamp <= NOW() ORDER BY timestamp ASC LIMIT 1000"
IMPORTANT
The PSQL connection command contains a live password. Do not share it or paste it into chats, AI agents, or email. If authentication fails after the password expires, copy a fresh command from the Query Service Credentials tab.
NOTE
Exported conversations may contain personally identifiable information (PII). Follow your organization’s data-handling policy when storing CSV files.
For documentation, see Brand Concierge help.
Related tutorials
recommendation-more-help
brand-concierge-help-main-toc