Tolerance
The tolerance for the nearest asof join. This is only used when the nearest strategy is used. The tolerance is a positive integer that specifies the maximum number of rows to search for a match. If the join is done on a column of type Date, Time or DateTime, then the tolerance is interpreted using the following language: 1d - 1 day 1h - 1 hour 1m - 1 minute 1s - 1 second 1ms - 1 millisecond 1us - 1 microsecond 1ns - 1 nanosecond 1w - 1 week 1mo - 1 month 1q - 1 quarter 1y - 1 year 1i - 1 index count Or combine them: “3d12h4m25s” # 3 days, 12 hours, 4 minutes, and 25 seconds Suffix with “_saturating” to indicate that dates too large for their month should saturate at the largest date (e.g. 2022-02-29 -> 2022-02-28) instead of erroring.