098 Basic Extraction 8bf64104

Basic Extraction Examples

Simple examples to get started with STDM extraction.

Prerequisites

1. JWT authentication configured (see Auth Setup)
2. Consumer key set: export SF_CONSUMER_KEY="3MVG9..."
3. Org alias available in sf org list

Example 1: Extract Last 7 Days

The simplest extraction - all sessions from the last 7 days:

stdm-extract extract --org prod

Output structure:

./stdm_data/
├── sessions/
│   └── data.parquet
├── interactions/
│   └── data.parquet
├── steps/
│   └── data.parquet
└── messages/
    └── data.parquet

Example 2: Extract Last 24 Hours

stdm-extract extract --org prod --days 1

Example 3: Custom Output Directory

stdm-extract extract --org prod --output /data/agentforce/prod

Example 4: Verbose Mode

See detailed progress and timing:

stdm-extract extract --org prod --verbose

Sample output:

🔐 Authenticating to Data Cloud...
   Instance URL: https://myorg.my.salesforce.com

📊 Extracting sessions...
   Query: SELECT ... FROM ssot__AIAgentSession__dlm WHERE ...
   Records: 1,234 (2.3s)

📊 Extracting interactions...
   Records: 5,678 (4.1s)

📊 Extracting steps...
   Records: 12,345 (8.7s)

📊 Extracting messages...
   Records: 9,876 (5.2s)

✅ Extraction complete!
   Total records: 29,133
   Duration: 20.3s
   Output: ./stdm_data/

Example 5: Test Authentication First

Before extracting, verify your setup:

stdm-extract test-auth --org prod

Success:

✅ Authentication successful
   Instance URL: https://myorg.my.salesforce.com
   Token valid for: 3599 seconds

Failure:

❌ Authentication failed
   Error: invalid_grant
   Hint: Check certificate expiration with:
         openssl x509 -enddate -noout -in ~/.sf/jwt/prod.key

Example 6: Count Records Before Extraction

Check how much data exists without downloading:

stdm-extract count --org prod --dmo sessions

Output:

📊 Record counts for prod:
   Sessions: 12,345

Example 7: Extract from Sandbox

Works the same as production - just use the sandbox alias:

# List your orgs
sf org list

# Extract from sandbox
stdm-extract extract --org mysandbox --days 3

What's Next?

• Filtered Extraction - Filter by agent, date range
• Analysis Examples - Analyze extracted data
• Debugging Sessions - Debug specific sessions

Quick Reference