I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is the query:
BULK INSERT [kf].myTable from '/Users/username/path/to/file.csv' with( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n' )
The error I am getting is:
Msg 103010, Level 16, State 1, Line 1
Parse error at line: 1, column: 1: Incorrect syntax near 'BULK'
I've looked at other suggestions and none of them have worked. Is it possible that BULK is just not supported by Azure Data Studio?