Skip to main content
kcsp
Aug 14, 2019 5:31 PM UTC
Solved

Can you Add New Columns to an Existing S3 Dataset Task?

I have an existing S3 Dataset task that ingests a file that has our customer usage in it. There are new columns we are including in the file. I was trying to edit the S3 task to add in the new columns, and it doesn't look like Gainsight picks up the new columns in the Columns section, but I can see the columns if I click "Preview." Is there a way to add new columns to the data file? Or do I have to create a new S3 Dataset task?

kate_green
Helper ⭐️⭐️
Aug 14, 2019 6:13 PM UTC
Hi Kaycee - I believe you should be able to add them if you deselect the Show Selected checkbox in the Columns section after you preview the file. Did you try that?

3 replies

kate_green
Helper ⭐️⭐️
Aug 14, 2019 6:13 PM UTC
Hi Kaycee - I believe you should be able to add them if you deselect the Show Selected checkbox in the Columns section after you preview the file. Did you try that?

Translate
kcsp
kcspAuthor
Aug 14, 2019 6:28 PM UTC
I tried that, but nothing showed up. We have our S3 rule trigger based on the Event of an S3 Import occurring. In order to Preview the file, I have to stop the schedule so that the file isn't ingested. If I try to Preview with the schedule in place, the file is already picked up and I get the notificaiton that there is no data file in the S3 bucket.

Translate
kcsp
kcspAuthor
Aug 15, 2019 5:29 PM UTC
I was actually able to get this to work. Thanks.

Translate