Skip to content
This repository has been archived by the owner on Aug 25, 2023. It is now read-only.

Column subset options for insert and update in upsert_to_table_by_name #178

Open
AndreasLindhardt opened this issue Oct 14, 2022 · 0 comments
Open

Column subset options for insert and update in upsert_to_table_by_name #178

AndreasLindhardt opened this issue Oct 14, 2022 · 0 comments
Labels
enhancement New feature or request

Comments

@AndreasLindhardt
Copy link

Currently, we are updating/inserting all source columns in the merge statement. I am suggesting that we add two parameters to the function, e.g. "insert_cols"/"update_cols" that takes a given subset of the source columns and uses those instead of all source columns.

atc-dataplatform/src/atc/sql/SqlServer.py

Line 230 in 5b6c9a5

mergeQuery = GetMergeStatement(

@LauJohansson LauJohansson added the enhancement New feature or request label Oct 14, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@LauJohansson @AndreasLindhardt