Working with our developers to ingest data from Salesforce Opportunities into the Salesforce Spoke table (sn_sforce_v2_spoke_st_opportunities), but we were not permitted to use the Spoken Connection from SNOW to SFDC. Instead we get an XML package that we need to transform and write to a source table.
Is there a way to use a transform map and write the data to the Salesforce Opportunity spoke table?
So far, unsuccessful at granting a user write-access to sn_sforce_v2_spoke_st_opportunities, let alone creating a transform map. Where do we start troubleshooting, or is this just not feasible?
