098 Basic Extraction 8bf64104

# Basic Extraction Examples

Simple examples to get started with STDM extraction.

## Prerequisites

1. JWT authentication configured (see [Auth Setup](../docs/auth-setup.md))
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:

```bash
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

```bash
stdm-extract extract --org prod --days 1
```

---

## Example 3: Custom Output Directory

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

---

## Example 4: Verbose Mode

See detailed progress and timing:

```bash
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:

```bash
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:

```bash
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:

```bash
# List your orgs
sf org list

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

---

## What's Next?

- [Filtered Extraction](filtered-extraction.md) - Filter by agent, date range
- [Analysis Examples](analysis-examples.md) - Analyze extracted data
- [Debugging Sessions](debugging-sessions.md) - Debug specific sessions

---

## Quick Reference

| Task | Command |
|------|---------|
| Last 7 days | `stdm-extract extract --org prod` |
| Last N days | `stdm-extract extract --org prod --days N` |
| Test auth | `stdm-extract test-auth --org prod` |
| Check counts | `stdm-extract count --org prod` |
| Verbose mode | Add `--verbose` to any command |