Kedro is an open-sourced Python framework for creating maintainable and modular data science code.

Kedro

I am looking at the Ibis TableDataset. The example in the docs points to a db file, but in my case I would want to connect to a remote TSQL database. Do I provide a connection string the same way I would with a Pandas SQL Table dataset?

<https://docs.kedro.org/projects/kedro-datasets/en/kedro-datasets-8.1.0/api/kedro_datasets/ibis.TableDataset/#kedro_datasets.ibis.TableDataset>

Since Ibis datasets connect using the underlying Ibis backend object, you should look at how that backend is configured: <https://ibis-project.org/backends/mssql>

So, for the documented Windows example above, it could look something like:

```cars:
  type: ibis.TableDataset
  filepath: data/01_raw/company/cars.csv
  file_format: csv
  table_name: cars
  connection:
    backend: mssql
    database: ibis-testing
    host: localhost
    user: sa
    password: 1bis_Testing!
    driver: FreeTDS
  save_args:
    materialized: table```

(you could use a resolver to get credentials from env vars if you wanted to replicate that)

<@U03S12LHNNQ> Ah! That makes sense! Thank you &lt;3