SalesCrmProd-PipelineItemHistory - Need to Update
SalesCrmProd-Record - NA
SalesCrmProd-RecordFieldResponse - Done
SalesCrmProd-Task - Done
SalesCrmProd-Activity - Done
SalesCrmProd-CallLog - Done
Rough

Planning For Cost Optimization (~50% Cost will Reduce) - (Timeline: 2024-07-04)

Dynamodb Tables (except PipelineItemHistory) - Done
- changes - done
Check the remaining schedule queries - Done
SalesCrmProd-PipelineItemHistory
- 30% duplicate is present so need to change as latest
- need to add the pipeline_id
Partition Injection time logic
- dependency (dynamodb refresh)

schedule query	respective routine	status
Cron-Nxtwave-NIAT I&E -LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Academy-SSC-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-Affiliate-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Intensive-LookerStudioAnalyticsDataSyncQuery	generate_table_with_specific_fields	Done
Cron-SuperK-AdvancedAnalyticsDataSyncQuery
Cron-Nxtwave-AdvancedAnalyticsDataSyncQuery	generate_view_for_pipelineitem	Done
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_lead_index_for_specific_pipeline	Done
Cron-Nxtwave-Academy-SSC-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-Affiliate-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Intensive-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_task_table_for_specific_pipeline	Done
Cron-SuperK-AdvancedAnalyticsDataSyncQuery
Cron-Nxtwave-AdvancedAnalyticsDataSyncQuery	generate_task_table_for_specific_pipeline	Done
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_user_details_for_specific_account	Done
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_users_actual_working_dates_view_for_specific_account	NA
Cron-SuperK-AdvancedAnalyticsDataSyncQuery
Cron-Nxtwave-AdvancedAnalyticsDataSyncQuery	generate_pipeline_call_log_table	Done
Cron-Nxtwave-NIAT I&E -LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Academy-SSC-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-Affiliate-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Intensive-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_pipeline_call_log_table	Done
Cron-Nxtwave-NIAT I&E -LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Academy-SSC-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-NIAT-Affiliate-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-Intensive-LookerStudioAnalyticsDataSyncQuery
Cron-Nxtwave-LookerStudioAnalyticsDataSyncQuery	generate_lookerstudio_stage_history_table_for_pipeline
Cron-SuperK-AdvancedAnalyticsDataSyncQuery
Cron-Nxtwave-AdvancedAnalyticsDataSyncQuery	generate_stage_history_table_for_pipeline

ELP (generate_table_with_specific_fields)