Other: Lambda Connector - write to an existing schema
Not plannedAWS Lambda Connector - write to an existing Snowflake schema.
Currently, when you setup the Lambda Connector in the UI, you have to specify a single schema in Snowflake. Instead, we want to specify an existing schema.
The reason for this is we create multiple Lambda Connectors for one data source, and we want to replicate the data from these API calls into a single schema.
For example, if we have a source called Contentful with five Lambdas integrating five different objects, we want to land them into a single schema called CONTENTFUL, each object mapped to its own table.
-
Official comment
Hi Paul
Thank you for taking the time to share your feedback and provide such a clear explanation of why you'd like to be able to write to an existing schema.
We currently are err'ing on preventing accidental errors so have some strict rules that ensure one connector never accidentally overwrites data from another connector, which is why this limitation exists today. Can you share more about why combining the data in views etc doesn't work for you while avoiding the risk of one function accidentally overwriting another?
Best regards
Alison
Please sign in to leave a comment.
Comments
1 comment