Is it possible to set/change the compression type that is used for a Database Query component? If so, how is this toggled? If not, what compression type is used by default and is there an alternative approach to using the DB Query component to allow one to control the compression type?
In case it is pertinent the source connection is Oracle DB.
3 Community Answers
Paul Johnson —
The compression type for staging files is gzip and it cannot be altered. Is there a particular reason you need this?
Thanks for the quick response. I am just trying to get an idea of the level of compression being used here...so that I can come up with a decent average percentage of compression for each file that gets dropped into S3. If you can provide any kind of level and compression ratio values that would help out a lot.