# Fireworks AI schema ERD

Table and field reference for the Fivetran Fireworks AI connector.

## Table & Field Reference

### query_usage_cost_daily

| Column | Type | Keys |
| --- | --- | --- |
| model | Unknown | PK |
| start_time | Instant | PK |
| account_name | Unknown | PK, FK |
| api_key_id | Unknown | PK, FK |
| attribution_completeness | Unknown |  |
| evaluation_time | Instant |  |
| model_tier | Unknown |  |
| subtotal_currency_code | Unknown |  |
| subtotal_nanos | Unknown |  |
| subtotal_units | Unknown |  |
| unattributed_dimensions | Json |  |
| unknown_model | Unknown |  |
| user_id | Unknown |  |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown | PK, FK |
| api_key_id | Unknown |  |
| client_ip | Unknown |  |
| is_admin_action | Boolean |  |
| message | Unknown |  |
| method | Unknown |  |
| payload | Json |  |
| principal | Unknown |  |
| resource | Unknown |  |
| status_code | Unknown |  |
| status_message | Unknown |  |
| timestamps | Instant |  |
| user_agent | Unknown |  |

### secret

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown | PK, FK |
| key_name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| account_name | Unknown | PK, FK |
| create_time | Instant |  |
| display_name | Unknown |  |
| email | Unknown |  |
| is_service_account | Boolean |  |
| permission_preset | Unknown |  |
| role | Unknown |  |
| state | Unknown |  |
| status_code | Unknown |  |
| status_message | Unknown |  |
| update_time | Instant |  |

### billing_summary

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Instant | PK |
| index | Unknown | PK |
| start_time | Instant | PK |
| account_name | Unknown | PK, FK |
| category | Unknown |  |
| grouping_key | Unknown |  |
| grouping_value | Unknown |  |
| quantity | Unknown |  |
| secondary_grouping_key | Unknown |  |
| secondary_grouping_value | Unknown |  |
| series | Unknown |  |
| unit_amount_currency_code | Unknown |  |
| unit_amount_nanos | Unknown |  |
| unit_amount_units | Unknown |  |

### api_key

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown | PK, FK |
| annotations | Json |  |
| create_time | Instant |  |
| display_name | Unknown |  |
| email | Unknown |  |
| expire_time | Instant |  |
| is_firepass | Unknown |  |
| is_secure | Unknown |  |
| last_used | Instant |  |

### quota

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown | PK, FK |
| max_value | Unknown |  |
| update_time | Instant |  |
| usage | Unknown |  |
| value | Unknown |  |

### account_monthly_spend_threshold

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_name | Unknown | PK, FK |
| currency_code | Unknown |  |
| nanos | Unknown |  |
| units | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| account_type | Unknown |  |
| create_time | Instant |  |
| display_name | Unknown |  |
| email | Unknown |  |
| is_productivity_only | Unknown |  |
| state | Unknown |  |
| status_code | Unknown |  |
| status_message | Unknown |  |
| suspend_state | Unknown |  |
| update_time | Instant |  |

### billing_usage_serverless_cost

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_name | Unknown | PK, FK |
| api_key_id | Unknown | FK |
| audio_input_seconds | Unknown |  |
| cached_prompt_tokens | Unknown |  |
| completion_tokens | Unknown |  |
| cost_nano_usd | Unknown |  |
| end_time | Instant |  |
| model_name | Unknown |  |
| prompt_tokens | Unknown |  |
| session_id | Unknown |  |
| start_time | Instant |  |
| uncached_prompt_tokens | Unknown |  |
| usage_type | Unknown |  |
| user_id | Unknown |  |

### billing_usage_dedicated_cost

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_name | Unknown | PK, FK |
| accelerator_seconds | Unknown |  |
| accelerator_type | Unknown |  |
| base_model | Unknown |  |
| deployment_id | Unknown |  |
| end_time | Instant |  |
| placement | Unknown |  |
| start_time | Instant |  |
| usage_type | Unknown |  |

### billing_usage_training_cost

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_name | Unknown | PK, FK |
| accelerator_seconds | Unknown |  |
| accelerator_type | Unknown |  |
| annotations | Json |  |
| base_model | Unknown |  |
| end_time | Instant |  |
| job_id | Unknown |  |
| job_type | Unknown |  |
| start_time | Instant |  |
| tokens | Unknown |  |
| training_session_id | Unknown |  |
| usage_type | Unknown |  |

## Relationships

- query_usage_cost_daily(api_key_id) → api_key(id)
- query_usage_cost_daily(account_name) → account(name)
- audit_log(account_name) → account(name)
- secret(account_name) → account(name)
- users(account_name) → account(name)
- billing_summary(account_name) → account(name)
- api_key(account_name) → account(name)
- quota(account_name) → account(name)
- account_monthly_spend_threshold(account_name) → account(name)
- billing_usage_serverless_cost(api_key_id) → api_key(id)
- billing_usage_serverless_cost(account_name) → account(name)
- billing_usage_dedicated_cost(account_name) → account(name)
- billing_usage_training_cost(account_name) → account(name)