Forum Discussion
Helper IFabric COPY UserErrorInvalidCopyBehaviorBlobNameNotAllowedWithPreserveOrFlattenHierarchy gzip
Okay, I solved my own problem and thought I'd close the loop on this to save people some time if they hit the same thing. When I copied GZ from S3 to Lakehouse, it failed. I was using binary and fastest compression type. By changing the compression on both the source and the destination it worked. Go figure! Why does a binary copy care about the contents? "cp" for example doesn't. Anyways, thought that may assist. Also for decompressing a gz file with a csv, choose delimited text and then gz from there. Don't waste your time thinking you should start from the gz and crack that open. It is all very counter intutive, but hopefully that saves people a few days, some head scratching and some hair.
Helper IOkay, I solved my own problem and thought I'd close the loop on this to save people some time if they hit the same thing. When I copied GZ from S3 to Lakehouse, it failed. I was using binary and fastest compression type. By changing the compression on both the source and the destination it worked. Go figure! Why does a binary copy care about the contents? "cp" for example doesn't. Anyways, thought that may assist. Also for decompressing a gz file with a csv, choose delimited text and then gz from there. Don't waste your time thinking you should start from the gz and crack that open. It is all very counter intutive, but hopefully that saves people a few days, some head scratching and some hair.
v-saisrao-msftCommunity Support
Hi FabricNZ
Thank you for your valuable feedback.