[Bug]: Snowflake Bulkloader does not respect lowercase for schema and table names
- 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
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