Skip to content

Data Pump for free account data --> Salesforce

Here is a SQL query that can be used to pull data about our free accounts.

We need to push this data into Salesforce on a weekly update cadence.

I can build an Openprise job to write the data to Salesforce, if we can automatically run the SQL query and produce a .csv that we put into the Openprise S3 bucket. Openprise team recommends putting this into a new directory since it is separate and different from the propensity model file we are loading.

Requirements doc: https://docs.google.com/document/d/1W0IxlGQavYDi_4GNiV1ETxJ3wh1HiSJJ5CxdGFhV3bA/edit?tab=t.0