Learn about custom compression for managed tables
lz4
– Default option; fast compression and decompression, ideal for general workloads.zstd
– Higher compression ratios at the cost of increased CPU usage; useful for large datasets.NONE
is not supported. Firebolt always compresses data using one of the supported algorithms.WITH
clause in the CREATE TABLE
statement. This compression applies to all columns unless explicitly overriden at the column level.
COMPRESSION_LEVEL
parameter lets you fine-tune the balance between compression efficiency and CPU usage.lz4
.compression_level
parameter fine-tunes compression efficiency versus CPU usage.lz4
compression algorithm.GENERATE_SERIES
origin_no_compression
table:
compressed_byte
value of the tables to evaluate the effectiveness of compression settings:
compressed_bytes | table_name |
---|---|
4772 | origin_no_compression |
4396 | table_a_b_column_level_zstd |
4584 | table_a_column_level_zstd |
2558 | table_c_column_level_zstd |
763 | table_c_d_column_level_zstd |