Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

SQL table editor : parametrize the source of data ?

Hello, In the SQL table editor component, we can define namely the Schema Name, Table Name, Table Column Names, Where Clause and Order By Clause : However, I am using a Table that has encr...
Security
db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

This is untested: can you create a SQL View in the background (via a BR), then reference that View in the standard table editor component?  You would likely need to create a custom save function as well since you're now looking at data from a View rather than the raw table.

  • Sergey's avatar
    Sergey
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    That's something I will definitely test !

    I don't know if one can actually change the table name used for saving data, but that would accomodate with the code needed in order to encrypt / decrypt.

    I'll keep you posted on that one !