Okay I've just run this on my end:

credentials.yml

yaml
dev_sql:
    con: sqlite:///?odbc_connect=DRIVER={ODBC+Driver+17+for+SQL+Server};SERVER=someserver;DATABASE=somedatabase;UID=someuser;PWD=somepwd

catalog.yml

yaml
test:
  type: pandas.SQLTableDataSet
  table_name: 'test'
  credentials: dev_sql