d6tstack icon indicating copy to clipboard operation
d6tstack copied to clipboard

pd_to_mssql doesn't use schema arguement

Open bparzonz opened this issue 2 years ago • 0 comments

example code

`uri_mssql = f'mssql+pymssql://{u}:{p}@$server/$db'

d6tstack.utils.pd_to_mssql(df = df, uri = uri_mssql, table_name = 'mytable', schema_name = 'myschema', if_exists='replace')`

The error reads that I dont have access to the schema 'dbo' when making the connection, which I assume is the default schema that the connection trys to make when schema_name is set to None.

bparzonz avatar Sep 24 '22 00:09 bparzonz