Exporting Specific Table Data from Phoenix Dashboard

Samantha Z. · 2025-03-31T18:47:25.513Z

Hey, I think we asked this before, but is there an easy way to export a table from a phoenix dashboard? e.g. if I just need the test name, start time, total tokens, status, and the latency column (don't care about the input or output or traces at all)

13 comments

· Sorted by Oldest

RunLLM
APP
·
It seems likely that you can export data from a Phoenix dashboard using the get_spans_dataframe method. This method allows you to pull a dataframe of the traces and optionally filter them based on specific criteria. You can then manipulate this dataframe to include only the columns you are interested in, such as test name, start time, total tokens, status, and latency.Here's a basic example of how you might achieve this: LBKSimport phoenix as pxLBKS# Get the active session session = px.active_session()LBKS# Export all traces to a dataframe df = session.get_spans_dataframe()LBKS# Select only the columns you are interested in filtered_df = df[['test_name', 'start_time', 'total_tokens', 'status', 'latency']]LBKSWould you like more detail on this process?Sources: - https://github.com/Arize-ai/phoenix/issues/2354 - https://docs.arize.com/phoenix/~~/changes/v6Zhm276x8LlKmwqElIA/integrations/bring-production-data-to-notebook-for-eda-or-retraining
💡 Hint: Mention RunLLM in the thread for followups.
Samantha Z.
·
AttributeError: module 'phoenix' has no attribute 'get_active_session'
Samantha Z.
·
I just want a button in the UI where I can say "download" and then check off the columns I want.
Dustin N.
·
hi Samantha Z. unfortunately we don't have that functionality in our UI currently, I can file a tracking issue for you!
Dustin N.
·
please upvote the issue here as it'll help us decide what to prioritize 🙂 https://github.com/Arize-ai/phoenix/issues/6961
Samantha Z.
·
Next question: how come I can't filter by a string in any column in the dashboard? e.g. I want to search for 'blah' in name and it doesn't work
Dustin N.
·
afaik we should "in" operators, but I can double check Samantha Z.
Dustin N.
·
can you try "blah" in attributes["name"] ?
Samantha Z.
·
that doesn't work either
Dustin N.
·
can you show me an example of the span you're trying to search for?
Samantha Z.
·
test_infor_150indicies_15mm_service_fri10pm and I'm trying to search infor in attributes ["name"] but it's not filtering the way I'd expect, I still see everything in the project
Dustin N.
·
can you put "infor" in quotes?
Dustin N.
·
please show me a screenshot, I can't look at your local instance

RunLLM
APP
·
It seems likely that you can export data from a Phoenix dashboard using the get_spans_dataframe method. This method allows you to pull a dataframe of the traces and optionally filter them based on specific criteria. You can then manipulate this dataframe to include only the columns you are interested in, such as test name, start time, total tokens, status, and latency.Here's a basic example of how you might achieve this: LBKSimport phoenix as pxLBKS# Get the active session session = px.active_session()LBKS# Export all traces to a dataframe df = session.get_spans_dataframe()LBKS# Select only the columns you are interested in filtered_df = df[['test_name', 'start_time', 'total_tokens', 'status', 'latency']]LBKSWould you like more detail on this process?Sources: - https://github.com/Arize-ai/phoenix/issues/2354 - https://docs.arize.com/phoenix/~~/changes/v6Zhm276x8LlKmwqElIA/integrations/bring-production-data-to-notebook-for-eda-or-retraining
💡 Hint: Mention RunLLM in the thread for followups.
Samantha Z.
·
AttributeError: module 'phoenix' has no attribute 'get_active_session'
Samantha Z.
·
I just want a button in the UI where I can say "download" and then check off the columns I want.
Dustin N.
·
hi Samantha Z. unfortunately we don't have that functionality in our UI currently, I can file a tracking issue for you!
Dustin N.
·
please upvote the issue here as it'll help us decide what to prioritize 🙂 https://github.com/Arize-ai/phoenix/issues/6961
Samantha Z.
·
Next question: how come I can't filter by a string in any column in the dashboard? e.g. I want to search for 'blah' in name and it doesn't work
Dustin N.
·
afaik we should "in" operators, but I can double check Samantha Z.
Dustin N.
·
can you try "blah" in attributes["name"] ?
Samantha Z.
·
that doesn't work either
Dustin N.
·
can you show me an example of the span you're trying to search for?
Samantha Z.
·
test_infor_150indicies_15mm_service_fri10pm and I'm trying to search infor in attributes ["name"] but it's not filtering the way I'd expect, I still see everything in the project
Dustin N.
·
can you put "infor" in quotes?
Dustin N.
·
please show me a screenshot, I can't look at your local instance