Parsing issues: "bcp: unknown option u"

[mberneaud]

Good afternoon,

I have tried implementing BCP in a project in order to speed up the upload speed of an SQL table when re-creating it from scratch.

However, there seems to be an issue in the exection of the BCP command generated by bcp.to_sql().

Please consider the log output below:

[2022-09-23T10:50:36.018Z] Executing BCP command now... 
[2022-09-23T10:50:36.018Z] BCP command is: ['bcp', 'dbo.db', 'in', '/var/folders/2v/75hdky1j1xv5mw9hmtz1l2140000gq/T/8EZugLrdXVvi4mCZk4SxP', '-S', 'dbs.database.windows.net', '-d', 'comments', '-q', '-U', 'robot', '-P', '[REDACTED]', '-f', '/var/folders/2v/75hdky1j1xv5mw9hmtz1l2140000gq/T/kP38gPDN1tQnyYB6iIxuO']
[2022-09-23T10:50:36.082Z] bcp:  unknown option u
*followed by a listing of allowed options for bcp*

What could be the reason for this? I suspect that their is something amiss with how the engine details are handed to the bcp shell invocation, but I could also be completely amiss.

Best regards,
Malte

[epicmau5time]

What version of bcp is on your machine?

[mberneaud]

I'm running Version: 17.10.0001.1, the most current one available on homebrew via the MS tap.
I followed the installation instructions here.

[epicmau5time]

And if you just call bcp from the terminal, outside of bcp, what flags does it give you? Attach a screenshot