This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I urgently need some help on creating a macro. I want to extract data from AWS S3. The data is too large to stream out at once due to Athena's buffer stream limitation. Therefore, I tried to create a macro that change the duration and loop through the period we are interested in.
I tried to change the date range in the query with a formula, however, the input In-DB tool is not taking the query as I've changed the date to string. I tried to use the todate formula to change the data type of the date, however, result returns null. Does anyone has any idea how can I change the date range in the query in a macro? Thank you so much in advance!
Can you post the configuration of your two Action Tools?
Also, try debugging the SQL strings that comes out of the formula to ensure that they're properly formatted. To make it work, temporarily disable the In-DB tools by adding them to a container and disable the container. Add a new Macro Output that returns the SQL strings to the main WF and inspect them there.