Snowflake createView

Last updated: April 29, 2026

Creates a Snowflake view with optional row access policy for row-level security. Views are virtual tables that present query results as a table. The secure option hides the view definition from unauthorized users.

Note: Automatic rollback drops the view.

Known limitations: Snowflake snapshots created with Liquibase Secure 5.1 are incompatible with earlier versions due to enhanced object type detection for TABLES and VIEWS. Regenerate all snapshots with 5.1 after upgrading to avoid false differences in diff and diff-changelog operations.

The Liquibase createView changetype is not compatible for Snowflake users in Liquibase Secure 5.1 using YAML or JSON changetype formats. This does not affect XML change types at all. If you’re connecting to a Snowflake database, Liquibase automatically detects that you are using the Snowflake createView change type and breaks backwards compatibility with the Liquibase createView change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) where the view will be created	No
`schemaName`	String	Name of the schema where the view will be created	No
`viewName`	String	Name of the view to create	Yes
`replaceIfExists`	Boolean	If true, replaces the view if it already exists using `OR REPLACE`	No*
`ifNotExists`	Boolean	If true, only creates the view if it doesn't exist using `IF NOT EXISTS`	No*
`secure`	Boolean	If true, creates a secure view that restricts access to the view definition	No
`comment`	String	Comment describing the view	No
`selectQuery`	Nested	The SELECT statement that defines the view	Yes
`rowAccessPolicy`	Nested	Row-level security control for the view	No
`rowAccessPolicyColumns`	Nested	Container for column mappings (within rowAccessPolicy)	No

*Only one of replaceIfExists or ifNotExists can be true (mutually exclusive).

Nested elements

selectQuery (required) - The SELECT statement that defines the view. Contains the SQL query as text content.

rowAccessPolicy - Row-level security control for the view:

Attribute	Type	Description	Required
`policyName`	String	Name of the row access policy to apply	Yes

rowAccessPolicyColumns (nested within rowAccessPolicy) - Container for column mappings. View columns are mapped positionally to policy arguments (names don't need to match).

Element	Attribute	Description	Required
`column`	`columnName`	View column to map to policy	Yes

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Basic view -->
    <changeSet id="create-basic-view" author="examples">
        <pro-snowflake:createView viewName="ACTIVE_CUSTOMERS">
            <pro-snowflake:selectQuery>SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

    <!-- Secure view with OR REPLACE and comment -->
    <changeSet id="create-secure-view" author="examples">
        <pro-snowflake:createView
                viewName="SALES_SUMMARY"
                replaceIfExists="true"
                secure="true"
                comment="Aggregated sales data by region">
            <pro-snowflake:selectQuery>SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

    <!-- View with row access policy -->
    <changeSet id="create-view-with-rap" author="examples">
        <pro-snowflake:createView
                viewName="REGIONAL_DATA"
                schemaName="ANALYTICS"
                comment="Region-restricted data view">
            <pro-snowflake:selectQuery>SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA</pro-snowflake:selectQuery>
            <pro-snowflake:rowAccessPolicy policyName="REGION_POLICY">
                <pro-snowflake:rowAccessPolicyColumns>
                    <pro-snowflake:column columnName="SALES_REGION"/>
                    <pro-snowflake:column columnName="SALES_COUNTRY"/>
                </pro-snowflake:rowAccessPolicyColumns>
            </pro-snowflake:rowAccessPolicy>
        </pro-snowflake:createView>
    </changeSet>

    <!-- View with IF NOT EXISTS -->
    <changeSet id="create-view-if-not-exists" author="examples">
        <pro-snowflake:createView
                viewName="QUARTERLY_REPORT"
                ifNotExists="true">
            <pro-snowflake:selectQuery>SELECT QUARTER, SUM(SALES) FROM TRANSACTIONS GROUP BY QUARTER</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-basic-view",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "ACTIVE_CUSTOMERS",
              "selectQuery": "SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-secure-view",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "SALES_SUMMARY",
              "replaceIfExists": true,
              "secure": true,
              "comment": "Aggregated sales data by region",
              "selectQuery": "SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-view-with-rap",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "REGIONAL_DATA",
              "schemaName": "ANALYTICS",
              "comment": "Region-restricted data view",
              "selectQuery": "SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA",
              "rowAccessPolicy": {
                "policyName": "REGION_POLICY",
                "rowAccessPolicyColumns": [
                  {"column": {"columnName": "SALES_REGION"}},
                  {"column": {"columnName": "SALES_COUNTRY"}}
                ]
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic view
  - changeSet:
      id: create-basic-view
      author: examples
      changes:
        - createView:
            viewName: ACTIVE_CUSTOMERS
            selectQuery: SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'

  # Secure view with OR REPLACE and comment
  - changeSet:
      id: create-secure-view
      author: examples
      changes:
        - createView:
            viewName: SALES_SUMMARY
            replaceIfExists: true
            secure: true
            comment: Aggregated sales data by region
            selectQuery: SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION

  # View with row access policy
  - changeSet:
      id: create-view-with-rap
      author: examples
      changes:
        - createView:
            viewName: REGIONAL_DATA
            schemaName: ANALYTICS
            comment: Region-restricted data view
            selectQuery: SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA
            rowAccessPolicy:
              policyName: REGION_POLICY
              rowAccessPolicyColumns:
                - column:
                    columnName: SALES_REGION
                - column:
                    columnName: SALES_COUNTRY

--liquibase formatted sql

--changeset examples:basic-view
-- Basic view
CREATE VIEW MYDB.PUBLIC.ACTIVE_CUSTOMERS
AS SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE';

--changeset examples:secure-view-with-or-replace-and-comment
-- Secure view with OR REPLACE and comment
CREATE OR REPLACE SECURE VIEW MYDB.PUBLIC.SALES_SUMMARY
  COMMENT = 'Aggregated sales data by region'
AS SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION;

--changeset examples:view-with-row-access-policy
-- View with row access policy
CREATE VIEW MYDB.ANALYTICS.REGIONAL_DATA
  COMMENT = 'Region-restricted data view'
  WITH ROW ACCESS POLICY REGION_POLICY ON (SALES_REGION, SALES_COUNTRY)
AS SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA;

--changeset examples:view-with-if-not-exists
-- View with IF NOT EXISTS
CREATE VIEW IF NOT EXISTS MYDB.PUBLIC.QUARTERLY_REPORT
AS SELECT QUARTER, SUM(SALES) FROM TRANSACTIONS GROUP BY QUARTER;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Basic view -->
    <changeSet id="create-basic-view" author="examples">
        <pro-snowflake:createView viewName="ACTIVE_CUSTOMERS">
            <pro-snowflake:selectQuery>SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

    <!-- Secure view with OR REPLACE and comment -->
    <changeSet id="create-secure-view" author="examples">
        <pro-snowflake:createView
                viewName="SALES_SUMMARY"
                replaceIfExists="true"
                secure="true"
                comment="Aggregated sales data by region">
            <pro-snowflake:selectQuery>SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

    <!-- View with row access policy -->
    <changeSet id="create-view-with-rap" author="examples">
        <pro-snowflake:createView
                viewName="REGIONAL_DATA"
                schemaName="ANALYTICS"
                comment="Region-restricted data view">
            <pro-snowflake:selectQuery>SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA</pro-snowflake:selectQuery>
            <pro-snowflake:rowAccessPolicy policyName="REGION_POLICY">
                <pro-snowflake:rowAccessPolicyColumns>
                    <pro-snowflake:column columnName="SALES_REGION"/>
                    <pro-snowflake:column columnName="SALES_COUNTRY"/>
                </pro-snowflake:rowAccessPolicyColumns>
            </pro-snowflake:rowAccessPolicy>
        </pro-snowflake:createView>
    </changeSet>

    <!-- View with IF NOT EXISTS -->
    <changeSet id="create-view-if-not-exists" author="examples">
        <pro-snowflake:createView
                viewName="QUARTERLY_REPORT"
                ifNotExists="true">
            <pro-snowflake:selectQuery>SELECT QUARTER, SUM(SALES) FROM TRANSACTIONS GROUP BY QUARTER</pro-snowflake:selectQuery>
        </pro-snowflake:createView>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-basic-view",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "ACTIVE_CUSTOMERS",
              "selectQuery": "SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-secure-view",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "SALES_SUMMARY",
              "replaceIfExists": true,
              "secure": true,
              "comment": "Aggregated sales data by region",
              "selectQuery": "SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-view-with-rap",
        "author": "examples",
        "changes": [
          {
            "createView": {
              "viewName": "REGIONAL_DATA",
              "schemaName": "ANALYTICS",
              "comment": "Region-restricted data view",
              "selectQuery": "SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA",
              "rowAccessPolicy": {
                "policyName": "REGION_POLICY",
                "rowAccessPolicyColumns": [
                  {"column": {"columnName": "SALES_REGION"}},
                  {"column": {"columnName": "SALES_COUNTRY"}}
                ]
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic view
  - changeSet:
      id: create-basic-view
      author: examples
      changes:
        - createView:
            viewName: ACTIVE_CUSTOMERS
            selectQuery: SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE'

  # Secure view with OR REPLACE and comment
  - changeSet:
      id: create-secure-view
      author: examples
      changes:
        - createView:
            viewName: SALES_SUMMARY
            replaceIfExists: true
            secure: true
            comment: Aggregated sales data by region
            selectQuery: SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION

  # View with row access policy
  - changeSet:
      id: create-view-with-rap
      author: examples
      changes:
        - createView:
            viewName: REGIONAL_DATA
            schemaName: ANALYTICS
            comment: Region-restricted data view
            selectQuery: SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA
            rowAccessPolicy:
              policyName: REGION_POLICY
              rowAccessPolicyColumns:
                - column:
                    columnName: SALES_REGION
                - column:
                    columnName: SALES_COUNTRY

--liquibase formatted sql

--changeset examples:basic-view
-- Basic view
CREATE VIEW MYDB.PUBLIC.ACTIVE_CUSTOMERS
AS SELECT * FROM CUSTOMERS WHERE STATUS = 'ACTIVE';

--changeset examples:secure-view-with-or-replace-and-comment
-- Secure view with OR REPLACE and comment
CREATE OR REPLACE SECURE VIEW MYDB.PUBLIC.SALES_SUMMARY
  COMMENT = 'Aggregated sales data by region'
AS SELECT REGION, SUM(AMOUNT) AS TOTAL FROM SALES GROUP BY REGION;

--changeset examples:view-with-row-access-policy
-- View with row access policy
CREATE VIEW MYDB.ANALYTICS.REGIONAL_DATA
  COMMENT = 'Region-restricted data view'
  WITH ROW ACCESS POLICY REGION_POLICY ON (SALES_REGION, SALES_COUNTRY)
AS SELECT SALES_REGION, SALES_COUNTRY, REVENUE FROM SALES_DATA;

--changeset examples:view-with-if-not-exists
-- View with IF NOT EXISTS
CREATE VIEW IF NOT EXISTS MYDB.PUBLIC.QUARTERLY_REPORT
AS SELECT QUARTER, SUM(SALES) FROM TRANSACTIONS GROUP BY QUARTER;