{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":778364921,"defaultBranch":"main","name":"fakesnow","ownerLogin":"peak","currentUserCanPush":false,"isFork":true,"isEmpty":false,"createdAt":"2024-03-27T15:30:01.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/965793?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1712334942.0","currentOid":""},"activityList":{"items":[{"before":"e5dd22935c9f3977645927f048bfe3145d9d0247","after":"37baee7c918a0a9158d1f092372ba0001611843e","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-05T16:35:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"bump version 0.9.6+peak.2","shortMessageHtmlLink":"bump version 0.9.6+peak.2"}},{"before":"f3e1e7ae01cf5d692432967623b84d5c7d022321","after":"e5dd22935c9f3977645927f048bfe3145d9d0247","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-05T16:33:08.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"add transformation for object_agg function (#1)\n\n* add transformation for object_agg function\r\n\r\n* add more tests  for object_agg\r\n\r\n* rm duplicate tests\r\n\r\n* ruff format","shortMessageHtmlLink":"add transformation for object_agg function (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2228356245\" data-permission-text=\"Title is private\" data-url=\"https://github.com/peak/fakesnow/issues/1\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/peak/fakesnow/pull/1/hovercard\" href=\"https://github.com/peak/fakesnow/pull/1\">#1</a>)"}},{"before":"1d1101e17f9ebbdf91850507ab4ae9898d5c3e88","after":"7c203b11a138c7e79c5b3a8f505460067ca9eea1","ref":"refs/heads/object_agg","pushedAt":"2024-04-05T16:26:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"ruff format","shortMessageHtmlLink":"ruff format"}},{"before":"35598163075a2009f17d44f13754541b1001056f","after":"1d1101e17f9ebbdf91850507ab4ae9898d5c3e88","ref":"refs/heads/object_agg","pushedAt":"2024-04-05T16:24:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"rm duplicate tests","shortMessageHtmlLink":"rm duplicate tests"}},{"before":"5d31975c025174707cadef7223c3ac60e18e49f5","after":"35598163075a2009f17d44f13754541b1001056f","ref":"refs/heads/object_agg","pushedAt":"2024-04-05T16:19:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"add more tests  for object_agg","shortMessageHtmlLink":"add more tests for object_agg"}},{"before":null,"after":"5d31975c025174707cadef7223c3ac60e18e49f5","ref":"refs/heads/object_agg","pushedAt":"2024-04-05T15:53:25.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ilkinulas","name":"İlkin Balkanay","path":"/ilkinulas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/606324?s=80&v=4"},"commit":{"message":"add transformation for object_agg function","shortMessageHtmlLink":"add transformation for object_agg function"}},{"before":"b7ad8fe2b3ad984ef0b26a2d799ea1e13b7b6f47","after":null,"ref":"refs/tags/v0.9.6+peak.1","pushedAt":"2024-04-02T16:16:52.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"}},{"before":"b7ad8fe2b3ad984ef0b26a2d799ea1e13b7b6f47","after":"f3e1e7ae01cf5d692432967623b84d5c7d022321","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-02T16:16:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"feat!: handle VARCHAR[] column type","shortMessageHtmlLink":"feat!: handle VARCHAR[] column type"}},{"before":"b7ad8fe2b3ad984ef0b26a2d799ea1e13b7b6f47","after":null,"ref":"refs/tags/0.9.6+peak.1","pushedAt":"2024-04-02T14:46:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"}},{"before":"1a818855302f86bf25f08959e34149b45277bf94","after":"b7ad8fe2b3ad984ef0b26a2d799ea1e13b7b6f47","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-02T14:43:57.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"pyproject: set version to 0.9.6+peak.1","shortMessageHtmlLink":"pyproject: set version to 0.9.6+peak.1"}},{"before":"97e57f7701206d7b7fbee4b025a7557b77ff38f6","after":"1a818855302f86bf25f08959e34149b45277bf94","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-02T14:38:19.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"pyproject: set version to 0.9.6.dev1","shortMessageHtmlLink":"pyproject: set version to 0.9.6.dev1"}},{"before":"97e57f7701206d7b7fbee4b025a7557b77ff38f6","after":null,"ref":"refs/tags/v0.9.6-peak.1","pushedAt":"2024-04-02T14:36:16.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"}},{"before":"19e445dd6e3ff1fd3086db82e02627e7f863d5d4","after":"97e57f7701206d7b7fbee4b025a7557b77ff38f6","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-02T14:14:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"pyproject: set version to 0.9.6-peak.1","shortMessageHtmlLink":"pyproject: set version to 0.9.6-peak.1"}},{"before":"19e445dd6e3ff1fd3086db82e02627e7f863d5d4","after":null,"ref":"refs/tags/v0.9.6-peak.1","pushedAt":"2024-04-02T14:13:53.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"}},{"before":null,"after":"19e445dd6e3ff1fd3086db82e02627e7f863d5d4","ref":"refs/heads/dbtunittest","pushedAt":"2024-04-02T13:22:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"feat!: add to_variant","shortMessageHtmlLink":"feat!: add to_variant"}},{"before":null,"after":"66bd16bbb2f1e1893fd14aff84ee1d508fa1211d","ref":"refs/heads/fix-json_extract_cast_as_varchar","pushedAt":"2024-04-02T11:01:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"fix(json_extract_cast_as_varchar): work on VARCHAR","shortMessageHtmlLink":"fix(json_extract_cast_as_varchar): work on VARCHAR"}},{"before":"f62ab034204bbe029962f60938736bbf53fea73b","after":"32afc18157fe0a2b1692165eeca87a1ef27ca8c0","ref":"refs/heads/main","pushedAt":"2024-04-02T08:07:33.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"feat: add ARRAY_AGG() WITHIN GROUP() support (#66)\n\nIn Snowflake, to order elements in `ARRAY_AGG` aggregation one needs to\r\nprovide `WITHIN GROUP (..)`;\r\n*\r\nhttps://docs.snowflake.com/en/sql-reference/functions/array_agg#arguments\r\n    \r\n    ```\r\n    ARRAY_AGG(<expr>) WITHIN GROUP (<order-by-clause>)\r\n    ```\r\nIn DuckDB, `LIST()/ARRAY_AGG()` requires expression to be passed ordered\r\nand does not support `WITHIN GROUP (...)`;\r\n*\r\nhttps://duckdb.org/docs/sql/aggregates.html#order-by-clause-in-aggregate-functions\r\n    ```\r\n    ARRAY_AGG( <expr> <order-by-clause> )\r\n    ```\r\n\r\nThis transformer simply combines *aggreage* expression in `ARRAY_AGG`\r\nand *ordering* one in `WITHIN GROUP` in an *order* expression.\r\n\r\n```sql\r\nARRAY_AGG(DISTINCT id) WITHIN GROUP (ORDER BY id)\r\n```\r\n\r\n```python\r\nWithinGroup(\r\n  this=ArrayAgg(\r\n    this=Distinct(\r\n      expressions=[\r\n        Column(\r\n          this=Identifier(this=id, quoted=False))])),\r\n  expression=Order(\r\n    expressions=[\r\n      Ordered(\r\n        this=Column(\r\n          this=Identifier(this=id, quoted=False)),\r\n        nulls_first=False)]))\r\n```\r\n\r\n```python\r\nArrayAgg(\r\n  this=Order(\r\n    this=Distinct(\r\n      expressions=[\r\n        Column(\r\n          this=Identifier(this=ID, quoted=False))]),\r\n    expressions=[\r\n      Ordered(\r\n        this=Column(\r\n          this=Identifier(this=ID, quoted=False)),\r\n        nulls_first=False)]))\r\n```\r\n\r\n\r\n```diff\r\n-WithinGroup(\r\n-  this=ArrayAgg(\r\n+ArrayAgg(\r\n+  this=Order(\r\n     this=Distinct(\r\n       expressions=[\r\n         Column(\r\n-          this=Identifier(this=id, quoted=False))])),\r\n-  expression=Order(\r\n+          this=Identifier(this=ID, quoted=False))]),\r\n     expressions=[\r\n       Ordered(\r\n         this=Column(\r\n-          this=Identifier(this=id, quoted=False)),\r\n+          this=Identifier(this=ID, quoted=False)),\r\n         nulls_first=False)]))\r\n\r\n```\r\n\r\n-----\r\n\r\nSnowflake has following limitation though;\r\n>\r\nhttps://docs.snowflake.com/en/sql-reference/functions/array_agg#usage-notes\r\n> If you specify DISTINCT and WITHIN GROUP, both must refer to the same\r\ncolumn. For example:\r\n\r\nI've left it out of the scope of this PR to keep it simple.\r\n\r\n---------\r\n\r\nCo-authored-by: Oliver Mannion <125105+tekumara@users.noreply.github.com>","shortMessageHtmlLink":"feat: add ARRAY_AGG() WITHIN GROUP() support (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2211213097\" data-permission-text=\"Title is private\" data-url=\"https://github.com/tekumara/fakesnow/issues/66\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/tekumara/fakesnow/pull/66/hovercard\" href=\"https://github.com/tekumara/fakesnow/pull/66\">tekumara#66</a>)"}},{"before":"b7be898eb4cc19a4d083195a317044ec8ca360c0","after":"f62ab034204bbe029962f60938736bbf53fea73b","ref":"refs/heads/main","pushedAt":"2024-03-29T12:05:50.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"fix: write_pandas quotes columns when inserting dataframe (#65)\n\n`_insert_df` needs to quote the column names when inserting, otherwise\r\nfails for table where column names need quoting\r\n\r\n---------\r\n\r\nCo-authored-by: anentropic <ego@anentropic.com>\r\nCo-authored-by: Oliver Mannion <125105+tekumara@users.noreply.github.com>","shortMessageHtmlLink":"fix: write_pandas quotes columns when inserting dataframe (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2210966489\" data-permission-text=\"Title is private\" data-url=\"https://github.com/tekumara/fakesnow/issues/65\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/tekumara/fakesnow/pull/65/hovercard\" href=\"https://github.com/tekumara/fakesnow/pull/65\">tekumara#65</a>)"}},{"before":null,"after":"a12a967b4819475465ad996059c55df19463f831","ref":"refs/heads/dbt_unittest","pushedAt":"2024-03-27T15:30:26.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"seruman","name":"Selman Kayrancioglu","path":"/seruman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7118751?s=80&v=4"},"commit":{"message":"Merge branch 'main' into dbt_unittest","shortMessageHtmlLink":"Merge branch 'main' into dbt_unittest"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEKRN4-gA","startCursor":null,"endCursor":null}},"title":"Activity · peak/fakesnow"}