When running query in snowflake using flatten function, => is getting converted to = >

[sfc-gh-sakumar]

Describe the bug When running query in snowflake using flatten function, => is getting converted to = > (extra space is getting added). This is leading to syntax error. Could you help in fixing this.

[mtxr]

Can you give an example query so we can write tests to fix this?

[sfc-gh-sakumar]

Thanks for getting back on this. Below is the example code:

CREATE OR REPLACE MATERIALIZED VIEW TESTMV AS SELECT event_date, AS_INTEGER(value :Id) AS test_id FROM TestTable, LATERAL FLATTEN (input => v :TESTPOLICYID);

We can see formatter is converting => to = >