Hey GoodData Support, Is there a way within GoodD...
# gooddata-cn
s
Hey GoodData Support, Is there a way within GoodData LDM to create a SQL dataset using a stored procedure instead of just a view? More context: We are doing row level encryption for a table for few columns and we are using symmetric key within SQL Server for doing that encryption. Now when we want to read that data through gooddata, there is no option to Open the syymetric key and decrypt that data.. While a stored procedure supports doing that, a view doesn't support that. We are looking for ways to decrypt that info through a stored procedure.. Is there a way to do it? I read through the docs here (https://www.gooddata.com/docs/cloud/model-data/create-logical-data-model/create-sql-datasets/) and didn't find a definitive answer this is the error which I get when I try to execute SQL query by opening symmetric key.. If at all there is support for using stored procedure instead, that would have worked for us
Raised a support request for the same too - https://support.gooddata.com/hc/en-us/requests/125853