[Wranglers] SQL pipe syntax is coming to Snowflake soon

Ali, Saqib docbook.xml at gmail.com
Mon May 12 13:01:32 UTC 2025


I am curious why Snowflake chose "->>" as the Pipe Operator when
Google Bigquery has already adopted "|>" as the Pipe Operator for SQL.
¯\_(ツ)_/¯


On Sat, May 10, 2025 at 10:21 PM Ali, Saqib <docbook.xml at gmail.com> wrote:
>
> Following in Google BigQuery's footsteps, Snowflake will be adding support for the SQL Pipe Operator soon. The new pipe operator (->>) will enable chaining of  SQL statements. In the chain of SQL statements, the results of one statement can serve as the input to another statement. The pipe operator can simplify the execution of dependent SQL statements and improve the readability and flexibility of complex SQL operations.
>


More information about the Wranglers mailing list