Clazar

Explore the interactive ERD

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	PKFK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone_number`	Unknown

azure_cosell_opportunity_target

Column	Type	Keys
`id`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown

azure_cosell_opportunity_partner_contact

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`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	PKFK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone_number`	Unknown

azure_cosell_opportunity_tag

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`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	PKFK
`sales_activity`	Unknown

aws_cosell_opportunity_analytics_next_step_detail

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`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	PKFK
`delivery_model`	Unknown

aws_cosell_opportunity_analytics_offer

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`offer`	Unknown

aws_cosell_opportunity_analytics_campaign_name

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`campaign_name`	Unknown

aws_cosell_opportunity_analytics_aws_product

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`aws_product`	Unknown

aws_cosell_opportunity_analytics_solution_offered

Column	Type	Keys
`index`	Unknown	PK
`fivetran_id`	Unknown	PKFK
`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	PKFK
`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_`