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


Query: [How to search]

Display: Description: Sort:

Results:

References: [ sql: 33 ]

Total 33 documents matching your query.

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