prole/knoe-db/bulk_insert.sql

BULK INSERT knoe.dbo.wells
FROM '/var/opt/mssql/data/2023CaliforniaOilAndGasWells.csv'
WITH ( 
    FIRSTROW = 2, 
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n'
);

-- select OperatorStatus, WellStatus, max(SystemEntryDate), count(*) from dbo.wells group by OperatorStatus, WellStatus order by 1, 2, 3;