syda run report

2026-06-27 17:12 UTC  ·  model: grok-3

18,700
total rows
598
LLM calls
175,636
input tokens
268,116
output tokens
$4.5486
est. cost
6729.1s
total time

Summary

Table Rows Mode LLM calls In tokens Out tokens Cost Time Cache
customers 500 direct 14 8,708 40,685 $0.6364 326.4s
products 200 direct 4 2,168 14,741 $0.2276 112.6s
orders 5,000 codegen 200 56,700 62,073 $1.1012 2053.4s HIT
reviews 3,000 codegen 180 51,060 83,120 $1.4000 2123.8s HIT
order_items 10,000 codegen 200 57,000 67,497 $1.1835 2112.8s HIT
TOTAL 18,700 598 175,636 268,116 $4.5486

Per-table details

customers 500 rows  ·  direct  ·  326.4s fa248a53e2f991b4

Column Strategy Calls In tok Out tok Cost Cache Function
_direct_ Direct LLM 14 8,708 40,685 $0.63640

products 200 rows  ·  direct  ·  112.6s 5c8b95de36fa0cef

Column Strategy Calls In tok Out tok Cost Cache Function
_direct_ Direct LLM 4 2,168 14,741 $0.22762

orders 5,000 rows  ·  codegen  ·  2053.4s HIT 21a14bdfa18fe8f5

Column Strategy Calls In tok Out tok Cost Cache Function
order_id Code-gen 0 0 0 HIT
View generated function
def generate_order_id(row, col_name):
    return row.name + 1
order_date Code-gen 0 0 0 HIT
View generated function
def generate_order_date(row, col_name):
    import random
    from datetime import datetime, timedelta
    end_date = datetime.now().date()
    start_date = end_date - timedelta(days=730)
    random_days = random.randint(0, (end_date - start_date).days)
    return (start_date + timedelta(days=random_days)).isoformat()
status Code-gen 0 0 0 HIT
View generated function
def generate_status(row, col_name):
    import random
    statuses = ['pending', 'processing', 'shipped', 'delivered', 'cancelled']
    weights = [0.10, 0.20, 0.25, 0.40, 0.05]
    return random.choices(statuses, weights=weights, k=1)[0]
total_amount Code-gen 0 0 0 HIT
View generated function
def generate_total_amount(row, col_name):
    import random
    return round(random.uniform(10.0, 10000.0), 2)
customer_id Semantic LLM 100 28,400 37,059 $0.64109
shipping_method Semantic LLM 100 28,300 25,014 $0.46011

reviews 3,000 rows  ·  codegen  ·  2123.8s HIT 8e10a7047151ce40

Column Strategy Calls In tok Out tok Cost Cache Function
review_id Code-gen 0 0 0 HIT
View generated function
def generate_review_id(row, col_name):
    return row.name + 1
rating Code-gen 0 0 0 HIT
View generated function
def generate_rating(row, col_name):
    import random
    rand = random.random()
    if rand < 0.30:
        return 5
    elif rand < 0.65:
        return 4
    elif rand < 0.85:
        return 3
    elif rand < 0.95:
        return 2
    else:
        return 1
review_date Code-gen 0 0 0 HIT
View generated function
def generate_review_date(row, col_name):
    from datetime import datetime, timedelta
    import random
    start_date = datetime(2020, 1, 1)
    end_date = datetime(2024, 12, 31)
    days_between = (end_date - start_date).days
    random_days = random.randint(0, days_between)
    review_date = start_date + timedelta(days=random_days)
    return review_date.strftime('%Y-%m-%d')
product_id Semantic LLM 60 17,040 22,659 $0.39100
customer_id Semantic LLM 60 17,040 25,669 $0.43616
review_text Semantic LLM 60 16,980 34,792 $0.57282

order_items 10,000 rows  ·  codegen  ·  2112.8s HIT 09b5cb78f1b98db8

Column Strategy Calls In tok Out tok Cost Cache Function
item_id Code-gen 0 0 0 HIT
View generated function
def generate_item_id(row, col_name):
    return row.name + 1
quantity Code-gen 0 0 0 HIT
View generated function
def generate_quantity(row, col_name):
    import random
    return random.randint(1, 5)
unit_price Code-gen 0 0 0 HIT
View generated function
def generate_unit_price(row, col_name):
    import random
    return round(random.uniform(0.01, 10000.00), 2)
discount Code-gen 0 0 0 HIT
View generated function
def generate_discount(row, col_name):
    import random
    return round(random.uniform(0, 20), 2)
order_id FK sampler 0 0 0
product_id Semantic LLM 200 57,000 67,497 $1.18345