I am looking at the Ibis TableDataset. The example...
# questions
g
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
d
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:
Copy code
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
👍🏼 1
(you could use a resolver to get credentials from env vars if you wanted to replicate that)
g
@Deepyaman Datta Ah! That makes sense! Thank you <3