test_that("Data Tables Checks with Optimize", {
  skip(message = "not used")
  dataTablesResults <- CdmOnboarding::dataTablesChecks(
    connectionDetails = params$connectionDetails,
    cdmDatabaseSchema = params$cdmDatabaseSchema,
    resultsDatabaseSchema = params$resultsDatabaseSchema,
    cdmVersion = params$cdmVersion,
    outputFolder = params$outputFolder,
    optimize = TRUE
  )

  testthat::expect_type(dataTablesResults, 'list')

  testthat::expect_named(
    dataTablesResults,
    c(
      "dataTablesCounts", "totalRecords", "recordsPerPerson", "conceptsPerPerson",
      "observationPeriodLength", "activePersons", "observedByMonth",
      "dateRangeByTypeConcept", "dayOfTheWeek", "dayOfTheMonth",
      "observationPeriodsPerPerson", "observationPeriodOverlap",
      "dayMonthYearOfBirth", "visitLength"
    ),
    ignore.order = TRUE
  )

  # Check each element has a non-null result
  for (name in names(dataTablesResults)) {
    testthat::expect_true(
      !is.null(dataTablesResults[[name]]$result),
      info = paste("The result in", name, "is null")
    )
  }
})