def buildQuery()

in app/services/BigQueryService.scala [19:38]

• 18 lines of code
• 4 McCabe index (conditional complexity)

  def buildQuery(testName: String, channel: String, stage: String): String = {

    val channelInQuery = channel match {
      case "Epic" => "ACQUISITIONS_EPIC"
      case "Banner1" => "ACQUISITIONS_ENGAGEMENT_BANNER"
      case "Banner2" => "ACQUISITIONS_SUBSCRIPTIONS_BANNER"
    }

    s"""SELECT
      ab.name AS test_name,
      ab.variant AS variant_name,
      component_type,
      SUM(acquisition_ltv_3_year) AS ltv3,
    FROM `datatech-platform-prod.reader_revenue.fact_holding_acquisition`
    CROSS JOIN UNNEST(ab_tests) AS ab
    WHERE  ab.name= '$testName'
    AND component_type ='$channelInQuery'
    GROUP BY 1,2,3
    """
  }