Skip to main content
T
tharunkumar04
Newcomer
January 24, 2025

Export data to Snowflake

  • January 24, 2025
  • 3 replies
  • 0 views

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.

    3 replies

    S
    SimonHesford
    Newcomer
    January 24, 2025

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

    T
    tharunkumar04Author
    Newcomer
    January 24, 2025

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

    T
    tschilling
    Newcomer
    January 24, 2025

    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?

    S
    SimonHesford
    Newcomer
    January 24, 2025

    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

    Terms & ConditionsAccessibility statement