ads_data: true
data_completeness: true
spotify_charts: true
apple_charts: true
amazon_charts: true

# secret keys
pg_api_db_secter_key: delphi/dev/api/pg/data-health-user

# dev queries
ads_data_select: >
  call data_health.recalculate_internal_ads_data_status(
  {start_date}, {end_date}, {volatile_days}, {target_dsp}
  );

ads_data_insert: >
  call data_health.refresh_ads_data_health_to_internal_table(
  {start_date}, {end_date}, {target_dsp}
  );

data_completeness_select_and_insert: >
  call data_health.recalculate_dsp_streams_status_daily(
  {start_date}, {end_date}, {target_dsp}
  );

spotify_charts_select_and_insert: >
  call data_health.calculate_spotify_chart_health_status(
  {start_date}, {end_date}, {volatile_days}
  );

apple_charts_select_and_insert: >
  call data_health.calculate_apple_chart_health_status(
  {start_date}, {end_date}, {volatile_days}
  );

amazon_charts_select_and_insert: >
  call data_health.calculate_amazon_chart_health_status(
  {start_date}, {end_date}, {volatile_days}
  );

# query_params
ads_data_select_params: [start_date, end_date, volatile_days, target_dsp]
ads_data_insert_params: [start_date, end_date, target_dsp]
data_completeness_select_and_insert_params: [start_date, end_date, target_dsp]
charts_select_and_insert_params: [start_date, end_date, volatile_days]