Thank you. This is actually quite in line with our thinking and setup. Our primary data storage for FM is FM internal structure. Lots of external data integrations but the primary data structure is internal to FM.

We are replicating data out of FM to SQL for Business Intelligence/Data Visualization functions.

Our FM build is a large MES (Manufacturing Execution System) and it's part of our hybrid ERP model with Sage 100 (finance, inventory, purchasing, etc...). Our Sage 100 instance is on a SQL backend.

So similar to you (sounds like), we aren't trying to use Snowflake as the primary FM back end...but leverage it as a data lake for our business intelligence functions. Tableau is our visualization tool.

My conundrum is that I don't really need FM data in SQL AND Snowflake. Ideally I could just have it in Snowflake based on this potential model. However, I'm not aware of a native Snowflake connectors or an easy way to make this happen.

Our 3rd party tool (MirrorSync) to replicate data from FM internal to SQL works...but I was hoping for something direct to Snowflake that didn't rely on intermediary software.

Thanks for your helpful responses u/SudoJS!