@exa-Lennart @exa-Chris - We are using the Python UDF approach to handle the read from the API's. We create views on top of the UDF that let us view data in the tabular format. After reviewing this, looks like we still have to create UDF to handle th...

Below is a working example:-- UDF Definition CREATE OR REPLACE PYTHON3 SCALAR SCRIPT EMIT_EXAMPLE(NAME VARCHAR(10), REPEAT_COUNT INT) EMITS(OUTPUT_MESSAGE VARCHAR(20)) AS def repeater(x): for i in range(x.REPEAT_COUNT): x.emit("Hello {}!".format(x.NA...

You can pass ctx from run function to other functions as well. def default_output_columns(x): # everything you can do using ctx, can be done here with x file_path = x.FILEPATH x.emit(...) def run(ctx): default_output_columns(ctx)

This is great! Worth testing it out with our enterprise API's.

We had similar question that we asked the support team. Based on the recommendations, we are going to perform the following steps to reduce the EBS volumes. We haven't tried this yet but that's the plan we are going to follow.1. Take backup of existi...