Suggest Foreign Key Mappings Across Canvas Cards

Evaluates pairwise heuristic column relationships across loaded sideview_card objects or tabular data structures, computing a 3-part composite confidence score based on name similarity (40%), data type compatibility (20%), and Jaccard value overlap (40%).

Usage

sv_suggest_mappings(cards, ..., min_confidence = 0.6)

Arguments

cards

A list of sideview_card objects or tabular data frames. Alternatively, individual cards or tables can be passed via ....

...

Additional cards or tables passed as positional arguments.

min_confidence

Minimum confidence threshold (numeric between 0 and 1) for returned suggestions (default 0.6).

Value

A data.frame with columns:

from_table

Source table or card name.

from_col

Source column name.

to_table

Destination table or card name.

to_col

Destination column name.

confidence

Composite confidence score in [0, 1].

reason

Human-readable justification describing similarity components.

Examples

df1 <- data.frame(patient_id = 1:5, age = c(20, 30, 40, 50, 60))
df2 <- data.frame(patient_id = 3:7, score = c(10, 20, 30, 40, 50))
sv_suggest_mappings(list(patients = df1, visits = df2))
#>   from_table   from_col to_table     to_col confidence
#> 1   patients patient_id   visits patient_id     0.7714
#>                                                                reason
#> 1 Exact name match with ID suffix; identical types; 43% value overlap