Visitar URL original
Snowflake CSV - use parallel scan settings for uncompressed CSV · Issue #408 · ClickHouse/ClickBench · GitHub
Skip to content

Snowflake CSV - use parallel scan settings for uncompressed CSV #408

Description

@sfc-gh-xhuang

I noticed that for duckdb the CSV file is first uncompressed before loading. https://github.com/ClickHouse/ClickBench/blob/main/duckdb/benchmark.sh#L18C1-L18C5

For Snowflake, we also support faster parallel scanning of uncompressed CSVs.

Can we modify the Snowflake data loading test such that it loads a uncompressed CSV with MULTI_LINE=FALSE and COMPRESSION=NONE?

https://medium.com/snowflake/recap-of-snowflake-ingestion-cost-and-performance-improvements-large-csv-demo-911e6588d626?source=friends_link&sk=38a754b71aa06f51f269c6974b24abd8

Activity

  1. rschu1ze commented on Jun 17, 2025

    @rschu1ze
    Member

    Yes, please send a PR, ClickBench is a community project.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions