S3 Connection - Not able to dynamically change bucket name according to configuration variable

I am trying to connect to a S3 bucket on my multi instance Retool setup. If I name the bucket manually, I can access it. But I have to use the same resource for three different environments (stg1, stg2 and prod).

While in other kind of resources I was able to point to the current environments (for example when connecting to an API) I am not able to do so on S3 connection, as it seems it doesn't parse the variable to its value.
CURRENT_ENVIRONMENT value vary from: stg1, stg2 and prod.

Here is a screenshot:
image

Hi @fmaltafleury-techinsights, I believe you could leave the bucket name blank, and then from within your app/workflow you can use curly braces in the query itself to specify the current environment. From an app it's retoolContext.environment and from a workflow its workflowContext.environment. Hope this helps!