CREATE EXTERNAL DATA SOURCE ERROR on Local Host

Question

https://stackoverflow.com/questions/61100707/polybase-to-connect-local-csv-file

The above link shows how to create an external datasource / table from a local csv file.

Right now my current set up is rendering an error message consistent with the link below.

https://social.msdn.microsoft.com/Forums/en-US/93140719-ccb2-4b16-8a5c-09220c719fa4/sqlserver-2019-create-external-file-format-error?forum=sqldatabaseengine

Except, I would think a local odbc connection wouldn't need any specific authentication credentials (although I have created and stored credentials as suggested in the first link).

What am I missing?

Answer 1

Hi @Brent Carpenetti ,
I think the causing reason is that this can only be used by SQL authentication. And you can see from this link:https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver16&tabs=dedicated

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 2

The issue appears to be that the command was run from ADS with the user account instead of in SSMS with system admin.

I'm not sure why that would make a difference as my user has system admin.