Invoking REST service from Singlestore

Help Procedural SQL
1

Hi,

I am using AES_Encrypt(,<Encryption_Key>) & AES_Decrypt(,<Encryption_Key>) within Singlestore storedproc and in the SQL query.
We are required to encrypt the key using some other service and call the service during StoredProc execution time and query execution time to decrypt the key and use the key for AES_Encrypt and AES_Descrypt function. Is this possible with Singlestore? Do you have a documentation on invoking a remote REST service?

2

For sure! We have a feature called external functions. See the docs here.

If you are on our managed service you will need to ask support to enable this feature on your cluster first.

1 Like