US 11,836,138 B1
Overlap results data generation on a cloud data platform
Matthew J. Glickman, Larchmont, NY (US); Orestis Kostakis, Redmond, WA (US); and Justin Langseth, Kailua, HI (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jan. 31, 2023, as Appl. No. 18/162,688.
Application 18/162,688 is a continuation of application No. 17/804,434, filed on May 27, 2022.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/245 (2019.01); G06F 16/24 (2019.01); G06F 16/2455 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/24568 (2019.01) [G06F 16/244 (2019.01); G06F 16/2456 (2019.01); G06F 16/24564 (2019.01)] 24 Claims
OG exemplary drawing
 
1. A method comprising:
identifying, by at least one hardware processor, a first dataset of a plurality of distributed datasets on a cloud data platform, the first dataset being associated with a first user of the cloud data platform;
identifying a semantic type for each feature of the first dataset each feature including a column of a plurality of columns of the plurality of distributed datasets;
identifying a semantic type for each feature of each dataset of the plurality of distributed datasets;
comparing semantic types, the semantic types including each identified semantic type for each feature of the first dataset and each identified semantic type for each feature of each dataset of the plurality of distributed datasets;
generating, based on the comparing of the semantic types, a plurality of overlap requests that are configured to output overlap datasets between the first dataset and one or more of the plurality of distributed datasets;
storing, on the cloud data platform, the overlap datasets, each of the overlap datasets including a set of common features and a set of non-common features between the first dataset and the one or more of the plurality of distributed datasets;
recommending, to the first user, a Joined dataset based on semantic types of the set of non-common features;
generating the Joined dataset including data from the first dataset and data from the one or more of the plurality of distributed datasets;
generating a results dataset by applying one or more of the plurality of overlap requests to the joined dataset; and
returning, to the first user, the results dataset.