Granted Patent B2

US 12,190,181 · App. 18/429,367 · Granted Jan 7, 2025

Inventors: Isaac Kunen (Seattle, WA); Srinath Shankar (Belmont, CA); Zihan Li (Mountain View, CA); Khushboo Bhatia (Belmont, CA); Edward Ma (San Jose, CA)

Assignee: Snowflake Inc.

G06F9/547G06F16/2455G06F16/289G06F21/53

Abstract

Claims (55)

1. A method comprising:

receiving, via an execution node, a response to a database query;

converting, via an Application Programming Interface (API) executing within a sandbox process, the response into a remote procedure call;

modifying, by at least one hardware processor, the sandbox process to restrict communication with an external network and to enable communication with the execution node, the execution node facilitating communication between a stored procedure and a component of a database system;

providing, to the stored procedure executing within the sandbox process, the remote procedure call as the response to the database query, the stored procedure executing within the sandbox process causing the API to communicate with the execution node; and

submitting, by the execution node, the database query to the component of the database system.

2. The method of claim 1 , wherein the stored procedure is configured to perform file operations including reading from stages and uploading to the stages within the database system, wherein the stored procedure is a subroutine stored within the database system to invoke specified functionality.

3. The method of claim 1 , further comprising:

loading the sandbox process with a JAVA database connectivity instance, the JAVA database connectivity instance being modified to limit communication abilities of the stored procedure.

4. The method of claim 3 , further comprising:

modifying the JAVA database connectivity instance to limit communications to a single execution node process that facilitates communication between the stored procedure and additional services and components of the database system.

5. The method of claim 1 , further comprising:

submitting, via the execution node, the database query to a compute service manager on behalf of the stored procedure, wherein the execution node issues the database query to a specific endpoint of the compute service manager being designated to process the database query from the stored procedure.

6. The method of claim 5 , further comprising:

receiving, via the execution node, a response from the compute service manager; and

converting the response, from the compute service manager, into a response remote procedure call, wherein the response remote procedure call is a result of the database query.

7. The method of claim 6 , further comprising:

returning, via the execution node, the result of the database query the relay back to the stored procedure within the sandbox process.

8. A system comprising:

one or more hardware processors of a machine; and

at least one memory storing instructions that, when executed by the one or more hardware processors, cause the system to perform operations comprising:

receiving, via an execution node, a response to a database query;

converting, via an Application Programming Interface (API) executing within a sandbox process, the response into a remote procedure call;

modifying, by at least one hardware processor, the sandbox process to restrict communication with an external network and to enable communication with the execution node, the execution node facilitating communication between a stored procedure and a component of a database system;

providing, to the stored procedure executing within the sandbox process, the remote procedure call as the response to the database query, the stored procedure executing within the sandbox process causing the API to communicate with the execution node; and

submitting, by the execution node, the database query to the component of the database system.

9. The system of claim 8 , wherein the stored procedure is configured to perform file operations including reading from stages and uploading to the stages within the database system, wherein the stored procedure is a subroutine stored within the database system to invoke specified functionality.

10. The system of claim 8 , the operations further comprising:

loading the sandbox process with a JAVA database connectivity instance, the JAVA database connectivity instance being modified to limit communication abilities of the stored procedure.

11. The system of claim 10 , the operations further comprising:

modifying the JAVA database connectivity instance to limit communications to a single execution node process that facilitates communication between the stored procedure and additional services and components of the database system.

12. The system of claim 8 , the operations further comprising:

submitting, via the execution node, the database query to a compute service manager on behalf of the stored procedure, wherein the execution node issues the database query to a specific endpoint of the compute service manager being designated to process the database query from the stored procedure.

13. The system of claim 12 , the operations further comprising:

receiving, via the execution node, a response from the compute service manager; and

converting the response, from the compute service manager, into a response remote procedure call, wherein the response remote procedure call is a result of the database query.

14. The system of claim 13 , the operations further comprising:

returning, via the execution node, the result of the database query for relay back to the stored procedure within the sandbox process.

15. A machine-readable medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

receiving, via an execution node, a response to a database query;

converting, via an Application Programming Interface (API) executing within a sandbox process, the response into a remote procedure call;

modifying, by at least one hardware processor, the sandbox process to restrict communication with an external network and to enable communication with the execution node, the execution node facilitating communication between a stored procedure and a component of a database system;

providing, to the stored procedure executing within the sandbox process, the remote procedure call as the response to the database query, the stored procedure executing within the sandbox process causing the API to communicate with the execution node; and

submitting, by the execution node, the database query to the component of the database system.

16. The machine-readable medium of claim 15 , wherein the stored procedure is configured to perform file operations including reading from stages and uploading to the stages within the database system, wherein the stored procedure is a subroutine stored within the database system to invoke specified functionality.

17. The machine-readable medium of claim 15 , the operations further comprising:

loading the sandbox process with a JAVA database connectivity instance, the JAVA database connectivity instance being modified to limit communication abilities of the stored procedure.

18. The machine-readable medium of claim 17 , the operations further comprising:

modifying the JAVA database connectivity instance to limit communications to a single execution node process that facilitates communication between the stored procedure and additional services and components of the database system.

19. The machine-readable medium of claim 15 , the operations further comprising:

submitting, via the execution node, the database query to a compute service manager on behalf of the stored procedure, wherein the execution node issues the database query to a specific endpoint of the compute service manager being designated to process the database query from the stored procedure.

20. The machine-readable medium of claim 19 , the operations further comprising:

receiving, via the execution node, a response from the compute service manager;

converting the response, from the compute service manager, into a response remote procedure call, wherein the response remote procedure call is a result of the database query; and

returning, via the execution node, the result of the database query for relay back to the stored procedure within the sandbox process.

Assignments (1)

Continuity (7)

References Cited (29)