Skip to content

Snowflake: Missing parameter USE_PRIVATELINK_ENDPOINT in STORAGE INTEGRATION #6820

@moreaupascal56

Description

@moreaupascal56

Search before asking

  • I searched the issues and found no similar issues.

What Happened

Sqlfluff returns:

L:  12 | P:   5 |  PRS | Line 12, Position 5: Found unparsable section:
                       | 'USE_PRIVATELINK_ENDPOINT = TRUE\n;'

when running on

CREATE STORAGE INTEGRATION IF NOT EXISTS example
    TYPE = EXTERNAL_STAGE
    STORAGE_PROVIDER = S3
    ENABLED = TRUE
    STORAGE_AWS_ROLE_ARN = 'arn::example'
    STORAGE_ALLOWED_LOCATIONS = (
        's3://example/',
        's3://example2/',
        's3://example3/'
    )
    USE_PRIVATELINK_ENDPOINT = TRUE
;

Expected Behaviour

sqlfluff works

Observed Behaviour

see above

How to reproduce

see above

Dialect

snowflake

Version

3.4.0

Configuration

no config

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 workingsnowflakeIssues related to the Snowflake dialect

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions