Automating Data Access from OneStream to Snowflake: Exporting Financial and Master Data

Can you confirm if you are trying to move data from OneStream to SnowFlake, or pull data into OneStream from Snowflake? Based on the initial post, both statements are asking for 2 different requirements.

We have included the below points which is need to be done in this process.

1. We would like to extract the Transformation details for Account, Entity and Product (UD dimension) dimensions from OneStream to Snowflake.
2. Daily once to start with and we might require an hourly refresh
3. Metadata and cube data for key reported developed in Snowflake (Not all dimensions required)
4. Csv is preferable. However, we would like to understand if this can be extracted directly from OneStream using any other ETL tools like Azure Data Factory, Five Tran etc.

Regards, Sibi S

Transformation rule, DIM, you can write a sql, added to BR and spool to csv. You need to config SIC to able to push to Snoflake.
Data, you can use DM but based on our exp its **bleep** slow. Try using FDX.