Wranglers List Archive Search
You can get more information about this list.
This index contains 127 documents and
2,243 keywords.
Last modified: 2025-02-12
- 1. zen (score: 26)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 29 Dec 2024 18:33:18 +0000
- Azure SQL now supports JSON DataType. It is a binary data type that is way more performant than using a non-binary datatype to store JSON. https://www.youtube.com/watch?v=WigP5PLQXhY More info: https
- /pipermail/wranglers/2024/000083.html (3,912 bytes)
- 2. sql online compiler (score: 23)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- A running list of Online SQL Compilers. Please feel free to suggest more. https://www.programiz.com/sql/online-compiler/ https://sqliteonline.com/ https://www.mycompiler.io/online-sql-editor https://
- /pipermail/wranglers/2025/000099.html (3,966 bytes)
- 3. Calculating Geometric Mean using SQL (score: 22)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Recently I had to calculate the Geometric Mean of columns in a table using SQL. To calculate the geometric mean, you have to first multiply all values and then take the nth root of that number, where
- /pipermail/wranglers/2024/000025.html (3,502 bytes)
- 4. SQL User Defined Aggregate Functions are now available in Google BigQuery! (score: 20)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 28 Jul 2024 22:43:58 +0000
- DDL syntax for SQL based User Defined Aggregate Functions (UDAF) here: https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#sql-create-udaf-function Saqib -- next pa
- /pipermail/wranglers/2024/000055.html (4,487 bytes)
- 5. Now you can execute an Azure Function in response to a data change event Azure SQL DB Table (score: 20)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Ever wanted to trigger an Azure Function in response to a data change event that happened on a Azure SQL Database table? Well now you can: https://devblogs.microsoft.com/azure-sql/azure-sql-trigger-b
- /pipermail/wranglers/2024/000021.html (3,842 bytes)
- 6. Stratified sampling using SQL given an absolute sample size (score: 19)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 05 Feb 2025 05:07:51 +0000
- I have the following population: a b b c c c c I am looking for a SQL statement to generate a stratified sample of arbitrary size. For example, I would like a sample size of 4. I would expect the out
- /pipermail/wranglers/2025/000116.html (3,564 bytes)
- 7. e (score: 19)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Amazon EC2 now supports automated recovery of Microsoft SQL Server with VSS: https://aws.amazon.com/about-aws/whats-new/2025/02/amazon-ec2-automated-recovery-microsoft-sql-server-vss/ -- next part --
- /pipermail/wranglers/2025/000115.html (3,482 bytes)
- 8. SQL User Defined Aggregate Functions are now available in Google BigQuery! (score: 19)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 28 Jul 2024 22:43:58 +0000
- SQL User Defined Aggregate Functions (UDAF) are now available in Google BigQuery. Sample SQL available on GitHub: https://qosf.com/UDAF-in-google-bigquery.html Saqib -- next part -- An HTML attachmen
- /pipermail/wranglers/2024/000052.html (3,401 bytes)
- 9. Accurate estimation of the costs of each SQL statement in Snowflake (score: 19)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Estimating the cost of each SQL query in Snowflake is a challenge. I have been struggling with this a lot lately. A tiny query could be running as part of a Large Warehouse that is already up and run
- /pipermail/wranglers/2024/000017.html (4,143 bytes)
- 10. Any ETA on when Oracle Live SQL will be upgraded to Oracle Database 23ai, Release Update 23.7? (score: 18)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Thu, 06 Feb 2025 02:49:24 +0000
- Anyone know when Oracle Live SQL will be upgraded to Oracle Database 23ai, Release Update 23.7? -- next part -- An HTML attachment was scrubbed... URL: <https://analyticsengineering.net/pipermail/wra
- /pipermail/wranglers/2025/000118.html (3,369 bytes)
- 11. DuckDB now support Property Graph and SQL/PGQ (score: 18)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Following in the footsteps of Oracle 23ai and Google Spanner, DuckDB now supports Property Graphs and SQL/PGQ: https://duckpgq.org/ -- next part -- An HTML attachment was scrubbed... URL: <https://an
- /pipermail/wranglers/2025/000097.html (3,128 bytes)
- 12. tions (score: 18)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 29 Dec 2024 18:33:18 +0000
- A nice overview of GROUP BY ROLLUP SQL syntax https://help.sap.com/docs/hana-cloud-data-lake/administration-guide-for-data-lake-relational-engine/rollup-and-subtotal-rows-in-data-lake-relational-engi
- /pipermail/wranglers/2024/000091.html (3,357 bytes)
- 13. DuckDB now support Property Graph and SQL/PGQ (score: 17)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Quick overview by Daniël ten Wolde on how DuckPGQ brings property graphs to DuckDB https://www.youtube.com/watch?v=QDdTbhSR2Vo <https://qosf.com> -- next part -- An HTML attachment was scrubbed... UR
- /pipermail/wranglers/2025/000117.html (3,583 bytes)
- 14. SQL User Defined Aggregate Functions are now available in Google BigQuery! (score: 17)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 28 Jul 2024 22:43:58 +0000
- here is the official documentation: https://cloud.google.com/bigquery/docs/user-defined-aggregates Saqib -- next part -- An HTML attachment was scrubbed... URL: <https://analyticsengineering.net/pipe
- /pipermail/wranglers/2024/000053.html (3,868 bytes)
- 15. SQL User Defined Aggregate Functions are now available in Google BigQuery! (score: 17)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 28 Jul 2024 22:43:58 +0000
- Javascript based UDAF are now also available in BigQuery: https://cloud.google.com/bigquery/docs/user-defined-aggregates#create-javascript-udaf Saqib -- next part -- An HTML attachment was scrubbed..
- /pipermail/wranglers/2024/000066.html (5,044 bytes)
- 16. Databases that added support for Translytical workloads in 2024 (score: 5)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sat, 11 Jan 2025 01:55:48 +0000
- Here are three databases that added support for translytical workloads in 2024: 1. SQL DB in Microsoft Fabric. All data is replicated in near-real time to open-source delta parquet format in OneLake.
- /pipermail/wranglers/2025/000094.html (3,714 bytes)
- 17. Help Oracle Query optimizer by avoiding Implicit Type Conversion in JSON Access (score: 3)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 12 Feb 2025 02:26:16 +0000
- An excellent blogpost by Philipp Salvisberg on why implicit type conversion should be avoided in Oracle especially when working with JSON data: https://www.salvis.com/blog/2025/01/28/avoid-implicit-t
- /pipermail/wranglers/2025/000126.html (3,762 bytes)
- 18. Graph Databases after 15 Years – Where Are They Headed? (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Mon, 10 Feb 2025 22:04:12 +0000
- Brief history of development of the SQL/PGQ and GQL Standards by Gábor Szárnyas of DuckDB https://www.youtube.com/watch?v=X_RFo616M_U -- next part -- An HTML attachment was scrubbed... URL: <https://
- /pipermail/wranglers/2025/000123.html (3,402 bytes)
- 19. Windows frames with array_agg Window function in Snowflake (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Much awaited feature is now available in Snowflake. array_agg() window function in Snowflake now supports Window frames: https://docs.snowflake.com/en/sql-reference/functions/array_agg#syntax -- next
- /pipermail/wranglers/2025/000100.html (3,228 bytes)
- 20. e (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Both Snowflake and Redshift assign unique identifiers to SQL queries that can be used to track and monitor the performance of queries over time. Redshift calls it generic_query_hash whereas Snowflake
- /pipermail/wranglers/2025/000105.html (4,268 bytes)
- 21. h (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- I wanted to add some exception handling to the store procedure. Here is what I came up with so that we get meaningful error messages in case there are any errors. CREATE OR REPLACE PROCEDURE SP__INSE
- /pipermail/wranglers/2025/000113.html (5,269 bytes)
- 22. e (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- Looks like for table names we have to use the IDENTIFIER() keyword as follows: CREATE OR REPLACE PROCEDURE SP__INSERT_TO_CUSTOMERS(table_name varchar) RETURNS string LANGUAGE SQL AS BEGIN insert into
- /pipermail/wranglers/2025/000109.html (4,293 bytes)
- 23. h (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Tue, 04 Feb 2025 17:52:47 +0000
- I am trying to define a Stored Procedure in Snowflake as follows. But it is erroring out on the variable binding for :table_name. Error: Syntax error: unexpected 'into'. How do I achieve this? CREATE
- /pipermail/wranglers/2025/000108.html (3,501 bytes)
- 24. Databases that added support for Translytical workloads in 2024 (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 12 Jan 2025 13:55:36 +0000
- Forgot to mention that Snowflake also has Hybrid tables that support OLTP workloads with ability to define and enforce Primary Keys and Unique Key constraints. In general, I think, analytical databas
- /pipermail/wranglers/2025/000095.html (4,900 bytes)
- 25. ver (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Sun, 29 Dec 2024 18:33:18 +0000
- Snowflake now supports Variable Binding in Queries using TO_QUERY(): https://docs.snowflake.com/en/user-guide/querying-construct-at-runtime https://docs.snowflake.com/en/sql-reference/functions/to_qu
- /pipermail/wranglers/2024/000084.html (3,501 bytes)
- 26. cts (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 21 Aug 2024 18:51:12 +0000
- An excellent blogpost by Sepideh Jahangiri and Philip Laserstein on One Big Table vs. Dimensional Modeling for Information Marts: https://medium.com/dbsql-sme-engineering/one-big-table-vs-dimensional
- /pipermail/wranglers/2024/000060.html (3,389 bytes)
- 27. Flattening JSON with a recursive query in BigQuery (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- An interesting post by Ross Lovelace on how to flatten a nested JSON using a SQL Recursive CTE: https://medium.com/@rossalovelace/flattening-json-with-a-recursive-query-in-bigquery-a8cf76eedca8 -- ne
- /pipermail/wranglers/2024/000015.html (3,422 bytes)
- 28. Syntactic Sugar: Snowflake Now Supports Trailing Comma for the SELECT Clause (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- A brief post by Qinyi Ding on how Snowflake now supports trailing comma for the SELECT clause: https://medium.com/snowflake/snowflake-supports-trailing-comma-for-the-select-clause-407eb46271ba Basica
- /pipermail/wranglers/2024/000016.html (3,586 bytes)
- 29. New Table Function RANGE_SESSIONIZE in Google BigQuery (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Google published a blogpost about RANGE_SESSIONIZE and GAP_FILL Table Functions aka Table-Valued Function (TVF) here: https://cloud.google.com/blog/products/data-analytics/bigquery-sql-gets-time-wind
- /pipermail/wranglers/2024/000023.html (4,293 bytes)
- 30. NULL-safe GREATEST and LEAST now available in Snowflake (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Snowflake now supports GREATEST_IGNORE_NULLS and LEAST_IGNORE_NULLS. In the past if you used LEAST or GREATEST on a list of expressions that contained NULL these functions always returned NULL, which
- /pipermail/wranglers/2024/000029.html (6,289 bytes)
- 31. NULL-safe GREATEST and LEAST now available in Snowflake (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Snowflake now supports GREATEST_IGNORE_NULLS and LEAST_IGNORE_NULLS. In the past if you used LEAST or GREATEST on a list of expressions that contained NULL these functions always returned NULL, which
- /pipermail/wranglers/2024/000030.html (3,762 bytes)
- 32. Data Quality checks in Snowflake using Data Metric Functions (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Wed, 15 May 2024 03:53:21 +0000
- Data Metrics Functions (DMF) are here! DMFs allow you to automate data quality validation and monitoring in Snowflake. Snowflake has several Pre-defined DMFs like NULL_COUNT, DUPLICATE_COUNT, UNIQUE_
- /pipermail/wranglers/2024/000031.html (3,654 bytes)
- 33. Snowflake now has support for ASOF Joins (score: 2)
- Author: Ali, Saqib <docbook.xml at gmail.com>
- Date: Fri, 26 Apr 2024 01:37:27 +0000
- Snowflake now has support for ASOF JOINs. Checkout: https://docs.snowflake.com/en/sql-reference/constructs/asof-join Sincerely, Saqib https://qosf.com -- next part -- An HTML attachment was scrubbed.
- /pipermail/wranglers/2024/000000.html (2,848 bytes)
v2.0.21
-->
accounts@mailmanlists.net