Docdb is in private subnet, is there any way to make a direct connection from docdb to snowflake without of intermediate storage like s3 and no data transformation too, like i want it in a automated process , what im thinking is like using lambda to connect to docdb and use mongoexport and export them directly to snowflake db , and if im automating it then shouldn’t table and schema be created before , if there are multiple collections in db and is it best to create a table for each collection , if its going to be automated is there any way that snowflake creates schema and table based on collection itself or in the lambda script the flow should be like get collection then based on collection field then create table and then export that collection to table , is this how flow should be like , any other possible ways

Thanks all in advance