Territory Assignment
The territory assignment transfer is a most basic example of uploading a csv file and then loading that data into the account manager territory assignment table.
Use Case: When John from sales gets promoted or leaves, and suddenly Sarah is covering a patch from Alaska to Arizona because someone thought it made sense on a map. The new territory mapping needs to be updated and replace the entire contents of the database table.
Navigate to the Admin -> Transfers page, and select "example - Territory Assignment" from the drop down menu to view the entire configuration for the upload.
The following features are configured for this transfer:
CSV file for source
Limit the file selection to .csv files
Truncate the snowflake table before loading data
Allow downloads of the uploaded files
Upload history shows files uploaded from all users
Use the Snowflake copy into command to load the table
source data layout
ManagerID,ManagerName,Territory,StartDate,EndDate
1,John Doe,Alaska,2022-01-01,2022-06-30
2,Sarah Smith,Arizona,2022-07-01,NULL
3,Michael Brown,California,2021-03-15,2022-03-14
4,Emily Davis,Nevada,2022-04-01,NULL
table columns:
ManagerID INT PRIMARY KEY,
ManagerName VARCHAR(100),
Territory VARCHAR(100),
StartDate DATE,
EndDate DATE,
LastUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
The attached file can be used to test the upload.
Last updated