Data certification process for cloud database platform

A method for providing access to records of a database stored on a database server, the method comprising:

• determining, by a data sharing platform, one or more first rules that specify criteria, associated with consumer permissions to access the database via a cloud database platform, that limit consumer access to the records stored by the database;
• performing, based on the one or more first rules, a data access certification process on the records stored by the database to generate a table of certification results by:
• accessing all the records stored by the database;
• generating a data certification result for each record based on determining, for each record, whether a given record satisfies the criteria of the one or more first rules based on one or more fields of the given record;
• and
• generating, based on the data certification result for each record, the table of certification results that indicates, for each record, whether the record satisfies the criteria of the one or more first rules;
• generating, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition configured to provide access to a first portion of the records in compliance with the criteria of the one or more first rules and exclude a second portion of the records not in compliance with the criteria of the one or more first rules;
• and
• causing a first virtual warehouse provided by the cloud database platform to execute a query on the first portion of the records in compliance with the criteria of the one or more first rules via the limited consumer view definition.

One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors of a data sharing platform, cause the data sharing platform to provide access to records of a database stored on a database server by causing the data sharing platform to:

• determine one or more first rules that specify criteria, associated with consumer permissions to access the database via a cloud database platform, that limit consumer access to the records stored by the database;
• perform, based on the one or more first rules, a data access certification process on the records stored by the database to generate a table of certification results by causing the data sharing platform to:
• access all the records stored by the database;
• generate a data certification result for each record based on determining, for each record, whether a given record satisfies the criteria of the one or more first rules based on one or more fields of the given record;
• and
• generate, based on the data certification result for each record, the table of certification results that indicates, for each record, whether the record satisfies the criteria of the one or more first rules;
• generate, based on the table of certification results, and without modifying the records stored by the database, a limited consumer view definition configured to provide access to a first portion of the records in compliance with the criteria of the one or more first rules and exclude a second portion of the records not in compliance with the criteria of the one or more first rules;
• and
• cause a first virtual warehouse provided by the cloud database platform to execute a query on the first portion of the records in compliance with the criteria of the one or more first rules via the limited consumer view definition.