Robin Linacre

Possible workaround: ``` import duckdb from splink import DuckDBAPI, Linker, SettingsCreator, splink_datasets con = duckdb.connect() db_api = DuckDBAPI(connection=con) df = splink_datasets.fake_1000 settings = SettingsCreator( link_type="dedupe_only", ) con.register("mytable", df) linker =...

https://github.com/moj-analytical-services/splink/blob/4498949434a8b1d0137f4ca32d2f2bc96edf7852/splink/internals/column_expression.py#L50 I think Andy is suggesting that you use a `@property` for `sql_dialect`. This property would raise a more descriptive error when `sql_dialect` is `None`, rather than failing silently or...

@aamir-rj I'm afraid we don't have access to databricks so can't really help out with these sorts of errors. There are various discussions of similar issues that may (but may...

Thanks. Yes. As far as I know, it doesn't get around this jar problem (but I would love to be corrected on that!)

``` import splink.comparison_library as cl import pandas as pd from splink import DuckDBAPI, Linker, SettingsCreator, block_on, splink_datasets db_api = DuckDBAPI() df = splink_datasets.fake_1000 df = pd.concat([df]*5) df.reset_index(drop=True, inplace=True) df["unique_id"] =...

I think the structure of this is a bit wrong - passing the experimental_optimisation flag isn't quite right, I think this should 'belong' to the comparison And we want to...

Rembee to add some tests based on the context.md file

The following fails on sqlglot 25.x but works on 26.6.0 The error is something to do with XOR at q^0.33 i.e. it's not correctly translating/transpiling the `^` ``` ( list_reduce(...

Quickprompt is Details ``` Consider the following example: select CASE WHEN jaro_winkler_similarity("first_name_l", "first_name_r") >= 0.9 THEN 4 WHEN jaro_winkler_similarity("first_name_l", "first_name_r") >= 0.8 THEN 3 WHEN jaro_winkler_similarity("first_name_l", "first_name_r") >= 0.7 THEN...

I got gemini to analyse the whole sqlglot codebase and it thinks these are the relevant files for the purpose of solving this task ``` mkdir -p sqlglot_refactoring_task && rsync...