Secure 5.2.1: alterStageDirectoryTable

alterStageDirectoryTable

Last updated: July 13, 2026

Enables, disables, or refreshes the directory table for an existing stage in Snowflake. Directory tables track metadata for files in stages.

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the stage	No
`schemaName`	String	Name of the schema containing the stage	No
`stageName`	String	Name of the stage to alter	Yes
`ifExists`	Boolean	Don't error if the stage doesn't exist	No
`enable`	Boolean	Enable (true) or disable (false) the directory table*	No
`refresh`	Boolean	Refresh the directory table metadata*	No
`subPath`	String	Subdirectory path to refresh (only with `refresh=true`)	No

* Exactly one of enable or refresh must be specified (mutually exclusive).

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

    <!-- Enable directory table -->
    <changeSet id="enable-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                enable="true"/>
    </changeSet>

    <!-- Disable directory table with IF EXISTS -->
    <changeSet id="disable-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                ifExists="true"
                enable="false"/>
    </changeSet>

    <!-- Refresh directory table -->
    <changeSet id="refresh-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                refresh="true"/>
    </changeSet>

    <!-- Refresh specific subpath -->
    <changeSet id="refresh-directory-subpath" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                refresh="true"
                subPath="2024/01/"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "enable-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "enable": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "disable-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "ifExists": true,
              "enable": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "refresh-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "refresh": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "refresh-directory-subpath",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "refresh": true,
              "subPath": "2024/01/"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Enable directory table
  - changeSet:
      id: enable-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            enable: true

  # Disable directory table with IF EXISTS
  - changeSet:
      id: disable-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            ifExists: true
            enable: false

  # Refresh directory table
  - changeSet:
      id: refresh-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            refresh: true

  # Refresh specific subpath
  - changeSet:
      id: refresh-directory-subpath
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            refresh: true
            subPath: 2024/01/

--liquibase formatted sql

--changeset examples:alterstagedirectorytable-1
###SQL example

--changeset examples:alterstagedirectorytable-2
```sql
-- Enable directory table
ALTER STAGE PUBLIC.DATA_STAGE SET DIRECTORY = (ENABLE = TRUE);

--changeset examples:disable-directory-table-with-if-exists
-- Disable directory table with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.DATA_STAGE SET DIRECTORY = (ENABLE = FALSE);

--changeset examples:refresh-directory-table
-- Refresh directory table
ALTER STAGE PUBLIC.DATA_STAGE REFRESH;

--changeset examples:refresh-specific-subpath
-- Refresh specific subpath
ALTER STAGE PUBLIC.DATA_STAGE REFRESH SUBPATH = '2024/01/';
```

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

    <!-- Enable directory table -->
    <changeSet id="enable-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                enable="true"/>
    </changeSet>

    <!-- Disable directory table with IF EXISTS -->
    <changeSet id="disable-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                ifExists="true"
                enable="false"/>
    </changeSet>

    <!-- Refresh directory table -->
    <changeSet id="refresh-directory-table" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                refresh="true"/>
    </changeSet>

    <!-- Refresh specific subpath -->
    <changeSet id="refresh-directory-subpath" author="examples">
        <pro-snowflake:alterStageDirectoryTable
                stageName="DATA_STAGE"
                refresh="true"
                subPath="2024/01/"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "enable-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "enable": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "disable-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "ifExists": true,
              "enable": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "refresh-directory-table",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "refresh": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "refresh-directory-subpath",
        "author": "examples",
        "changes": [
          {
            "alterStageDirectoryTable": {
              "stageName": "DATA_STAGE",
              "refresh": true,
              "subPath": "2024/01/"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Enable directory table
  - changeSet:
      id: enable-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            enable: true

  # Disable directory table with IF EXISTS
  - changeSet:
      id: disable-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            ifExists: true
            enable: false

  # Refresh directory table
  - changeSet:
      id: refresh-directory-table
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            refresh: true

  # Refresh specific subpath
  - changeSet:
      id: refresh-directory-subpath
      author: examples
      changes:
        - alterStageDirectoryTable:
            stageName: DATA_STAGE
            refresh: true
            subPath: 2024/01/

--liquibase formatted sql

--changeset examples:alterstagedirectorytable-1
###SQL example

--changeset examples:alterstagedirectorytable-2
```sql
-- Enable directory table
ALTER STAGE PUBLIC.DATA_STAGE SET DIRECTORY = (ENABLE = TRUE);

--changeset examples:disable-directory-table-with-if-exists
-- Disable directory table with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.DATA_STAGE SET DIRECTORY = (ENABLE = FALSE);

--changeset examples:refresh-directory-table
-- Refresh directory table
ALTER STAGE PUBLIC.DATA_STAGE REFRESH;

--changeset examples:refresh-specific-subpath
-- Refresh specific subpath
ALTER STAGE PUBLIC.DATA_STAGE REFRESH SUBPATH = '2024/01/';
```

alterStageDirectoryTable

Available attributes

XML

JSON

YAML

SQL

More like this