createDatabaseFromShare

Last updated: January 27, 2026

Creates a database from a share provided by another Snowflake account. This is a consumer-side operation that creates a read-only database pointing to shared data.

Note: Automatic rollback drops the database.

Known limitation: This change type does not support database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Available attributes

Attribute	Type	Description	Required
`databaseName`	String	Name of the database to create	Yes
`providerAccount`	String	Account identifier of the data provider (e.g., `xy12345` or `orgname.accountname`)	Yes
`shareName`	String	Name of the share from the provider account	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">

    <!-- Create database from share with legacy locator -->
    <changeSet id="create-database-from-share-basic" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="SHARED_SALES_DATA"
                providerAccount="xy12345"
                shareName="public_sales_share"/>
    </changeSet>

    <!-- Create database from share with organization format -->
    <changeSet id="create-database-from-share-org" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="PARTNER_DATA"
                providerAccount="myorg.account1"
                shareName="analytics_share"/>
    </changeSet>

    <!-- Create database from share with cloud region -->
    <changeSet id="create-database-from-share-region" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="EXTERNAL_DATA"
                providerAccount="xy12345.us-east-1.aws"
                shareName="market_data"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-database-from-share-basic",
        "author": "examples",
        "changes": [
          {
            "createDatabaseFromShare": {
              "databaseName": "SHARED_SALES_DATA",
              "providerAccount": "xy12345",
              "shareName": "public_sales_share"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-database-from-share-org",
        "author": "examples",
        "changes": [
          {
            "createDatabaseFromShare": {
              "databaseName": "PARTNER_DATA",
              "providerAccount": "myorg.account1",
              "shareName": "analytics_share"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Create database from share with legacy locator
  - changeSet:
      id: create-database-from-share-basic
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: SHARED_SALES_DATA
            providerAccount: xy12345
            shareName: public_sales_share

  # Create database from share with organization format
  - changeSet:
      id: create-database-from-share-org
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: PARTNER_DATA
            providerAccount: myorg.account1
            shareName: analytics_share

  # Create database from share with cloud region
  - changeSet:
      id: create-database-from-share-region
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: EXTERNAL_DATA
            providerAccount: xy12345.us-east-1.aws
            shareName: market_data

--liquibase formatted sql

--changeset examples:create-database-from-share-with-legacy-locator
-- Create database from share with legacy locator
CREATE DATABASE SHARED_SALES_DATA FROM SHARE xy12345.public_sales_share;

--changeset examples:create-database-from-share-with-organization-format
-- Create database from share with organization format
CREATE DATABASE PARTNER_DATA FROM SHARE myorg.account1.analytics_share;

--changeset examples:create-database-from-share-with-cloud-region
-- Create database from share with cloud region
CREATE DATABASE EXTERNAL_DATA FROM SHARE xy12345.us-east-1.aws.market_data;

<?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">

    <!-- Create database from share with legacy locator -->
    <changeSet id="create-database-from-share-basic" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="SHARED_SALES_DATA"
                providerAccount="xy12345"
                shareName="public_sales_share"/>
    </changeSet>

    <!-- Create database from share with organization format -->
    <changeSet id="create-database-from-share-org" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="PARTNER_DATA"
                providerAccount="myorg.account1"
                shareName="analytics_share"/>
    </changeSet>

    <!-- Create database from share with cloud region -->
    <changeSet id="create-database-from-share-region" author="examples">
        <pro-snowflake:createDatabaseFromShare
                databaseName="EXTERNAL_DATA"
                providerAccount="xy12345.us-east-1.aws"
                shareName="market_data"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-database-from-share-basic",
        "author": "examples",
        "changes": [
          {
            "createDatabaseFromShare": {
              "databaseName": "SHARED_SALES_DATA",
              "providerAccount": "xy12345",
              "shareName": "public_sales_share"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-database-from-share-org",
        "author": "examples",
        "changes": [
          {
            "createDatabaseFromShare": {
              "databaseName": "PARTNER_DATA",
              "providerAccount": "myorg.account1",
              "shareName": "analytics_share"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Create database from share with legacy locator
  - changeSet:
      id: create-database-from-share-basic
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: SHARED_SALES_DATA
            providerAccount: xy12345
            shareName: public_sales_share

  # Create database from share with organization format
  - changeSet:
      id: create-database-from-share-org
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: PARTNER_DATA
            providerAccount: myorg.account1
            shareName: analytics_share

  # Create database from share with cloud region
  - changeSet:
      id: create-database-from-share-region
      author: examples
      changes:
        - createDatabaseFromShare:
            databaseName: EXTERNAL_DATA
            providerAccount: xy12345.us-east-1.aws
            shareName: market_data

--liquibase formatted sql

--changeset examples:create-database-from-share-with-legacy-locator
-- Create database from share with legacy locator
CREATE DATABASE SHARED_SALES_DATA FROM SHARE xy12345.public_sales_share;

--changeset examples:create-database-from-share-with-organization-format
-- Create database from share with organization format
CREATE DATABASE PARTNER_DATA FROM SHARE myorg.account1.analytics_share;

--changeset examples:create-database-from-share-with-cloud-region
-- Create database from share with cloud region
CREATE DATABASE EXTERNAL_DATA FROM SHARE xy12345.us-east-1.aws.market_data;

createDatabaseFromShare

Available attributes

XML

JSON

YAML

SQL

More like this