Error(s) in re-building vignettes:
  ...
--- re-building ‘a00_introduction.Rmd’ using rmarkdown
--- finished re-building ‘a00_introduction.Rmd’

--- re-building ‘a01_building_base_cohorts.Rmd’ using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB


Quitting from lines 49-56 [unnamed-chunk-3] (a01_building_base_cohorts.Rmd)
Error: processing vignette 'a01_building_base_cohorts.Rmd' failed with diagnostics:
rapi_prepare: Failed to prepare query CREATE TABLE main.my_study_tmp_001_og_002_1718195530 AS SELECT
  LHS.*,
  requirements,
  age_range,
  sex_req,
  min_prior_observation,
  min_future_observation,
  cohort_definition_id,
  cohort_name,
  min_age,
  max_age
FROM (
  SELECT
    cohort_definition_id AS target_cohort_rand01,
    subject_id,
    cohort_start_date,
    cohort_end_date,
    date_of_birth,
    CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
    CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
  FROM main.my_study_date_0
) LHS
LEFT JOIN (
  SELECT
    requirements,
    CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
    age_range,
    sex AS sex_req,
    min_prior_observation,
    min_future_observation,
    cohort_definition_id,
    cohort_name,
    min_age,
    max_age
  FROM main.my_study_tmp_001_og_001_1718195530
) RHS
  ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)
Error: Binder Error: Referenced column "date_0" not found in FROM clause!
Candidate bindings: "my_study_date_0.date_of_birth"
LINE 19:     CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
    CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
  FROM main.my_study_date_0
) LHS
LEFT JOIN (
  SELECT
    requirements,
    CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
    age_range,
    sex AS sex_req,
    min_prior_observation,
    min_future_observation,
    cohort_definition_id,
    cohort_name,
    min_age,
    max_age
  FROM main.my_study_tmp_001_og_001_1718195530
) RHS
  ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)...
                   ^
--- failed re-building ‘a01_building_base_cohorts.Rmd’

Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building ‘a02_applying_cohort_restrictions.Rmd’ using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB

--- finished re-building ‘a02_applying_cohort_restrictions.Rmd’

Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building ‘a03_age_sex_matching.Rmd’ using rmarkdown
--- finished re-building ‘a03_age_sex_matching.Rmd’

--- re-building ‘a04_cohort_manipulations.Rmd’ using rmarkdown
--- finished re-building ‘a04_cohort_manipulations.Rmd’

SUMMARY: processing the following file failed:
  ‘a01_building_base_cohorts.Rmd’

Error: Vignette re-building failed.
Execution halted