Pipe Syntax is not compatible with Dataform [396432800]

Assigned

Bug

Status Update

No update yet.

Description

ax...@gmail.com

created issue #1

Feb 13, 2025 06:20PM

Problem you have encountered: Pipe Syntax is not available within block statements making it incompatible with Dataform. To detail a bit more, pipe syntax works inside a BEGIN...END block but can not interpret the first FROM operator. Which make possible to have a query inside continued by a pipe syntax. But it makes impossible to have 100% pipe syntax query starting with the FROM operator (examples below)

What you expected to happen: I expect the pipe syntax to be available and working even inside a block of statement

Steps to reproduce:

-- Of course is working
BEGIN
SELECT 1 AS my_column;
END;


-- Is not working (Syntax error: Unexpected FROM at [4:1])
BEGIN 
FROM (SELECT 1 AS my_column);
END;


-- Is working
BEGIN 
-- Standard SQL
SELECT 1 AS my_column
-- Pipe Syntax following
|> WHERE my_column = 1
|> LIMIT 1;
END;

Other information (workarounds you have tried, documentation consulted, etc): N/A

Comments

pu...@google.com <pu...@google.com> Feb 14, 2025 06:34AM

Assigned to si...@google.com.

si...@google.com <si...@google.com> #2Feb 14, 2025 10:24AM

Hello,

This issue report has been forwarded to the Cloud BigQuery Product team so that they may investigate it, but there is no ETA for a resolution today. Future updates regarding this issue will be provided here.

ax...@gmail.com <ax...@gmail.com> #3Feb 14, 2025 11:06AM

Hi,

To troubleshoot the issue further, I have created a private ticket to provide some information about the issue (for which you should have received a notification). Please provide requested information there. Don't put any personal information, including project identifiers in this public ticket.

si...@google.com <si...@google.com> #4Feb 17, 2025 06:31AM

Reassigned to gc...@google.com.

Hello,

Thank you for reaching out to us with your request.

We have duly noted your feedback and will thoroughly validate it. While we cannot provide an estimated time of implementation or guarantee the fulfillment of the issue, please be assured that your input is highly valued. Your feedback enables us to enhance our products and services.

We appreciate your continued trust and support in improving our Google Cloud Platform products. In case you want to report a new issue, Please do not hesitate to create a new issue on the Issue Tracker providing a detailed description of your issue.

Once again, we sincerely appreciate your valuable feedback; Thank you for your understanding and collaboration.

Issue 396432800

Description

Issue summary

Comments

pu...@google.com <pu...@google.com> Feb 14, 2025 06:34AM

si...@google.com <si...@google.com> #2Feb 14, 2025 10:24AM

ax...@gmail.com <ax...@gmail.com> #3Feb 14, 2025 11:06AM

si...@google.com <si...@google.com> #4Feb 17, 2025 06:31AM

Add comment

Issue metadata