SELECT cause, effect, library_size,
round(cast("correlation" AS numeric), 5) AS "correlation",
jaccard_index, round(cast("lower_bound" as numeric), 5) AS "lower_bound",
round(cast("upper_bound" as numeric), 5) AS "upper_bound",
round(cast("effect_size" as numeric), 5) AS "effect_size",
round(cast("effect_size_sd" as numeric), 5) AS "effect_size_sd"
FROM CCM (
ON (select 1) PARTITION BY 1
InputTable ('ccm_input')
SequenceIdColumn ('id')
TimeColumn ('period')
CauseColumns ('income')
EffectColumns ('expenditure', 'investment')
EmbeddingDimension ('5')
Seed ('0')
) ORDER BY cause, effect, library_size;