davlee1972 opened a new issue, #2630: URL: https://github.com/apache/arrow-adbc/issues/2630
### What feature or improvement would you like to see? Can we add INGEST_COLUMNS and INGEST_SELECT_COLUMNS as snowflake options? This would modify the Snowflake copy into command to allow for a subset of columns and custom select transformations.. The current use-case I have is that our target Snowflake tables have DEFAULTs applied to some columns which would only kick in if the columns are not included in the the COPY INTO column list. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table Columns cannot be repeated in this listing. Any columns excluded from this column list are populated by their default value (NULL, if not specified). However, excluded columns cannot have a sequence as their default value. ``` /* Data load with transformation */ COPY INTO [<namespace>.]<table_name> [ ( <col_name> [ , <col_name> ... ] ) ] FROM ( SELECT [<alias>.]$<file_col_num>[.<element>] [ , [<alias>.]$<file_col_num>[.<element>] ... ] FROM { internalStage | externalStage } ) ``` Right now we just have a constant for copyQuery.. ``` copyQuery = "COPY INTO IDENTIFIER(?) FROM @" + bindStageName + " MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE" ``` https://github.com/apache/arrow-adbc/blob/main/go/adbc/driver/snowflake/bulk_ingestion.go -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
