# Clazar schema ERD

Table and field reference for the Fivetran Clazar connector.

## Table & Field Reference

### gcp_marketplace_incremental_monthly_insight

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned | Unknown |  |
| account_id | Unknown |  |
| billing_frequency | Unknown |  |
| channel | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| ds | Unknown |  |
| due_vendor | Unknown |  |
| earliest | Unknown |  |
| end_date | Unknown |  |
| entitlement_id | Unknown |  |
| external_account_id | Unknown |  |
| final_installment_date | Unknown |  |
| first_installment_date | Unknown |  |
| gpu_types | Unknown |  |
| installment_count | Unknown |  |
| internal_note | Unknown |  |
| latest | Unknown |  |
| machine_spec_sum | Unknown |  |
| num_cpus | Unknown |  |
| num_gpus | Unknown |  |
| num_vms | Unknown |  |
| offer_title | Unknown |  |
| order_end_date | Unknown |  |
| order_start_date | Unknown |  |
| parent_account_id | Unknown |  |
| payment_schedule | Unknown |  |
| payment_type | Unknown |  |
| postal_code | Unknown |  |
| postpay_credits | Unknown |  |
| prepay_credits | Unknown |  |
| private_offer_acceptance_date | Unknown |  |
| private_offer_total_contract_value | Unknown |  |
| probation_end | Unknown |  |
| probation_start | Unknown |  |
| quote_creator | Unknown |  |
| quote_id | Unknown |  |
| ram_mb | Unknown |  |
| released | Unknown |  |
| report_date | Unknown |  |
| reseller_discount | Unknown |  |
| sku_description | Unknown |  |
| sku_id | Unknown |  |
| solution_name | Unknown |  |
| start_date | Unknown |  |
| state_or_province | Unknown |  |
| transaction_type | Unknown |  |
| trial_use | Unknown |  |
| unit | Unknown |  |
| usage | Unknown |  |
| wholesale_charges | Unknown |  |
| withheld | Unknown |  |

### gcp_marketplace_charge_and_usage_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned | Unknown |  |
| account_id | Unknown |  |
| billing_frequency | Unknown |  |
| charges | Unknown |  |
| currency | Unknown |  |
| ds | Unknown |  |
| due_partner | Unknown |  |
| google_entity | Unknown |  |
| insights_account_id | Unknown |  |
| location | Unknown |  |
| payment_schedule | Unknown |  |
| payment_type | Unknown |  |
| postpay_credits | Unknown |  |
| prepay_credits | Unknown |  |
| probation_end | Unknown |  |
| probation_start | Unknown |  |
| refund_balance_deducted_this_month | Unknown |  |
| refund_balance_outstanding | Unknown |  |
| refund_period_end | Unknown |  |
| refund_period_start | Unknown |  |
| refund_reason | Unknown |  |
| released | Unknown |  |
| resource | Unknown |  |
| sku | Unknown |  |
| trial_use | Unknown |  |
| units | Unknown |  |
| usage | Unknown |  |
| used_by | Unknown |  |
| withheld | Unknown |  |

### gcp_marketplace_monthly_insight

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned | Unknown |  |
| account_id | Unknown |  |
| billing_frequency | Unknown |  |
| channel | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| ds | Unknown |  |
| due_vendor | Unknown |  |
| earliest | Unknown |  |
| end_date | Unknown |  |
| entitlement_id | Unknown |  |
| external_account_id | Unknown |  |
| final_installment_date | Unknown |  |
| first_installment_date | Unknown |  |
| gpu_types | Unknown |  |
| installment_count | Unknown |  |
| internal_note | Unknown |  |
| latest | Unknown |  |
| machine_spec_sum | Unknown |  |
| num_cpus | Unknown |  |
| num_gpus | Unknown |  |
| num_vms | Unknown |  |
| offer_title | Unknown |  |
| order_end_date | Unknown |  |
| order_start_date | Unknown |  |
| parent_account_id | Unknown |  |
| payment_schedule | Unknown |  |
| payment_type | Unknown |  |
| postal_code | Unknown |  |
| postpay_credits | Unknown |  |
| prepay_credits | Unknown |  |
| private_offer_acceptance_date | Unknown |  |
| private_offer_total_contract_value | Unknown |  |
| probation_end | Unknown |  |
| probation_start | Unknown |  |
| quote_creator | Unknown |  |
| quote_id | Unknown |  |
| ram_mb | Unknown |  |
| released | Unknown |  |
| reseller_discount | Unknown |  |
| sku_description | Unknown |  |
| sku_id | Unknown |  |
| solution_name | Unknown |  |
| start_date | Unknown |  |
| state_or_province | Unknown |  |
| transaction_type | Unknown |  |
| trial_use | Unknown |  |
| unit | Unknown |  |
| usage | Unknown |  |
| wholesale_charges | Unknown |  |
| withheld | Unknown |  |

### aws_marketplace_revenue_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_acceptance_date | Unknown |  |
| agreement_end_date | Unknown |  |
| agreement_id | Unknown |  |
| agreement_start_date | Unknown |  |
| aws_seller_of_record | Unknown |  |
| aws_tax_share | Unknown |  |
| aws_tax_share_listing_fee | Unknown |  |
| aws_tax_share_refund | Unknown |  |
| aws_tax_share_refund_listing_fee | Unknown |  |
| currency | Unknown |  |
| customer_reference_id | Unknown |  |
| disburse_bank_trace_id | Unknown |  |
| disbursement_date | Unknown |  |
| disbursement_status | Unknown |  |
| gross_refund | Unknown |  |
| gross_revenue | Unknown |  |
| invoice_date | Unknown |  |
| invoice_id | Unknown |  |
| isv_account_id | Unknown |  |
| isv_company_name | Unknown |  |
| legacy_product_id | Unknown |  |
| listing_fee | Unknown |  |
| listing_fee_invoice_id | Unknown |  |
| listing_fee_percentage | Unknown |  |
| listing_fee_refund | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_visibility | Unknown |  |
| payer_address_id | Unknown |  |
| payer_aws_account_id | Unknown |  |
| payer_city | Unknown |  |
| payer_company_name | Unknown |  |
| payer_country | Unknown |  |
| payer_email_domain | Unknown |  |
| payer_postal_code | Unknown |  |
| payer_state_or_region | Unknown |  |
| payment_due_date | Unknown |  |
| payment_terms | Unknown |  |
| product_code | Unknown |  |
| product_id | Unknown |  |
| product_title | Unknown |  |
| resale_authorization_description | Unknown |  |
| resale_authorization_id | Unknown |  |
| resale_authorization_name | Unknown |  |
| reseller_aws_account_id | Unknown |  |
| reseller_company_name | Unknown |  |
| seller_net_revenue | Unknown |  |
| seller_tax_share | Unknown |  |
| seller_tax_share_refund | Unknown |  |
| subscriber_address_id | Unknown |  |
| subscriber_aws_account_id | Unknown |  |
| subscriber_city | Unknown |  |
| subscriber_company_name | Unknown |  |
| subscriber_country | Unknown |  |
| subscriber_email_domain | Unknown |  |
| subscriber_postal_code | Unknown |  |
| subscriber_state_or_region | Unknown |  |
| transaction_reference_id | Unknown |  |
| usage_period_end_date | Unknown |  |
| usage_period_start_date | Unknown |  |
| wholesale_cost | Unknown |  |
| wholesale_cost_refund | Unknown |  |

### azure_marketplace_customer_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| address_line_1 | Unknown |  |
| azure_license_type | Unknown |  |
| billing_account_id | Unknown |  |
| billing_id | Unknown |  |
| commerce_root_customer | Unknown |  |
| customer_city | Unknown |  |
| customer_company_name | Unknown |  |
| customer_country_region | Unknown |  |
| customer_id | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state | Unknown |  |
| customer_type | Unknown |  |
| dataset_month | Unknown |  |
| date_acquired | Unknown |  |
| date_lost | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| is_private_plan | Unknown |  |
| last_modified_at | Unknown |  |
| last_name | Unknown |  |
| marketplace_subscription_id | Unknown |  |
| multi_party | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_type | Unknown |  |
| plan_id | Unknown |  |
| plan_visibility | Unknown |  |
| private_offer_id | Unknown |  |
| private_offer_name | Unknown |  |
| promotional_customers | Unknown |  |
| provider_email | Unknown |  |
| provider_name | Unknown |  |
| purchaser_email | Unknown |  |
| reference_id | Unknown |  |
| sku | Unknown |  |

### aws_marketplace_disbursement_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agreement_acceptance_date | Unknown |  |
| agreement_end_date | Unknown |  |
| agreement_id | Unknown |  |
| agreement_start_date | Unknown |  |
| aws_seller_of_record | Unknown |  |
| aws_tax_share_listing_fee | Unknown |  |
| aws_tax_share_refund_listing_fee | Unknown |  |
| currency | Unknown |  |
| customer_reference_id | Unknown |  |
| disburse_bank_trace_id | Unknown |  |
| disbursed_net_revenue | Unknown |  |
| disbursement_date | Unknown |  |
| disbursement_period | Unknown |  |
| disbursement_status | Unknown |  |
| disbursement_time_in_days | Unknown |  |
| gross_refund | Unknown |  |
| gross_revenue | Unknown |  |
| invoice_date | Unknown |  |
| invoice_id | Unknown |  |
| isv_account_id | Unknown |  |
| isv_company_name | Unknown |  |
| legacy_product_id | Unknown |  |
| listing_fee | Unknown |  |
| listing_fee_invoice_id | Unknown |  |
| listing_fee_percentage | Unknown |  |
| listing_fee_refund | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_visibility | Unknown |  |
| payer_address_id | Unknown |  |
| payer_aws_account_id | Unknown |  |
| payer_city | Unknown |  |
| payer_company_name | Unknown |  |
| payer_country | Unknown |  |
| payer_email_domain | Unknown |  |
| payer_postal_code | Unknown |  |
| payer_state_or_region | Unknown |  |
| payment_due_date | Unknown |  |
| payment_terms | Unknown |  |
| product_code | Unknown |  |
| product_id | Unknown |  |
| product_title | Unknown |  |
| resale_authorization_description | Unknown |  |
| resale_authorization_id | Unknown |  |
| resale_authorization_name | Unknown |  |
| reseller_aws_account_id | Unknown |  |
| reseller_company_name | Unknown |  |
| seller_net_revenue | Unknown |  |
| seller_tax_share | Unknown |  |
| seller_tax_share_refund | Unknown |  |
| subscriber_address_id | Unknown |  |
| subscriber_aws_account_id | Unknown |  |
| subscriber_city | Unknown |  |
| subscriber_company_name | Unknown |  |
| subscriber_country | Unknown |  |
| subscriber_email_domain | Unknown |  |
| subscriber_postal_code | Unknown |  |
| subscriber_state_or_region | Unknown |  |
| transaction_reference_id | Unknown |  |
| undisbursed_net_revenue | Unknown |  |
| usage_period_end_date | Unknown |  |
| usage_period_start_date | Unknown |  |
| wholesale_cost | Unknown |  |
| wholesale_cost_refund | Unknown |  |

### gcp_marketplace_daily_insight

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned | Unknown |  |
| account_id | Unknown |  |
| billing_frequency | Unknown |  |
| channel | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| ds | Unknown |  |
| due_vendor | Unknown |  |
| earliest | Unknown |  |
| end_date | Unknown |  |
| entitlement_id | Unknown |  |
| external_account_id | Unknown |  |
| final_installment_date | Unknown |  |
| first_installment_date | Unknown |  |
| gpu_types | Unknown |  |
| installment_count | Unknown |  |
| internal_note | Unknown |  |
| latest | Unknown |  |
| machine_spec_sum | Unknown |  |
| num_cpus | Unknown |  |
| num_gpus | Unknown |  |
| num_vms | Unknown |  |
| offer_title | Unknown |  |
| order_end_date | Unknown |  |
| order_start_date | Unknown |  |
| parent_account_id | Unknown |  |
| payment_schedule | Unknown |  |
| payment_type | Unknown |  |
| postal_code | Unknown |  |
| postpay_credits | Unknown |  |
| prepay_credits | Unknown |  |
| private_offer_acceptance_date | Unknown |  |
| private_offer_total_contract_value | Unknown |  |
| probation_end | Unknown |  |
| probation_start | Unknown |  |
| quote_creator | Unknown |  |
| quote_id | Unknown |  |
| ram_mb | Unknown |  |
| released | Unknown |  |
| reseller_discount | Unknown |  |
| sku_description | Unknown |  |
| sku_id | Unknown |  |
| solution_name | Unknown |  |
| start_date | Unknown |  |
| state_or_province | Unknown |  |
| term_total_contract_value | Unknown |  |
| transaction_type | Unknown |  |
| trial_use | Unknown |  |
| unit | Unknown |  |
| usage | Unknown |  |
| wholesale_charges | Unknown |  |
| withheld | Unknown |  |

### azure_cosell_opportunity_customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |

### azure_cosell_opportunity_target

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### azure_cosell_opportunity_partner_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| defaults | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |

### azure_cosell_opportunity_microsoft_sales_rep

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |

### azure_cosell_opportunity_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| tags | Unknown |  |

### azure_cosell_opportunity_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| accepted_date_time | Unknown |  |
| address | Unknown |  |
| assistance_type | Unknown |  |
| azure_seller_id | Unknown |  |
| city | Unknown |  |
| closed_date_time | Unknown |  |
| closing_date_time | Unknown |  |
| cloud | Unknown |  |
| cloud_created_at | Unknown |  |
| cloud_status | Unknown |  |
| consent_to_contact | Unknown |  |
| consent_to_share_referral_with_microsoft_sellers | Unknown |  |
| consent_to_to_share_info_with_others | Unknown |  |
| country | Unknown |  |
| created_by_id | Unknown |  |
| created_date_time | Unknown |  |
| currency | Unknown |  |
| customer_company_name | Unknown |  |
| customer_duns_number | Unknown |  |
| customer_website | Unknown |  |
| deal_name | Unknown |  |
| deal_type | Unknown |  |
| deal_value | Unknown |  |
| direction | Unknown |  |
| domain_info_category | Unknown |  |
| engagement_id | Unknown |  |
| expiration_date_time | Unknown |  |
| external_id | Unknown |  |
| external_status | Unknown |  |
| id | Unknown |  |
| is_macc_eligible | Unknown |  |
| is_matching_complete | Unknown |  |
| is_spam | Unknown |  |
| metadata | Json |  |
| microsoft_account_id | Unknown |  |
| microsoft_duns_number | Unknown |  |
| microsoft_sales_rep_1_id | Unknown |  |
| microsoft_sales_rep_2_id | Unknown |  |
| microsoft_sales_rep_3_id | Unknown |  |
| microsoft_sales_rep_4_id | Unknown |  |
| microsoft_sales_rep_id | Unknown |  |
| notes | Unknown |  |
| organization_id | Unknown |  |
| organization_name | Unknown |  |
| postal_code | Unknown |  |
| qualification | Unknown |  |
| referral_id | Unknown |  |
| referral_source | Unknown |  |
| row_number | Unknown |  |
| sales_stage | Unknown |  |
| seller_created_at | Unknown |  |
| solutions | Json |  |
| state | Unknown |  |
| status | Unknown |  |
| status_reason | Unknown |  |
| sub_status | Unknown |  |
| sync_error | Json |  |
| updated_date_time | Unknown |  |
| uuid | Unknown |  |
| shared_referral_** |  |  |

### aws_cosell_opportunity_analytics_sales_activity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| sales_activity | Unknown |  |

### aws_cosell_opportunity_analytics_next_step_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| next_step_author | Unknown |  |
| next_step_date | Unknown |  |
| next_step_value | Unknown |  |

### aws_cosell_opportunity_analytics_delivery_model

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| delivery_model | Unknown |  |

### aws_cosell_opportunity_analytics_offer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| offer | Unknown |  |

### aws_cosell_opportunity_analytics_campaign_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| campaign_name | Unknown |  |

### aws_cosell_opportunity_analytics_aws_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| aws_product | Unknown |  |

### aws_cosell_opportunity_analytics_solution_offered

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fivetran_id | Unknown | PK, FK |
| solution_offered | Unknown |  |

### aws_cosell_opportunity_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| accept_by | Unknown |  |
| additional_comments | Unknown |  |
| apn_crm_unique_identifier | Unknown |  |
| apn_disqualified_reason | Unknown |  |
| apn_reviewer_comments | Unknown |  |
| aws_account_owner_email | Unknown |  |
| aws_account_owner_name | Unknown |  |
| aws_close_date | Unknown |  |
| aws_isv_success_manager_email | Unknown |  |
| aws_isv_success_manager_name | Unknown |  |
| aws_marketplace_engagement_score | Unknown |  |
| aws_partner_success_manager_email | Unknown |  |
| aws_partner_success_manager_name | Unknown |  |
| aws_sales_rep_email | Unknown |  |
| aws_sales_rep_name | Unknown |  |
| aws_stage | Unknown |  |
| business_unit | Unknown |  |
| closed_lost_reason | Unknown |  |
| cloud_created_date | Unknown |  |
| contract_end_date | Unknown |  |
| contract_start_date | Unknown |  |
| country | Unknown |  |
| customer_company_name | Unknown |  |
| customer_email | Unknown |  |
| customer_first_name | Unknown |  |
| customer_last_name | Unknown |  |
| customer_phone | Unknown |  |
| customer_software_value | Unknown |  |
| customer_website | Unknown |  |
| expected_monthly_aws_revenue | Unknown |  |
| geo | Unknown |  |
| industry | Unknown |  |
| is_greenfield | Unknown |  |
| is_marketing_development_funded | Unknown |  |
| is_opp_from_marketing_activity | Unknown |  |
| last_modified_date | Unknown |  |
| next_step | Unknown |  |
| opportunity_owner_email | Unknown |  |
| opportunity_ownership | Unknown |  |
| opportunity_type | Unknown |  |
| other_solution_offered | Unknown |  |
| partner_acceptance_status | Unknown |  |
| partner_developer_manager_email | Unknown |  |
| partner_developer_manager_name | Unknown |  |
| partner_primary_need_from_aws | Json |  |
| partner_project_title | Unknown |  |
| postal_code | Unknown |  |
| primary_contact_email | Unknown |  |
| primary_contact_first_name | Unknown |  |
| primary_contact_last_name | Unknown |  |
| primary_contact_phone | Unknown |  |
| procurement_type | Unknown |  |
| project_description | Unknown |  |
| recommended_next_best_actions | Unknown |  |
| region | Unknown |  |
| rejection_reason | Unknown |  |
| sale_stage | Unknown |  |
| segment | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| target_close_date | Unknown |  |
| use_case | Unknown |  |
| uuid | Unknown |  |

### metering

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | FK |
| cloud | Unknown |  |
| dimemsion | Unknown |  |
| end_time | Unknown |  |
| quantity | Unknown |  |
| start_time | Instant |  |
| status | Unknown |  |
| custom_** |  |  |

### gcp_marketplace_disbursement_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount | Unknown |  |
| currency | Unknown |  |
| customer_refund | Unknown |  |
| ds | Unknown |  |
| entity | Unknown |  |
| notes | Unknown |  |
| payment_type | Unknown |  |
| total | Unknown |  |
| withholding | Unknown |  |

### gcp_marketplace_incremental_daily_insight

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned | Unknown |  |
| account_id | Unknown |  |
| billing_frequency | Unknown |  |
| channel | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| domain | Unknown |  |
| ds | Unknown |  |
| due_vendor | Unknown |  |
| earliest | Unknown |  |
| end_date | Unknown |  |
| entitlement_id | Unknown |  |
| external_account_id | Unknown |  |
| final_installment_date | Unknown |  |
| first_installment_date | Unknown |  |
| gpu_types | Unknown |  |
| installment_count | Unknown |  |
| internal_note | Unknown |  |
| latest | Unknown |  |
| machine_spec_sum | Unknown |  |
| num_cpus | Unknown |  |
| num_gpus | Unknown |  |
| num_vms | Unknown |  |
| offer_title | Unknown |  |
| order_end_date | Unknown |  |
| order_start_date | Unknown |  |
| parent_account_id | Unknown |  |
| payment_schedule | Unknown |  |
| payment_type | Unknown |  |
| postal_code | Unknown |  |
| postpay_credits | Unknown |  |
| prepay_credits | Unknown |  |
| private_offer_acceptance_date | Unknown |  |
| private_offer_total_contract_value | Unknown |  |
| probation_end | Unknown |  |
| probation_start | Unknown |  |
| quote_creator | Unknown |  |
| quote_id | Unknown |  |
| ram_mb | Unknown |  |
| released | Unknown |  |
| report_date | Unknown |  |
| reseller_discount | Unknown |  |
| sku_description | Unknown |  |
| sku_id | Unknown |  |
| solution_name | Unknown |  |
| start_date | Unknown |  |
| state_or_province | Unknown |  |
| term_total_contract_value | Unknown |  |
| transaction_type | Unknown |  |
| trial_use | Unknown |  |
| unit | Unknown |  |
| usage | Unknown |  |
| wholesale_charges | Unknown |  |
| withheld | Unknown |  |

### azure_marketplace_order_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown |  |
| auto_renew | Unknown |  |
| azure_license_type | Unknown |  |
| billed_revenue | Unknown |  |
| billing_account_id | Unknown |  |
| billing_id | Unknown |  |
| billing_plan | Unknown |  |
| billing_term | Unknown |  |
| cloud_instance_name | Unknown |  |
| currency | Unknown |  |
| customer_company_name | Unknown |  |
| customer_country | Unknown |  |
| customer_id | Unknown |  |
| dataset_month | Unknown |  |
| discount_price_usd | Unknown |  |
| event_timestamp | Unknown |  |
| has_trial | Unknown |  |
| is_new_customer | Unknown |  |
| is_preview_sku | Unknown |  |
| is_private_offer | Unknown |  |
| is_private_plan | Unknown |  |
| is_trial | Unknown |  |
| list_price_usd | Unknown |  |
| marketplace_license_type | Unknown |  |
| marketplace_subscription_id | Unknown |  |
| month_start_date | Unknown |  |
| multi_party | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_type | Unknown |  |
| offer_visibility | Unknown |  |
| order_action | Unknown |  |
| order_cancel_date | Unknown |  |
| order_purchase_date | Unknown |  |
| order_status | Unknown |  |
| order_version | Unknown |  |
| plan_id | Unknown |  |
| plan_visibility | Unknown |  |
| private_offer_id | Unknown |  |
| private_offer_name | Unknown |  |
| purchase_record_id | Unknown |  |
| purchase_record_line_item_id | Unknown |  |
| quantity | Unknown |  |
| quantity_changed | Unknown |  |
| reference_id | Unknown |  |
| sku | Unknown |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| trial_end_date | Unknown |  |
| version | Unknown |  |

### azure_marketplace_revenue_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| adjustment_reason_code | Unknown |  |
| adjustment_type | Unknown |  |
| asset_id | Unknown |  |
| billing_account_id | Unknown |  |
| billing_id | Unknown |  |
| billing_model | Unknown |  |
| customer_city | Unknown |  |
| customer_company_name | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state | Unknown |  |
| dataset_month | Unknown |  |
| days_uncollected | Unknown |  |
| discounted_price_usd | Unknown |  |
| earning_amount_cc | Unknown |  |
| earning_amount_pc | Unknown |  |
| earning_amount_usd | Unknown |  |
| earning_currency_code | Unknown |  |
| earning_exchange_rate_pc | Unknown |  |
| earning_id | Unknown |  |
| estimated_payout_month | Unknown |  |
| estimated_revenue_pc | Unknown |  |
| estimated_revenue_usd | Unknown |  |
| event_time_stamp | Unknown |  |
| exchange_rate_date | Unknown |  |
| exchange_rate_pc | Unknown |  |
| exchange_rate_usd | Unknown |  |
| incentive_rate | Unknown |  |
| invoice_date | Unknown |  |
| invoice_due_date | Unknown |  |
| invoice_id | Unknown |  |
| is_invoiced | Unknown |  |
| is_private_offer | Unknown |  |
| is_private_plan | Unknown |  |
| line_item_id | Unknown |  |
| list_price_usd | Unknown |  |
| month_start_date | Unknown |  |
| multi_party | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_type | Unknown |  |
| offer_visibility | Unknown |  |
| payment_instrument_type | Unknown |  |
| payment_sent_date | Unknown |  |
| payout_currency | Unknown |  |
| payout_status | Unknown |  |
| plan_id | Unknown |  |
| plan_visibility | Unknown |  |
| private_offer_id | Unknown |  |
| private_offer_name | Unknown |  |
| purchase_record_id | Unknown |  |
| quantity | Unknown |  |
| reseller_city | Unknown |  |
| reseller_company | Unknown |  |
| reseller_country | Unknown |  |
| reseller_email | Unknown |  |
| reseller_id | Unknown |  |
| reseller_postal_code | Unknown |  |
| reseller_state | Unknown |  |
| revenue | Unknown |  |
| sales_channel | Unknown |  |
| sku | Unknown |  |
| term_end_date | Unknown |  |
| term_start_date | Unknown |  |
| transaction_amount_cc | Unknown |  |
| transaction_amount_pc | Unknown |  |
| transaction_amount_usd | Unknown |  |
| transaction_currency | Unknown |  |
| trial_deployment | Unknown |  |
| units | Unknown |  |

### gcp_marketplace_disbursement_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| abandoned_amount | Unknown |  |
| account_id | Unknown |  |
| aggregated_payout | Unknown |  |
| billing_frequency | Unknown |  |
| c_u_account_id | Unknown |  |
| channel | Unknown |  |
| country | Unknown |  |
| cud_credits_used | Unknown |  |
| cust_charges | Unknown |  |
| cust_identity | Unknown |  |
| cust_organization | Unknown |  |
| cust_remaining_commit | Unknown |  |
| disbursement_entity | Unknown |  |
| discount_offered | Unknown |  |
| domain | Unknown |  |
| ds | Unknown |  |
| entitlement_end_date | Unknown |  |
| entitlement_id | Unknown |  |
| entitlement_start_date | Unknown |  |
| final_installment_date | Unknown |  |
| first_installment_date | Unknown |  |
| first_refund_date | Unknown |  |
| insights_account_id | Unknown |  |
| installment_count | Unknown |  |
| last_refund_date | Unknown |  |
| marketplace_fee_amount | Unknown |  |
| marketplace_fee_percent | Unknown |  |
| max_usage_start_time | Unknown |  |
| min_usage_start_time | Unknown |  |
| offer_title | Unknown |  |
| order_end_date | Unknown |  |
| order_start_date | Unknown |  |
| organization_id | Unknown |  |
| partner_testing_credit | Unknown |  |
| payment_schedule | Unknown |  |
| postal_code | Unknown |  |
| private_offer_acceptance_date | Unknown |  |
| private_offer_creator | Unknown |  |
| private_offer_id | Unknown |  |
| private_offer_notes | Unknown |  |
| probation_start_date | Unknown |  |
| refund_processed_date | Unknown |  |
| refund_reason | Unknown |  |
| released_amount | Unknown |  |
| replaced_private_offer_id | Unknown |  |
| report_creation_date | Unknown |  |
| report_timezone | Unknown |  |
| reseller_discount | Unknown |  |
| sku_description | Unknown |  |
| sku_id | Unknown |  |
| solution_id | Unknown |  |
| solution_name | Unknown |  |
| state_or_province | Unknown |  |
| term_total_contract_value | Unknown |  |
| total_contract_value | Unknown |  |
| total_deductions | Unknown |  |
| transaction_type | Unknown |  |
| trial_credits_used | Unknown |  |
| usage_quantity | Unknown |  |
| usage_unit | Unknown |  |
| wholesale_charges | Unknown |  |
| withheld_amount | Unknown |  |

### azure_marketplace_metered_usage_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown |  |
| azure_license_type | Unknown |  |
| billing_account_id | Unknown |  |
| billing_id | Unknown |  |
| cloud_instance_name | Unknown |  |
| core_size | Unknown |  |
| customer_company_name | Unknown |  |
| customer_country | Unknown |  |
| customer_currency_cc | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| dataset_month | Unknown |  |
| deployment_method | Unknown |  |
| discounted_price_usd | Unknown |  |
| estimated_extended_charge_cc | Unknown |  |
| estimated_extended_charge_pc | Unknown |  |
| estimated_financial_impact_usd | Unknown |  |
| estimated_price_pc | Unknown |  |
| is_custom_meter | Unknown |  |
| is_multisolution | Unknown |  |
| is_new_customer | Unknown |  |
| is_preview_sku | Unknown |  |
| is_private_offer | Unknown |  |
| is_private_plan | Unknown |  |
| list_price_usd | Unknown |  |
| marketplace_license_type | Unknown |  |
| marketplace_subscription_id | Unknown |  |
| meter_dimension | Unknown |  |
| meter_id | Unknown |  |
| metered_usage | Unknown |  |
| month_start_date | Unknown |  |
| multi_party | Unknown |  |
| normalized_usage | Unknown |  |
| offer_id | Unknown |  |
| offer_name | Unknown |  |
| offer_type | Unknown |  |
| offer_visibility | Unknown |  |
| partner_center_detected_anomaly | Unknown |  |
| payout_currency_pc | Unknown |  |
| plan_id | Unknown |  |
| plan_visibility | Unknown |  |
| price_cc | Unknown |  |
| private_offer_id | Unknown |  |
| private_offer_name | Unknown |  |
| raw_usage | Unknown |  |
| reference_id | Unknown |  |
| sku | Unknown |  |
| skubilling_type | Unknown |  |
| usage_date | Unknown |  |
| usage_reference | Unknown |  |
| usage_unit | Unknown |  |
| vmsize | Unknown |  |
| vmsubscription | Unknown |  |

### listing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cloud | Unknown |  |
| cloud_id | Unknown |  |
| cloud_url | Unknown |  |
| eula_type | Unknown |  |
| eula_url | Unknown |  |
| last_modified_at | Unknown |  |
| long_description | Unknown |  |
| metadata | Json |  |
| short_description | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |

### private_offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| listing_id | Unknown | FK |
| accepted_at | Unknown |  |
| archived | Unknown |  |
| buyer_cloud_id | Unknown |  |
| buyer_company_name | Unknown |  |
| cloud | Unknown |  |
| cloud_id | Unknown |  |
| cloud_url | Unknown |  |
| duration | Unknown |  |
| end_date | Unknown |  |
| eula_type | Unknown |  |
| expiration_at | Unknown |  |
| last_modified_at | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| offer_type | Unknown |  |
| published_at | Unknown |  |
| salesforce_mapped_object_id | Unknown |  |
| salesforce_mapped_object_name | Unknown |  |
| salesforce_mapped_object_type | Unknown |  |
| salesforce_mapped_object_url | Unknown |  |
| salesforce_writeback_object_clazar_created | Unknown |  |
| salesforce_writeback_object_id | Unknown |  |
| salesforce_writeback_object_last_writeback_at | Unknown |  |
| salesforce_writeback_object_type | Unknown |  |
| salesforce_writeback_object_url | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| custom_** |  |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| buyer_id | Unknown | FK |
| latest_offer_id | Unknown | FK |
| listing_id | Unknown | FK |
| accepted_at | Unknown |  |
| auto_renew | Unknown |  |
| cloud | Unknown |  |
| cloud_id | Unknown |  |
| cloud_url | Unknown |  |
| duration | Unknown |  |
| end_at | Unknown |  |
| last_modified_at | Unknown |  |
| metadata | Json |  |
| offer_type | Unknown |  |
| orb_mapped_object | Json |  |
| salesforce_writeback_object_clazar_created | Unknown |  |
| salesforce_writeback_object_id | Unknown |  |
| salesforce_writeback_object_last_writeback_at | Unknown |  |
| salesforce_writeback_object_type | Unknown |  |
| salesforce_writeback_object_url | Unknown |  |
| start_at | Unknown |  |
| status | Unknown |  |
| total_contract_value | Unknown |  |
| custom_** |  |  |

### buyer_registration_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| buyer_id | Unknown | PK, FK |
| field | Unknown |  |
| value | Unknown |  |

### buyer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| latest_contract_id | Unknown | FK |
| listing_id | Unknown | FK |
| cloud | Unknown |  |
| cloud_account_id | Unknown |  |
| domain | Unknown |  |
| last_modified_at | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| orb_mapped_object | Json |  |
| salesforce_writeback_object_clazar_created | Unknown |  |
| salesforce_writeback_object_id | Unknown |  |
| salesforce_writeback_object_last_writeback_at | Unknown |  |
| salesforce_writeback_object_type | Unknown |  |
| salesforce_writeback_object_url | Unknown |  |
| status | Unknown |  |
| custom_** |  |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accept_by | Unknown |  |
| cloud | Unknown |  |
| cloud_id | Unknown |  |
| cloud_url | Unknown |  |
| created_at | Unknown |  |
| customer_company | Unknown |  |
| customer_website | Unknown |  |
| last_modified_at | Unknown |  |
| metadata | Json |  |
| salesforce_mapped_object_id | Unknown |  |
| salesforce_mapped_object_name | Unknown |  |
| salesforce_mapped_object_type | Unknown |  |
| salesforce_mapped_object_url | Unknown |  |
| salesforce_writeback_object_clazar_created | Unknown |  |
| salesforce_writeback_object_id | Unknown |  |
| salesforce_writeback_object_last_writeback_at | Unknown |  |
| salesforce_writeback_object_type | Unknown |  |
| salesforce_writeback_object_url | Unknown |  |
| stage | Unknown |  |
| status | Unknown |  |
| target_close_date | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

## Relationships

- azure_cosell_opportunity_customer_contact(fivetran_id) → azure_cosell_opportunity_analytics(_fivetran_id)
- azure_cosell_opportunity_target(fivetran_id) → azure_cosell_opportunity_analytics(_fivetran_id)
- azure_cosell_opportunity_partner_contact(fivetran_id) → azure_cosell_opportunity_analytics(_fivetran_id)
- azure_cosell_opportunity_microsoft_sales_rep(fivetran_id) → azure_cosell_opportunity_analytics(_fivetran_id)
- azure_cosell_opportunity_tag(fivetran_id) → azure_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_sales_activity(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_next_step_detail(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_delivery_model(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_offer(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_campaign_name(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_aws_product(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- aws_cosell_opportunity_analytics_solution_offered(fivetran_id) → aws_cosell_opportunity_analytics(_fivetran_id)
- metering(contract_id) → contract(id)
- private_offer(listing_id) → listing(id)
- contract(listing_id) → listing(id)
- contract(buyer_id) → buyer(id)
- contract(latest_offer_id) → private_offer(id)
- buyer_registration_detail(buyer_id) → buyer(id)
- buyer(listing_id) → listing(id)
- buyer(latest_contract_id) → contract(id)