DuckDB will automatically use gzip/zstd to decompress files with a standard extension like .csv.gz, so we can easily add support for opening these in the data explorer. Based on the size of the file, we may choose to use CREATE TABLE vs. CREATE VIEW to avoid every subsequent query having to decompress the file, which will degrade latency and increase CPU utilization when using the data explorer.
DuckDB will automatically use gzip/zstd to decompress files with a standard extension like .csv.gz, so we can easily add support for opening these in the data explorer. Based on the size of the file, we may choose to use
CREATE TABLEvs.CREATE VIEWto avoid every subsequent query having to decompress the file, which will degrade latency and increase CPU utilization when using the data explorer.