search

BuzzCutNorman / tap-mssql

Singer Tap for MS SQL built with Meltano Singer SDK.
MIT License
2 stars 9 forks source link

feature: `connect_args` for pymssql #20

Open BuzzCutNorman opened 1 year ago

BuzzCutNorman commented 1 year ago

Resolve #15 So users of pymssql can connect to Azure Data Warehouse

BuzzCutNorman commented 1 year ago

@cwegener when you have some time, please give this PR a try against Azure SQL DW (Synapse Dedicated SQL Pool). I added a new config option azure_synapse_dw that is a boolean. When set it is set to True and the driver_type is pymssql the connection properties you gave earlier are added to connect_args. You will need to install the tap as a custom extractor. Below are some cut and paste lines to assist with the install.

meltano add --custom extractor tap-mssql

git+https://github.com/BuzzCutNorman/tap-mssql.git@15-add-connection-args

catalog,state,discover,about,stream-maps,schema-flattening

dialect,driver_type,host,port:integer,user,password:password,database,driver,azure_synapse_dw,sqlalchemy_eng_params:object,fast_executemany,future,sqlalchemy_url_query:object,driver,TrustServerCertificate,batch_config:object,encoding:object,format,compression,storage:object,root,prefix,start_date