Export Salesforce to S3 with Lambda and Step Functions: A Complete Open-Source Solution
· 7 min read
Export Salesforce to S3 in 10 Minutes
Export Salesforce to S3 and query it in Athena — no ETL tools, no long‑running servers.
This open‑source, serverless pipeline uses AWS Lambda, Step Functions, and the Salesforce Bulk API 2.0 to export every Salesforce object to S3. After each run, it automatically updates the AWS Glue Data Catalog, so your data is immediately queryable in Athena.
After a single deployment, you can query your Salesforce data directly in Athena:
SELECT * FROM salesforce_export.account_raw LIMIT 10;