{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":551526133,"defaultBranch":"main","name":"analyticswithanand","ownerLogin":"anandjha90","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2022-10-14T15:09:09.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/63854274?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1707760343.0","currentOid":""},"activityList":{"items":[{"before":"57fbe0eab2d4abd03e60bbc437fcbcfc21441d51","after":"cfced61f30912a17bb0f8d44124d3782c83f8851","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-05-28T16:03:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Set Of Questions For Snowflake Interview","shortMessageHtmlLink":"Set Of Questions For Snowflake Interview"}},{"before":"fbc3b4b1a53b3f9c062059b47493696c98b6cbf9","after":"57fbe0eab2d4abd03e60bbc437fcbcfc21441d51","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-16T20:58:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Update V_LOAD_IOTV2_JSON_IQOS4_HOLDER_EXP.sql","shortMessageHtmlLink":"Update V_LOAD_IOTV2_JSON_IQOS4_HOLDER_EXP.sql"}},{"before":"a2885b875338c48e808543e05e93e122dcae3315","after":"fbc3b4b1a53b3f9c062059b47493696c98b6cbf9","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-16T20:57:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Update script.sql","shortMessageHtmlLink":"Update script.sql"}},{"before":"16b3906af489ff618efa4a2731c37aae73519e84","after":"a2885b875338c48e808543e05e93e122dcae3315","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-12T17:53:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_nzexperience002f0052.csv","shortMessageHtmlLink":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_n…"}},{"before":"7e3f39c73dae1695c1d57ae4f4c9d352df2ddb79","after":"16b3906af489ff618efa4a2731c37aae73519e84","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-12T17:53:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_jpexperience00320055.csv","shortMessageHtmlLink":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_j…"}},{"before":"823c871759f211b8979e179e831c75cb88ff9178","after":"7e3f39c73dae1695c1d57ae4f4c9d352df2ddb79","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-12T17:52:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_euexperience00320055.csv","shortMessageHtmlLink":"Delete LECTURE 39 : MASTERING SEMI-STRUCTURED DATA : JSON/iotv2_prd_e…"}},{"before":"f89c328c9b92e4cb5ecfb5c5e290bc64efe4fa7e","after":"823c871759f211b8979e179e831c75cb88ff9178","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-12T17:52:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Use all these copy files for the data sources","shortMessageHtmlLink":"Use all these copy files for the data sources"}},{"before":"9a9805914dde110a28228056be765e87dbfadcc6","after":"f89c328c9b92e4cb5ecfb5c5e290bc64efe4fa7e","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T21:02:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Problem Statement For handling JSON data files","shortMessageHtmlLink":"Problem Statement For handling JSON data files"}},{"before":"865824cff8923dc175779b435230d44e2e681fd8","after":"9a9805914dde110a28228056be765e87dbfadcc6","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:58:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"All the data files for EU,JP&NZ Region\n\nThis has data files generated from e-cigarette for EU , JP & NZ region over a period of day at a particular time of the day.","shortMessageHtmlLink":"All the data files for EU,JP&NZ Region"}},{"before":"bc0525222592ae5f0b91687c847cbb5a7b1f093d","after":"865824cff8923dc175779b435230d44e2e681fd8","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:54:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"final view for JSON changes implementation","shortMessageHtmlLink":"final view for JSON changes implementation"}},{"before":"bec14eb3ffce03506305cccd2a5e4ee9d6711f99","after":"bc0525222592ae5f0b91687c847cbb5a7b1f093d","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:50:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Update and rename File Format Snowflake.txt to File Format Snowflake.sql","shortMessageHtmlLink":"Update and rename File Format Snowflake.txt to File Format Snowflake.sql"}},{"before":"3093e84ff3025c1c2d0de6d53047b9b7bf20c134","after":"bec14eb3ffce03506305cccd2a5e4ee9d6711f99","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:49:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"File Format required for data loading","shortMessageHtmlLink":"File Format required for data loading"}},{"before":"ba986a5e2b0b45226934fb93243a887e87c7a2e4","after":"3093e84ff3025c1c2d0de6d53047b9b7bf20c134","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:47:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Load Files Table Creation For s3 consumption","shortMessageHtmlLink":"Load Files Table Creation For s3 consumption"}},{"before":"362c20b4aa3681f0e130bbf92bf441bc16bafb83","after":"ba986a5e2b0b45226934fb93243a887e87c7a2e4","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:46:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Update script.sql","shortMessageHtmlLink":"Update script.sql"}},{"before":"d174ff7bc0ac95bb224ab2307b2cfcb05257d4df","after":"362c20b4aa3681f0e130bbf92bf441bc16bafb83","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:45:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Update READING_JSON_DATA.sql","shortMessageHtmlLink":"Update READING_JSON_DATA.sql"}},{"before":"1c60e546e754dd4984373d4ce411ef11b142d59d","after":"d174ff7bc0ac95bb224ab2307b2cfcb05257d4df","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:42:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Parsing JSON Data Files","shortMessageHtmlLink":"Parsing JSON Data Files"}},{"before":"047900aff0a30e33a7bf66b9decc576c00231eed","after":"1c60e546e754dd4984373d4ce411ef11b142d59d","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:15:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"SQL Script for creating respective tables\n\nAlong with Tables Staging script also has been given so as to load data from AWS S3 bucket.","shortMessageHtmlLink":"SQL Script for creating respective tables"}},{"before":"532e670dd3481c3a2ac2761316b4f2e493865358","after":"047900aff0a30e33a7bf66b9decc576c00231eed","ref":"refs/heads/SNOWFLAKE","pushedAt":"2024-02-10T20:09:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create test","shortMessageHtmlLink":"Create test"}},{"before":"2807775728b22a537b6c3713718b31392910a74c","after":"532e670dd3481c3a2ac2761316b4f2e493865358","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T12:18:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create joins_internal_implementation","shortMessageHtmlLink":"Create joins_internal_implementation"}},{"before":"8a1997bdf6969378e9321ad746839eb8ca58085c","after":"2807775728b22a537b6c3713718b31392910a74c","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T11:35:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create master_table_creation_script","shortMessageHtmlLink":"Create master_table_creation_script"}},{"before":"29b68fdd25f8240752fe204bea4cf2b69dd394bf","after":"8a1997bdf6969378e9321ad746839eb8ca58085c","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:28:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create cross_join_implementation","shortMessageHtmlLink":"Create cross_join_implementation"}},{"before":"ffe61577268701dc4ce807b68c32bd5174a459a3","after":"29b68fdd25f8240752fe204bea4cf2b69dd394bf","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:15:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Delete LECTURE 21,22,23 : JOINS full_join_implementation","shortMessageHtmlLink":"Delete LECTURE 21,22,23 : JOINS full_join_implementation"}},{"before":"591065948033d74f22be7afca281f69a7a74db5d","after":"ffe61577268701dc4ce807b68c32bd5174a459a3","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:14:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create full_join_implementation","shortMessageHtmlLink":"Create full_join_implementation"}},{"before":"545d0abf0c0284346a3af403da5de54cf24faaaa","after":"591065948033d74f22be7afca281f69a7a74db5d","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:14:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create LECTURE 21,22,23 : JOINS full_join_implementation","shortMessageHtmlLink":"Create LECTURE 21,22,23 : JOINS full_join_implementation"}},{"before":"fcc1228b31186406f42a10bb41b6036d58d3afb7","after":"545d0abf0c0284346a3af403da5de54cf24faaaa","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:06:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Rename left_joins_implementation to left_join_implementation","shortMessageHtmlLink":"Rename left_joins_implementation to left_join_implementation"}},{"before":"6c34e7937ef7bbce29034af80137cbfa6d45e2cc","after":"fcc1228b31186406f42a10bb41b6036d58d3afb7","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T09:06:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create right_join_implementation","shortMessageHtmlLink":"Create right_join_implementation"}},{"before":"f49c628d272e045317606b8c414b4f9c47347a4d","after":"6c34e7937ef7bbce29034af80137cbfa6d45e2cc","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T08:45:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create inner_join_implementation","shortMessageHtmlLink":"Create inner_join_implementation"}},{"before":"f82d5f6bca07f09d8da82437079b359701ed02f2","after":"ae1ce1433b81e97d93f9298cb52b81783f4e1b33","ref":"refs/heads/matillion_jobs","pushedAt":"2023-10-28T08:45:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"deleted wrong file upload","shortMessageHtmlLink":"deleted wrong file upload"}},{"before":"bac4c056fca218c6e404b98ed886618de95f30f2","after":"f82d5f6bca07f09d8da82437079b359701ed02f2","ref":"refs/heads/matillion_jobs","pushedAt":"2023-10-28T08:44:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create inner_join_implementation","shortMessageHtmlLink":"Create inner_join_implementation"}},{"before":"83046753a31032d2cc36f92987d7af3072c5bb31","after":"f49c628d272e045317606b8c414b4f9c47347a4d","ref":"refs/heads/SNOWFLAKE","pushedAt":"2023-10-28T08:14:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anandjha90","name":"Anand Jha","path":"/anandjha90","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/63854274?s=80&v=4"},"commit":{"message":"Create self_joins_implementation","shortMessageHtmlLink":"Create self_joins_implementation"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEVg1dvgA","startCursor":null,"endCursor":null}},"title":"Activity · anandjha90/analyticswithanand"}