apache / apache/hop

[Bug]: Snowflake Bulkloader does not respect lowercase for schema and table names

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

Description

### Apache Hop version?

2.8-GA

### Java version?

11

### Operating system

Windows

### What happened?

Snowflake by default folds all names, schema, and columns to UPPERCASE. If you specify anything in lowercase in the dialog, when the SQL generates on the backend, the SCHEMA, TABLENAME and COLUMNS need to be within double quotes " for Snowflake to respect the case passed in. Currently that quoting is not happening and everything is assumed to be upper case.

### Issue Priority

Priority: 3

### Issue Component

Component: Transforms

Contributor guide

Open the contributing guide

Research direction

Start with the Snowflake Bulkloader transform, its dialog, and the backend SQL-generation path. Trace how schema, table, and column names are emitted, then verify that lowercase names are quoted so Snowflake preserves their case.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.