If using Legacy CUR and cur-proxy, cid-cmd deployment fails to deploy data transfer dashboard, graviton savings dashboard, extended support cost projection dashboard, SCAD Containers Cost Allocation Dashboard

[bijalp19]

The Issue is cur_proxy view is missing columns needed for the views for data transfer dashboard, graviton savings dashboard , extended support cost projection dashboard, SCAD Containers Cost Allocation Dashboard. I added the missing columns in cur_proxy, and then deployed the dashboards.

Note:SCAD Dashboard still fails and I have created a seperate issue because it is failing with a different error after adding the missing columns.

Here is the cur_proxy view -

CREATE OR REPLACE VIEW "cur2_proxy" AS SELECT bill_bill_type bill_bill_type , bill_billing_entity bill_billing_entity , bill_billing_period_end_date bill_billing_period_end_date , bill_billing_period_start_date bill_billing_period_start_date , bill_invoice_id bill_invoice_id , bill_payer_account_id bill_payer_account_id , concat('name', "bill_payer_account_id") bill_payer_account_name , concat("year", '-', "month") billing_period , identity_line_item_id identity_line_item_id , identity_time_interval identity_time_interval , line_item_availability_zone line_item_availability_zone , line_item_blended_rate line_item_blended_rate , line_item_unblended_rate line_item_unblended_rate , line_item_legal_entity line_item_legal_entity , line_item_line_item_description line_item_line_item_description , line_item_line_item_type line_item_line_item_type , line_item_operation line_item_operation , line_item_product_code line_item_product_code , line_item_resource_id line_item_resource_id , line_item_blended_cost line_item_blended_cost , line_item_normalized_usage_amount line_item_normalized_usage_amount , line_item_unblended_cost line_item_unblended_cost , line_item_usage_account_id line_item_usage_account_id , concat('name', "line_item_usage_account_id") line_item_usage_account_name , line_item_usage_amount line_item_usage_amount , line_item_usage_end_date line_item_usage_end_date , line_item_usage_start_date line_item_usage_start_date , line_item_usage_type line_item_usage_type , pricing_lease_contract_length pricing_lease_contract_length , pricing_offering_class pricing_offering_class , pricing_public_on_demand_rate pricing_public_on_demand_rate , pricing_public_on_demand_cost pricing_public_on_demand_cost , pricing_purchase_option pricing_purchase_option , pricing_term pricing_term , pricing_unit pricing_unit , MAP(ARRAY['cache_engine','current_generation','database_engine','deployment_option','group','instance_type_family','license_model','operating_system','physical_processor','processor_features','product_name','region','storage','tenancy','volume_api_name','volume_type'], ARRAY[product_cache_engine,product_current_generation,product_database_engine,product_deployment_option,product_group,product_instance_type_family,product_license_model,product_operating_system,product_physical_processor,product_processor_features,product_product_name,product_region,product_storage,product_tenancy,product_volume_api_name,product_volume_type]) product , product_location product_location , product_from_location product_from_location , product_from_location_type product_from_location_type , product_instance_type product_instance_type , product_product_family product_product_family , product_servicecode product_servicecode , product_to_location product_to_location , reservation_amortized_upfront_fee_for_billing_period reservation_amortized_upfront_fee_for_billing_period , reservation_effective_cost reservation_effective_cost , reservation_end_time reservation_end_time , reservation_reservation_a_r_n reservation_reservation_a_r_n , reservation_start_time reservation_start_time , reservation_unused_amortized_upfront_fee_for_billing_period reservation_unused_amortized_upfront_fee_for_billing_period , reservation_unused_recurring_fee reservation_unused_recurring_fee , savings_plan_amortized_upfront_commitment_for_billing_period savings_plan_amortized_upfront_commitment_for_billing_period , savings_plan_end_time savings_plan_end_time , savings_plan_offering_type savings_plan_offering_type , savings_plan_payment_option savings_plan_payment_option , savings_plan_purchase_term savings_plan_purchase_term , savings_plan_savings_plan_a_r_n savings_plan_savings_plan_a_r_n , savings_plan_savings_plan_effective_cost savings_plan_savings_plan_effective_cost , savings_plan_start_time savings_plan_start_time , savings_plan_total_commitment_to_date savings_plan_total_commitment_to_date , savings_plan_used_commitment savings_plan_used_commitment , split_line_item_parent_resource_id split_line_item_parent_resource_id , product_instance_family product_instance_family , resource_tags_aws_created_by resource_tags_aws_created_by , resource_tags_aws_eks_cluster_name resource_tags_aws_eks_cluster_name , resource_tags_aws_eks_deployment resource_tags_aws_eks_deployment , resource_tags_aws_eks_namespace resource_tags_aws_eks_namespace , resource_tags_aws_eks_node resource_tags_aws_eks_node , resource_tags_aws_eks_workload_name resource_tags_aws_eks_workload_name , resource_tags_aws_eks_workload_type resource_tags_aws_eks_workload_type FROM "cid_cur"."cur"