Compression rate of a yxdb file

Question

I've got a large yxdb file and not as many temp storage to work with. I want to know what the compression of an Alteryx file is so I can split new files accordingly to never hit the temp storage.

Is there an easy answer to the compression rate of an yxdb file

for example

yxdb = 2gb than the flat file is approximately 6 gb so the compression rate then is 1/3

saveeshkumar · Answer

Hi @MartWClimber ,

Sample testing on csv file.

FileNameActual Size(GB)YXDB Size(GB)%CSV5.72.442.11CSV17.17.2242.22CSV34.314.441.98CSV45.719.242.01

Thanks

gabrielvilella · Answer

Well, the best way is to test it yourself.

MartWClimber · Answer

@saveeshkumar, yes, i found that too, but I want to know what the compression rate is. how dense/ what percentage of the original flat file will an yxdb file be. that is what i'm looking for. Is this 1/15th of the original flat file or 1/30, an other larger number?