Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

How to consistently access eplusout.sql

asked 2023-12-12 12:04:02 -0500

jlorrey's avatar

updated 2023-12-19 10:40:22 -0500

I'm using an analysis finalization script to try to save my OS server job's eplusout.sql files to cloud storage. For each datapoint, the script gets the, extracts the files of interest (eplusout.sql & a few others) and saves them to my cloud storage location.

The problem I'm running into is that the eplusout.sql files don't get consistently saved to the datapoint zip files. Based on, it seems there is a size limit above which they will not get included in the

Is there a way to disable this size limit, or access the eplusout.sql file outside of the


edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2023-12-13 02:27:08 -0500

antonszilasi's avatar

updated 2023-12-19 02:39:04 -0500


I'm just wondering why are you trying to save these sql files from the, I assume that you are doing this from the OpenStudio server console?

You can access the sql files directly in the data point run directory by using a datapoint finalization script. You can set this up with PAT and then SSH into the docker container running the datapoints to test the finalization script.

You could write some code which puts these .sql into a AWS s3 bucket. This worked well for me but I was doing it for smaller files.

The eplusout.sql can be very large, so it maybe cleaner to write a measure that queries the .sql files for the info that you need and then puts this into S3 somewhere.

EDIT: I've attached an example pushtos3.rb script in google drive here where I put something in a S3 bucket through the script

edit flag offensive delete link more


Hi & thanks for your response!

I did originally try using a datapoint finalization script to save the datapoint results, but didn't have much luck. Would you be willing to share a code snippet of how you directly accessed the result files in your datapoint finalization script?

Agreed that writing a measure to query the sql for the specific info we need would often be a better approach, and I will look into that as well.


jlorrey's avatar jlorrey  ( 2023-12-15 10:52:56 -0500 )edit

I just attached an example script

antonszilasi's avatar antonszilasi  ( 2023-12-19 02:37:30 -0500 )edit

Thanks for including the example!

jlorrey's avatar jlorrey  ( 2023-12-19 06:31:08 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops


Question Tools

1 follower


Asked: 2023-12-12 12:04:02 -0500

Seen: 61 times

Last updated: Dec 19 '23