Export data

Opik gives you several ways to export the data you’ve logged — pick the one that fits your workflow.

SDK

The Python and TypeScript SDKs let you search and export traces, spans, and threads programmatically.

Traces

1
import opik
2
3
client = opik.Opik()
4
5
# Export all traces
6
traces = client.search_traces(project_name="Default project", max_results=1000000)
7
8
# Export filtered traces
9
traces = client.search_traces(
10
  project_name="Default project",
11
  filter_string='input contains "Opik"'
12
)
13
14
# Convert to dict if needed
15
traces = [trace.dict() for trace in traces]

Spans

1
import opik
2
3
client = opik.Opik()
4
5
# Export spans by trace ID
6
spans = client.search_spans(
7
  project_name="Default project",
8
  trace_id="067092dc-e639-73ff-8000-e1c40172450f"
9
)
10
11
# Export filtered spans
12
spans = client.search_spans(
13
  project_name="Default project",
14
  filter_string='input contains "Opik"'
15
)

Threads

1
import opik
2
3
client = opik.Opik()
4
5
# Export all threads
6
threads = client.search_threads(project_name="Default project", max_results=1000000)
7
8
# Export filtered threads
9
threads = client.search_threads(
10
  project_name="Default project",
11
  filter_string='number_of_messages >= 5'
12
)

Filtering with OQL

All search methods accept a filter_string / filterString using the Opik Query Language (OQL):

"<COLUMN> <OPERATOR> <VALUE> [AND <COLUMN> <OPERATOR> <VALUE>]*"

• String values must be wrapped in double quotes
• Multiple conditions can be combined with AND (OR is not supported)
• DateTime fields require ISO 8601 format (e.g., "2024-01-01T00:00:00Z")
• Use dot notation for nested fields: metadata.model, feedback_scores.accuracy

Common filter examples:

1
client.search_traces(filter_string='start_time >= "2024-01-01T00:00:00Z"')
2
client.search_traces(filter_string='usage.total_tokens > 1000')
3
client.search_traces(filter_string='metadata.model = "gpt-4o"')
4
client.search_traces(filter_string='feedback_scores.user_rating is_not_empty')
5
client.search_traces(filter_string='tags contains "production"')

The full list of supported columns per entity type is documented below.

REST API

Use the /traces and /spans endpoints to export data. Both endpoints are paginated.

UI

Select the traces or spans you want to export in the Opik dashboard and click Export CSV in the Actions dropdown.

Command-line tools

The opik export and opik import commands let you export traces, spans, datasets, prompts, and experiments to local JSON or CSV files, and import them back — useful for migrations, backups, and cross-environment syncs.

Export

$
opik export WORKSPACE TYPE NAME [OPTIONS]

TYPE is one of: all, dataset, project, experiment, prompt

$
# Export everything in a workspace
$
opik export my-workspace all
$
$
# Export a specific project
$
opik export my-workspace project "my-project"
$
$
# Export a specific dataset
$
opik export my-workspace dataset "my-test-dataset"
$
$
# Export with a date filter
$
opik export my-workspace project "my-project" \
>
  --filter 'created_at >= "2024-01-01T00:00:00Z"'
$
$
# Export as CSV for analysis
$
opik export my-workspace project "my-project" --format csv --path ./csv_data

Import

$
opik import WORKSPACE TYPE NAME [OPTIONS]

$
# Import a dataset
$
opik import my-workspace dataset "my-dataset"
$
$
# Import a project
$
opik import my-workspace project "my-project"
$
$
# Preview what would be imported
$
opik import my-workspace project "my-project" --dry-run

Imports are automatically resumable — if interrupted, re-run the same command and it picks up where it left off using a local migration_manifest.db.

Migrating between environments

$
# Step 1: Export from source (use source credentials)
$
OPIK_API_KEY=<source_key> OPIK_URL_OVERRIDE=https://source.opik.example.com \
>
  opik export my-workspace project "my-project" --path ./migration_data
$
$
# Step 2: Import to destination (use destination credentials)
$
OPIK_API_KEY=<dest_key> OPIK_URL_OVERRIDE=https://dest.opik.example.com \
>
  opik import my-workspace project "my-project" --path ./migration_data

See the CLI help (opik export --help / opik import --help) for all options and troubleshooting.