apache / apache/hop

[Feature Request]: Snowflake Bulkloader - GZIP the stream to the stage before load.

Open
#4,467 0 comments 0 reactions 0 assignees View on GitHub
awaiting triage P3 Transforms
Dominant language
Java
Stars
1.5k
Forks
476
Avg merge
18h 32m
Merged PRs (30d)
216

Description

### What would you like to happen?

Currently the snowflake bulkloader converts a stream into a padded CSV file that it uploads to the "stage" in Snowflake before a COPY statement referencing the file in the stage. Please gzip the stream on the way to the stage. That will cutdown on the amount of bandwidth and storage required to bulkload.

### Issue Priority

Priority: 3

### Issue Component

Component: Transforms

Contributor guide

Open the contributing guide

Research direction

Start at the Snowflake bulkloader entry point and trace how the stream becomes a padded CSV file uploaded to the Snowflake stage. Check how the staged file is referenced by the COPY statement. Done means the stream is gzipped before upload and the subsequent Snowflake bulk load still completes successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.