René's URL Explorer Experiment


Title: Historical retrieval by MattDelac · Pull Request #3 · Shopify/feast · GitHub

Open Graph Title: Historical retrieval by MattDelac · Pull Request #3 · Shopify/feast

X Title: Historical retrieval by MattDelac · Pull Request #3 · Shopify/feast

Description: What this PR does / why we need it: The current SQL template of point in time join does not scale Problem 1: ROW_NUMBER() does not scale In order to calculate a unique ID for each row of the entity...

Open Graph Description: What this PR does / why we need it: The current SQL template of point in time join does not scale Problem 1: ROW_NUMBER() does not scale In order to calculate a unique ID for each row of the entity...

X Description: What this PR does / why we need it: The current SQL template of point in time join does not scale Problem 1: ROW_NUMBER() does not scale In order to calculate a unique ID for each row of the entity...

Opengraph URL: https://github.com/Shopify/feast/pull/3

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controllervoltron_pull_requests_fragments
route-actionpull_request_layout
fetch-noncev2:abaf40b7-54cb-adfa-3e91-b564eb0001d9
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idBCBA:286A33:303859C:409FFFC:697AE63D
html-safe-nonce7c274b3ee0b21e5b38b6647fc916b7db0b86fe64edc172b2fddcabfbae409a47
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQ0JBOjI4NkEzMzozMDM4NTlDOjQwOUZGRkM6Njk3QUU2M0QiLCJ2aXNpdG9yX2lkIjoiMjQyNjA5NDMwODQ5NTY0ODMxNyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac6025f682c3bde8cf4f3a55f1eefe63c6f0b282ca414e5d7296b64db171189873
hovercard-subject-tagpull_request:657504689
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/pull_requests_fragments/pull_request_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/Shopify/feast/3/pull_request_layout
twitter:imagehttps://avatars.githubusercontent.com/u/8085?s=400&v=4
twitter:cardsummary
og:imagehttps://avatars.githubusercontent.com/u/8085?s=400&v=4
og:image:altWhat this PR does / why we need it: The current SQL template of point in time join does not scale Problem 1: ROW_NUMBER() does not scale In order to calculate a unique ID for each row of the entity...
og:site_nameGitHub
og:typeobject
og:author:usernameMattDelac
hostnamegithub.com
expected-hostnamegithub.com
Noneacb44186e5993a96be5027102cfa89a9a5fdd69da273fa313019549e77bf0f60
turbo-cache-controlno-preview
go-importgithub.com/Shopify/feast git https://github.com/Shopify/feast.git
octolytics-dimension-user_id8085
octolytics-dimension-user_loginShopify
octolytics-dimension-repository_id359585309
octolytics-dimension-repository_nwoShopify/feast
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id161133770
octolytics-dimension-repository_parent_nwofeast-dev/feast
octolytics-dimension-repository_network_root_id161133770
octolytics-dimension-repository_network_root_nwofeast-dev/feast
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasea468b3a5db28b95af32540a83825720c4311de46
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FShopify%2Ffeast%2Fpull%2F3
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FShopify%2Ffeast%2Fpull%2F3
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=Shopify%2Ffeast
Reloadhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
Reloadhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
Reloadhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
Shopify https://patch-diff.githubusercontent.com/Shopify
feasthttps://patch-diff.githubusercontent.com/Shopify/feast
feast-dev/feasthttps://patch-diff.githubusercontent.com/feast-dev/feast
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2FShopify%2Ffeast
Fork 3 https://patch-diff.githubusercontent.com/login?return_to=%2FShopify%2Ffeast
Star 3 https://patch-diff.githubusercontent.com/login?return_to=%2FShopify%2Ffeast
Code https://patch-diff.githubusercontent.com/Shopify/feast
Pull requests 10 https://patch-diff.githubusercontent.com/Shopify/feast/pulls
Actions https://patch-diff.githubusercontent.com/Shopify/feast/actions
Projects 0 https://patch-diff.githubusercontent.com/Shopify/feast/projects
Models https://patch-diff.githubusercontent.com/Shopify/feast/models
Security 0 https://patch-diff.githubusercontent.com/Shopify/feast/security
Insights https://patch-diff.githubusercontent.com/Shopify/feast/pulse
Code https://patch-diff.githubusercontent.com/Shopify/feast
Pull requests https://patch-diff.githubusercontent.com/Shopify/feast/pulls
Actions https://patch-diff.githubusercontent.com/Shopify/feast/actions
Projects https://patch-diff.githubusercontent.com/Shopify/feast/projects
Models https://patch-diff.githubusercontent.com/Shopify/feast/models
Security https://patch-diff.githubusercontent.com/Shopify/feast/security
Insights https://patch-diff.githubusercontent.com/Shopify/feast/pulse
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
masterhttps://patch-diff.githubusercontent.com/Shopify/feast/tree/master
historical_retrievalhttps://patch-diff.githubusercontent.com/Shopify/feast/tree/historical_retrieval
Historical retrieval https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#top
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
masterhttps://patch-diff.githubusercontent.com/Shopify/feast/tree/master
historical_retrievalhttps://patch-diff.githubusercontent.com/Shopify/feast/tree/historical_retrieval
Conversation 1 https://patch-diff.githubusercontent.com/Shopify/feast/pull/3
Commits 9 https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits
Checks 0 https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/checks
Files changed https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/files
Please reload this pagehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/Shopify/feast/pull/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/MattDelac
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
May 29, 2021https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#issue-906519755
Please reload this pagehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
https://user-images.githubusercontent.com/18557047/120198913-a46f4700-c1f0-11eb-8bf5-6339275effd9.png
FARM_FINGERPRINT()https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions
GENERATE_UUID()https://cloud.google.com/bigquery/docs/reference/standard-sql/uuid_functions
Please reload this pagehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
April 27, 2021 17:18https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#commits-pushed-b55d739
Add dev.yml for our forked projecthttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/b55d739ba5e9cbb9f683481439402cbddf179803
b55d739https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/b55d739ba5e9cbb9f683481439402cbddf179803
Add gcloud authhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/2bf61988512990a53a76737fcc04148123b05c35
2bf6198https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/2bf61988512990a53a76737fcc04148123b05c35
https://patch-diff.githubusercontent.com/MattDelac
Merge pull requesthttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/4fd072f25c53e6a5939732dbe22072d4bb1290fa
#2https://github.com/Shopify/feast/pull/2
from Shopify/add_dev_ymlhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/4fd072f25c53e6a5939732dbe22072d4bb1290fa
4fd072fhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/4fd072f25c53e6a5939732dbe22072d4bb1290fa
Use shopify-data-ml-platform-exp projecthttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/73bf70684965bce56b0e8a09741cae37378548bb
73bf706https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/73bf70684965bce56b0e8a09741cae37378548bb
https://patch-diff.githubusercontent.com/MattDelac
Merge pull requesthttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77
#4https://github.com/Shopify/feast/pull/4
from Shopify/update_dev_yamlhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77
f9f8c52https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77
Try different historical retrieval strategyhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/43b2a07cfb63ec327e365558d8a4ddd581ff7b14
43b2a07https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/43b2a07cfb63ec327e365558d8a4ddd581ff7b14
Refactor of point in time templatehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/2a1d15addbb25553da8cd958e9cbd4e0f2559e3a
2a1d15ahttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/2a1d15addbb25553da8cd958e9cbd4e0f2559e3a
Use deterministic hash without a window functionhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/01a8cffafd8c720855ca3512e9fd684db0e7f4bd
01a8cffhttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/01a8cffafd8c720855ca3512e9fd684db0e7f4bd
Improve doc on SQL templatehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/74b11d10b70a2ea35670a9bdf0dab18728e48c6d
74b11d1https://patch-diff.githubusercontent.com/Shopify/feast/pull/3/commits/74b11d10b70a2ea35670a9bdf0dab18728e48c6d
https://patch-diff.githubusercontent.com/MattDelac
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
force-pushedhttps://patch-diff.githubusercontent.com/Shopify/feast/compare/2231ecee74269559ae5ee92a5ff342322d0eb8df..74b11d10b70a2ea35670a9bdf0dab18728e48c6d
2231ecehttps://patch-diff.githubusercontent.com/Shopify/feast/commit/2231ecee74269559ae5ee92a5ff342322d0eb8df
74b11d1https://patch-diff.githubusercontent.com/Shopify/feast/commit/74b11d10b70a2ea35670a9bdf0dab18728e48c6d
Compare https://patch-diff.githubusercontent.com/Shopify/feast/compare/2231ecee74269559ae5ee92a5ff342322d0eb8df..74b11d10b70a2ea35670a9bdf0dab18728e48c6d
May 31, 2021 15:28https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#event-4821245835
https://patch-diff.githubusercontent.com/asad-a
asad-ahttps://patch-diff.githubusercontent.com/asad-a
May 31, 2021https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#issuecomment-851567313
@MattDelachttps://github.com/MattDelac
Please reload this pagehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
https://patch-diff.githubusercontent.com/MattDelac
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
force-pushedhttps://patch-diff.githubusercontent.com/Shopify/feast/compare/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77..6469647ed8c921b318fcccdef11c9009168099f7
f9f8c52https://patch-diff.githubusercontent.com/Shopify/feast/commit/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77
6469647https://patch-diff.githubusercontent.com/Shopify/feast/commit/6469647ed8c921b318fcccdef11c9009168099f7
Compare https://patch-diff.githubusercontent.com/Shopify/feast/compare/f9f8c525e4589faf8c3c3bab065d9ff388c5dc77..6469647ed8c921b318fcccdef11c9009168099f7
May 31, 2021 16:50https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#event-4821513226
https://patch-diff.githubusercontent.com/MattDelac
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
force-pushedhttps://patch-diff.githubusercontent.com/Shopify/feast/compare/8565cb6fcfab428f26b3bbbac6ddd972fb69c149..cbd930e88412f25ec008161c36987dda0533a481
8565cb6https://patch-diff.githubusercontent.com/Shopify/feast/commit/8565cb6fcfab428f26b3bbbac6ddd972fb69c149
cbd930ehttps://patch-diff.githubusercontent.com/Shopify/feast/commit/cbd930e88412f25ec008161c36987dda0533a481
Compare https://patch-diff.githubusercontent.com/Shopify/feast/compare/8565cb6fcfab428f26b3bbbac6ddd972fb69c149..cbd930e88412f25ec008161c36987dda0533a481
June 30, 2021 18:01https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#event-4961305135
https://patch-diff.githubusercontent.com/MattDelac
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
force-pushedhttps://patch-diff.githubusercontent.com/Shopify/feast/compare/36b40e6282ad4197db081f7e6feb0c727f245dd6..7977a5330a10f60211291b29c3c646ea4f18b87f
36b40e6https://patch-diff.githubusercontent.com/Shopify/feast/commit/36b40e6282ad4197db081f7e6feb0c727f245dd6
7977a53https://patch-diff.githubusercontent.com/Shopify/feast/commit/7977a5330a10f60211291b29c3c646ea4f18b87f
Compare https://patch-diff.githubusercontent.com/Shopify/feast/compare/36b40e6282ad4197db081f7e6feb0c727f245dd6..7977a5330a10f60211291b29c3c646ea4f18b87f
August 5, 2021 11:57https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#event-5117021552
MattDelachttps://patch-diff.githubusercontent.com/MattDelac
Dec 1, 2021 https://patch-diff.githubusercontent.com/Shopify/feast/pull/3#ref-commit-b5d8a53
Fix integration testshttps://patch-diff.githubusercontent.com/Shopify/feast/commit/b5d8a531c81fa11297e5c684f898646cb2ee2cd1
#3https://github.com/Shopify/feast/pull/3
b5d8a53https://patch-diff.githubusercontent.com/Shopify/feast/commit/b5d8a531c81fa11297e5c684f898646cb2ee2cd1
Sign up for freehttps://patch-diff.githubusercontent.com/join?source=comment-repo
Sign inhttps://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FShopify%2Ffeast%2Fpull%2F3
Please reload this pagehttps://patch-diff.githubusercontent.com/Shopify/feast/pull/3
https://patch-diff.githubusercontent.com/MattDelac
https://patch-diff.githubusercontent.com/asad-a
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.