{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":805013151,"defaultBranch":"main","name":"de_portfolio_nyc_tlc","ownerLogin":"appauldev","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-05-23T17:58:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/23691370?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1716487125.0","currentOid":""},"activityList":{"items":[{"before":"3d1c4d0cfbd03d18af0821402493f39297c8d5e4","after":"acfc1ddecffed02cc5b9a763bd4372ecba999493","ref":"refs/heads/main","pushedAt":"2024-06-06T16:24:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add query to create trip misc details dimension | Perform some code cleanups when printing table metadata 🧹","shortMessageHtmlLink":"Add query to create trip misc details dimension | Perform some code c…"}},{"before":"8374202bfd6fdffde0fdeed46fe10df1106b7e89","after":"3d1c4d0cfbd03d18af0821402493f39297c8d5e4","ref":"refs/heads/main","pushedAt":"2024-06-06T15:35:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add query to create taxi trip location dimension (pickup and dropoff zones) using the NYC TLC taxi zone lookup table","shortMessageHtmlLink":"Add query to create taxi trip location dimension (pickup and dropoff …"}},{"before":"48b3cc55575d5bfd55bdf6c83588b79870970d05","after":"8374202bfd6fdffde0fdeed46fe10df1106b7e89","ref":"refs/heads/main","pushedAt":"2024-06-06T13:42:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update sql queries for syntax highlighting with Inline SQL vscode extension","shortMessageHtmlLink":"Update sql queries for syntax highlighting with Inline SQL vscode ext…"}},{"before":"e2fd1f09ca6d76942401139a8550300c50dd37d4","after":"48b3cc55575d5bfd55bdf6c83588b79870970d05","ref":"refs/heads/main","pushedAt":"2024-06-06T12:56:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add query for creating transaction fees dimension","shortMessageHtmlLink":"Add query for creating transaction fees dimension"}},{"before":"c21f00458411890ff19a548363df08810cd0c6a9","after":"e2fd1f09ca6d76942401139a8550300c50dd37d4","ref":"refs/heads/main","pushedAt":"2024-06-06T11:57:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add query to materialize trip datetime dimension | Update custom CheckSpec class","shortMessageHtmlLink":"Add query to materialize trip datetime dimension | Update custom Chec…"}},{"before":"9335c63d10b77363954f672727aaeb2d62423091","after":"c21f00458411890ff19a548363df08810cd0c6a9","ref":"refs/heads/main","pushedAt":"2024-06-05T17:34:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add initial dimension tables","shortMessageHtmlLink":"Add initial dimension tables"}},{"before":"29db90e9b143dcdc0a2a7c5183781018dcb57f4d","after":"9335c63d10b77363954f672727aaeb2d62423091","ref":"refs/heads/main","pushedAt":"2024-06-05T16:45:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Rename main table asset and add initial asset check","shortMessageHtmlLink":"Rename main table asset and add initial asset check"}},{"before":"3d844cf134485fa3181d9d2f12b4e7ecd40903d9","after":"29db90e9b143dcdc0a2a7c5183781018dcb57f4d","ref":"refs/heads/main","pushedAt":"2024-06-05T15:45:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update YT 2022 table assets to return MaterializeResult","shortMessageHtmlLink":"Update YT 2022 table assets to return MaterializeResult"}},{"before":"26bf9b5c735f803ac6250cddffef71b44d3f1ca6","after":"3d844cf134485fa3181d9d2f12b4e7ecd40903d9","ref":"refs/heads/main","pushedAt":"2024-06-04T16:39:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add initial table asset from parquet files using duckdb","shortMessageHtmlLink":"Add initial table asset from parquet files using duckdb"}},{"before":"c84d87186c0235b1d3dc43f6e478a1d25e329145","after":"26bf9b5c735f803ac6250cddffef71b44d3f1ca6","ref":"refs/heads/main","pushedAt":"2024-06-02T10:36:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Convert asset parquet checks to dataclasses","shortMessageHtmlLink":"Convert asset parquet checks to dataclasses"}},{"before":"389cc2548f19bf6d63eb2bd9cfe755ac014f0253","after":"c84d87186c0235b1d3dc43f6e478a1d25e329145","ref":"refs/heads/main","pushedAt":"2024-06-01T21:05:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Make parquet asset checks composable","shortMessageHtmlLink":"Make parquet asset checks composable"}},{"before":"8de5cb179e779e99a73d48050f91b09c5d44a164","after":"389cc2548f19bf6d63eb2bd9cfe755ac014f0253","ref":"refs/heads/main","pushedAt":"2024-06-01T20:08:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add initial checks for parquet assets","shortMessageHtmlLink":"Add initial checks for parquet assets"}},{"before":"e768bb6fbfc619229ce2f254c42f9b6c9da671ef","after":"8de5cb179e779e99a73d48050f91b09c5d44a164","ref":"refs/heads/main","pushedAt":"2024-05-31T09:25:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update data cleaning for parquet conversion","shortMessageHtmlLink":"Update data cleaning for parquet conversion"}},{"before":"94b7dd43a98bceacaad4aa3bc14b17e86045077f","after":"e768bb6fbfc619229ce2f254c42f9b6c9da671ef","ref":"refs/heads/main","pushedAt":"2024-05-30T17:37:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update fetching of csv asset to use helper functions | Update tests and diagram","shortMessageHtmlLink":"Update fetching of csv asset to use helper functions | Update tests a…"}},{"before":"523c0626bb83e6e058309f6636bffb21e3707ee2","after":"94b7dd43a98bceacaad4aa3bc14b17e86045077f","ref":"refs/heads/main","pushedAt":"2024-05-29T20:44:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add an op to get monthly range from partition","shortMessageHtmlLink":"Add an op to get monthly range from partition"}},{"before":"98eaa3bd056583c3f2af6dac39aa53831f4fb7cf","after":"523c0626bb83e6e058309f6636bffb21e3707ee2","ref":"refs/heads/main","pushedAt":"2024-05-28T12:45:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update diagram for stream downloading API response body","shortMessageHtmlLink":"Update diagram for stream downloading API response body"}},{"before":"ecfb9f80cd2e86786091facd65ab540028f4a559","after":"98eaa3bd056583c3f2af6dac39aa53831f4fb7cf","ref":"refs/heads/main","pushedAt":"2024-05-28T05:49:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add initial diagram for the stream download process for obtaining the csv asset | Add minor comments and modifications","shortMessageHtmlLink":"Add initial diagram for the stream download process for obtaining the…"}},{"before":"053a7254411af47b19fc1a4dcf16c950cd8307d4","after":"ecfb9f80cd2e86786091facd65ab540028f4a559","ref":"refs/heads/main","pushedAt":"2024-05-25T17:26:14.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Merge branch 'main' of remote to update local 'main' README","shortMessageHtmlLink":"Merge branch 'main' of remote to update local 'main' README"}},{"before":"68bc055d90128c6b153d82da27dca2b09902d733","after":"053a7254411af47b19fc1a4dcf16c950cd8307d4","ref":"refs/heads/main","pushedAt":"2024-05-24T16:10:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"6e243ce3170741dca1d716f8a4f7eabdbd6a31a2","after":"68bc055d90128c6b153d82da27dca2b09902d733","ref":"refs/heads/main","pushedAt":"2024-05-24T14:25:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"475549dbbf2ea95606547d1b533b214a849acaa9","after":"6e243ce3170741dca1d716f8a4f7eabdbd6a31a2","ref":"refs/heads/main","pushedAt":"2024-05-24T13:10:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Add initial ops for csv assets","shortMessageHtmlLink":"Add initial ops for csv assets"}},{"before":"21ccb7d5a504a40150e007f12648d6bea51cb6f8","after":"475549dbbf2ea95606547d1b533b214a849acaa9","ref":"refs/heads/main","pushedAt":"2024-05-23T18:22:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Edit readme","shortMessageHtmlLink":"Edit readme"}},{"before":"1bfa0925cabd12dadc02e6d82734ee2a4c2c51a6","after":"21ccb7d5a504a40150e007f12648d6bea51cb6f8","ref":"refs/heads/main","pushedAt":"2024-05-23T18:09:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"A not-so-initial commit  | Add csv asset from NYC Open Data API | Add parquet assets","shortMessageHtmlLink":"A not-so-initial commit | Add csv asset from NYC Open Data API | Add …"}},{"before":null,"after":"1bfa0925cabd12dadc02e6d82734ee2a4c2c51a6","ref":"refs/heads/main","pushedAt":"2024-05-23T17:58:45.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"appauldev","name":"Paul","path":"/appauldev","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/23691370?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEXmeixAA","startCursor":null,"endCursor":null}},"title":"Activity · appauldev/de_portfolio_nyc_tlc"}