This function identifies the steps in a join path where new IDs are introduced, allowing you to determine at which join steps each ID variable is added to the query. It returns a data frame with information about newly discovered IDs and the corresponding join step in the path.
discover_id_introduction_steps(conn, full_path_dataframe)A data frame with information about newly discovered IDs and the corresponding join step.
The connection object or database connection string.
A data frame representing the full join path, including columns: "table_to_join", "method", and "common_var".