Skip to content

Gap in CREATE ROW ACCESS POLICY Syntax Parsing #6537

@LoganPrice344

Description

@LoganPrice344

Search before asking

  • I searched the issues and found no similar issues.

What Happened

SQLFluff throws a parsing error when it encounters a valid Snowflake SQL statement.

Expected Behaviour

This should correctly parse.

Observed Behaviour

The following error is printed:

== [test.sql] FAIL
L:   1 | P:   1 |  PRS | Line 1, Position 1: Found unparsable section: 'CREATE
                       | ROW ACCESS POLICY IF NOT EXISTS m...'

How to reproduce

CREATE ROW ACCESS POLICY IF NOT EXISTS my_access_policy AS (TEXT VARCHAR) RETURNS BOOLEAN -> FALSE;

Dialect

Snowflake

Version

V3.3.0

Configuration

N/A

Are you willing to work on and submit a PR to address the issue?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions