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