Error tables for use with recovery actions
Techniques for creating and using error tables to track errors associated with a base table are described. A command to perform an operation on a base table stored in a network-based data system can be received and executed, causing at least one error. At least one error record corresponding to the at least one error can be inputted into an error table, which is nested with the base table. Contextual information can be added to the at least one error record.
1 . A method comprising:
receiving a query directed to an error table nested with a base table in a network-based data system;
executing the query on the error table to provide information about an error record in the error table;
performing a recovery action based on the information about the error record;
executing an action on at least one row in the base table after performing the recovery action;
determining that the executing the action was successful; and
deleting the error record from the error table.
2 . The method of claim 1 , wherein the base table is provided as a parent object and the error table is provided as a child object to the base table in the network-based data system.
3 . The method of claim 2 , wherein the base table comprises a materialized view.
4 . The method of claim 1 , wherein the error record corresponds to an error that was detected in response to an operation being executed on the base table.
5 . The method of claim 4 , wherein the operation includes auto-ingestion of data in a file from an external location into the base table.
6 . The method of claim 4 , wherein the operation includes performing an action on an external table stored outside of the network-based data system.
7 . The method of claim 6 , wherein the base table is an object stored in the network-based data system representing the external table.
8 . A non-transitory machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:
receiving a query directed to an error table nested with a base table in a network-based data system;
executing the query on the error table to provide information about an error record in the error table;
performing a recovery action based on the information about the error record;
executing an action on at least one row in the base table after performing the recovery action;
determining that the executing the action was successful; and
deleting the error record from the error table.
9 . The non-transitory machine-storage medium of claim 8 , wherein the base table is provided as a parent object and the error table is provided as a child object to the base table in the network-based data system.
10 . The non-transitory machine-storage medium of claim 9 , wherein the base table comprises a materialized view.
11 . The non-transitory machine-storage medium of claim 8 , wherein the error record corresponds to an error that was detected in response to an operation being executed on the base table.
12 . The non-transitory machine-storage medium of claim 11 , wherein the operation includes auto-ingestion of data in a file from an external location into the base table.
13 . The non-transitory machine-storage medium of claim 11 , wherein the operation includes performing an action on an external table stored outside of the network-based data system.
14 . The non-transitory machine-storage medium of claim 13 , wherein the base table is an object stored in the network-based data system representing the external table.
15 . A system comprising:
at least one hardware processor; and
at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
receiving a query directed to an error table nested with a base table in a network-based data system;
executing the query on the error table to provide information about an error record in the error table;
performing a recovery action based on the information about the error record;
executing an action on at least one row in the base table after performing the recovery action;
determining that the executing the action was successful; and
deleting the error record from the error table.
16 . The system of claim 15 , wherein the base table is provided as a parent object and the error table is provided as a child object to the base table in the network-based data system.
17 . The system of claim 16 , wherein the base table comprises a materialized view.
18 . The system of claim 15 , wherein the error record corresponds to an error that was detected in response to an operation being executed on the base table.
19 . The system of claim 18 , wherein the operation includes auto-ingestion of data in a file from an external location into the base table.
20 . The system of claim 18 , wherein the operation includes performing an action on an external table stored outside of the network-based data system.
21 . The system of claim 20 , wherein the base table is an object stored in the network-based data system representing the external table.