My stack is based on sst, single table dynamodb and I have a different AWS Account for developer and environment (dev and prod):
I already have use rockset in prod environment but now I want extend it to all environments.
I would use Query Lambda but I can’t, as shown in the attachment I have a Query Lambda binded to this query which refers to integration of my collegue (mcattaneo).
It could be fine to define parameters on FROM clause in this way I could switch integration based on parameters.
What I can’t do is duplicate query lambda on all stages for obvious maintainability reason.
Actually I’m planing to use only Query specifying Collection and Integration in my application code with rockset sdk.
Do you have some suggestion or found some issue on adopting only Query on Collection?