This week, we’re diving into the “Cybersyn US Patent Grants” dataset from the Market Place and use our own functions to interact with it.
The cool thing about user-defined functions (UDFs) is that they’re like your personal toolkit. You can use them to save a specific calculation, share it with the whole team, and even tweak it centrally when business needs change. And guess what? You can use them on public datasets, like the one from Cybersyn.
So, here’s the game plan:
- Grab the Cybersyn US Patent Grants dataset from the marketplace.
- Use Cybersyn’s SQL query to dig up all patents related to Nvidia (we’ve put a limit of 10 in there so as not to overwhelm you with the results):
SQL code
SELECT patent_index.patent_id
, invention_title
, patent_type
, application_date
, document_publication_date
FROM cybersyn_us_patent_grants.cybersyn.uspto_contributor_index AS contributor_index
INNER JOIN
cybersyn_us_patent_grants.cybersyn.uspto_patent_contributor_relationships AS relationships
ON contributor_index.contributor_id = relationships.contributor_id
INNER JOIN
cybersyn_us_patent_grants.cybersyn.uspto_patent_index AS patent_index
ON relationships.patent_id = patent_index.patent_id
WHERE contributor_index.contributor_name ILIKE 'NVIDIA CORPORATION'
AND relationships.contribution_type = 'Assignee - United States Company Or Corporation'
LIMIT 10
- Create a function that gives a thumbs up (TRUE) or thumbs down (FALSE) based on this: The gap between
APPLICATION_DATE
andPUBLICATION_DATE
can be 365 days for “Reissue” patents and 2 years for “design” ones.
All clear? Let’s get to it!
61 responses to “Week 65 – Basic”
-
Looks like an interesting dataset to dive into
- Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
-
Thanks for the challenge,
UDF created as pre-hook for the model… I even left the leading commas as in the provided query… https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_65.sql- Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/macros/ch_65_create_function.sql
-
Basic one to get started
- Solution URL – https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_65.sql
-
the power adaptor is back. This time with an innovative design!
- Solution URL – https://github.com/NMangera/frosty_friday/blob/main/week%2065%20-%20basic%20/UDF%20%26%20Marketplace
-
… [Trackback]
[…] There you will find 13685 more Infos: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Read More here to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More here to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Read More to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Here you can find 40425 additional Information to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More on to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] There you will find 17825 more Information on that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Read More to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] There you can find 62267 additional Information on that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More Information here on that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Find More on that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Read More to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Here you can find 38872 additional Information to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
-
… [Trackback]
[…] Read More Info here to that Topic: frostyfriday.org/blog/2023/09/29/week-65-basic/ […]
Leave a Reply
You must be logged in to post a comment.