Hi,
We are looking out to read parquet file directly from on premise shared network path. The purpose is to read the data and move it to staging table and thereafter the etl process will remain as existing. To what I read online that we can read parquet files directly using openrowset(…bulk). There will be hundreds of files across 4 tables and for each tables separate folder shall be maintained.
We are not opting for poly base as the files will be required to be stored in object storage and we are bound by on premise setup. (Not even MinIO)
Hence experts kindly give your suggestion.