Forum Discussion

tharunkumar04's avatar
tharunkumar04
New Contributor
3 months ago

Export data to Snowflake

Hello,

We are looking to export data from OneStream to Snowflake using APIs. We are using OneStream's cloud hosted environment, and the authentication method is just a Reference Token.

We are looking for more secured way for sending the data from OneStream to Snowflake. Let us know if there are any suggestions or alternatives for this data integration with more secured way of authentication.

Thanks,

Tharun.

  • What are your security concerns with PAT and what do you see as a more secure method? And obviously the authentication method has nothing to do with the security protocol for transmitting the data between the 2 systems

  • tschilling's avatar
    tschilling
    New Contributor III

    To some degree, you're stuck with what OS can offer, although it's worth opening a case to see if there are other options.  

    Could you flip the script, and call the Snowflake API from within an OS Business Rule and "push" the data to Snowflake?

  • When you say reference token, do you mean Personal Access Token (PAT). Are you exporting data using the OneStream data provider Web API?

    • tharunkumar04's avatar
      tharunkumar04
      New Contributor

      Yes, we are using OneStream data provider Web API using PAT authentication.