Skip to content

v0.278.0 Invalid UC Schema Permissions warnings that ARE valid & applied in UC #4008

@barryjpodonovan

Description

@barryjpodonovan

Describe the issue

When running databricks bundle plan, databricks bundle deploy or databricks bundle run a new warning has started appearing that says CREATE_MATERIALIZED_VIEW, CREATE_MODEL and CREATE_MODEL_VERSION are not valid grants, even though they are valid as per:

  1. API Reference](https://docs.databricks.com/api/workspace/grants/update) t
  2. Unity Catalog privileges & securable objects documentation
  3. What can actually be assigned in Unity Catalog

Configuration

Extract from databricks.yml

variables:
  schema_permissions:
    description: list of permissions to grant users to a schema
    type: complex
    default:
      # Prerequisite
      # - USE_SCHEMA # Does not give any abilities, but is an additional requirement to perform any action on a schema object
      # Metadata
      - APPLY_TAG # Gives ability to apply tags to an object
      # Read
      # - EXECUTE # Gives ability to use a function or model
      # - READ_VOLUME # Gives ability to use a function or model
      # - SELECT # Gives read access to an object
      # Edit
      - MODIFY # Gives ability to add, delete, and modify data to or from an object
      - REFRESH # Gives ability to refresh a materialized view
      - WRITE_VOLUME # Gives ability to write to a volume
      # Create
      - CREATE_FUNCTION # Gives ability to create a function in a schema
      - CREATE_MATERIALIZED_VIEW # Gives ability to create a materialized view
      - CREATE_MODEL # Gives ability to create a new machine learning model
      - CREATE_MODEL_VERSION # Gives ability to create a model version on an existing machine learning model
      - CREATE_TABLE # Gives ability to create tables
      - CREATE_VOLUME # Gives ability to create volumes
      # Other
      # - ALL_PRIVILEGES # Gives all privileges (including future ones)
      # - EXTERNAL_USE_SCHEMA # Gives ability to access objects from external engines
      - MANAGE # Gives ownership-like ability for the object, such as managing permissions, dropping, or renaming

resources:
  schemas:
    # Integrated Pharmacy Data
    ## Bronze DMA
    bronze_dma_raw:
      name: ${var.schema_prefix}bronze_dma_raw
      catalog_name: ${var.catalog}

targets:
  feature_branch:
    resources:
      schemas:
        # Integrated Pharmacy Data
        ## Bronze DMA
        bronze_dma_raw:
          grants:
            - principal: XXXXX
              privileges: ${var.schema_permissions}

Steps to reproduce the behavior

Please list the steps required to reproduce the issue, for example:

  1. Run databricks bundle plan ... or databricks bundle deploy ... or databricks bundle run ...
  2. See error

Expected Behavior

The expectation is for all permissions as per the API Reference that are applicable to the object as per the Unity Catalog privileges & securable objects documentation to be allowed.

Actual Behavior

Example from my GitHub Workflow log below

Run databricks bundle plan \
databricks bundle plan \
--target feature_branch \
--var="branch_name=dependabot_github_actions_dot-github_actions_deploy_databricks_sandbox_schemas_version_updates-f03e88bfbb" \
--var="sanitised_branch_name=dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb" \
2>&1 | tee run_output_plan.txt >&2
exit ${PIPESTATUS[0]}
shell: /usr/bin/bash --noprofile --norc -e -o pipefail {0}
env:
DATABRICKS_TOKEN: ***
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[7]
in databricks.yml:67:9
create jobs.cogs_job
create jobs.copy_green_schema_job
create jobs.ia_financials_job
create jobs.interim_gold_layer_job
create jobs.ipd_master_job
create jobs.par_intraday_job
create jobs.par_sod_job
create jobs.piiq_v1_job
create schemas.bronze_dma_raw
create schemas.bronze_enriched
create schemas.bronze_flat_file_raw
create schemas.gold
create schemas.piiq_v1
create schemas.reporting_external
create schemas.reporting_internal_analytics
create schemas.reporting_oip_nursing
create schemas.silver
create volumes.flat_files_ecg
create volumes.flat_files_manual
Plan: 19 to add, 0 to change, 0 to delete, 0 unchanged

Run databricks bundle deploy \
databricks bundle deploy \
--target feature_branch \
--var="branch_name=dependabot_github_actions_dot-github_actions_deploy_databricks_sandbox_schemas_version_updates-f03e88bfbb" \
--var="sanitised_branch_name=dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb" \
--auto-approve --force-lock \
2>&1 | tee run_output.txt >&2
exit ${PIPESTATUS[0]}
shell: /usr/bin/bash --noprofile --norc -e -o pipefail {0}
env:
DATABRICKS_TOKEN: ***
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[7]
in databricks.yml:67:9
Uploading bundle files to /Workspace/Users/4fdba120-71c3-4e35-9521-0efe7e88c89c/.bundle/ptr-databricks/feature_branch/dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb/files...
Deploying resources...
Updating deployment state...
Deployment complete!

Run databricks bundle run ipd_master_job \
databricks bundle run ipd_master_job \
--target feature_branch \
--var="branch_name=dependabot_github_actions_dot-github_actions_deploy_databricks_sandbox_schemas_version_updates-f03e88bfbb" \
--var="sanitised_branch_name=dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb" \
--restart \
2> >(tee run_output.txt >&2)
exit ${PIPESTATUS[0]}
shell: /usr/bin/bash --noprofile --norc -e -o pipefail {0}
env:
DATABRICKS_TOKEN: ***
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MATERIALIZED_VIEW" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[5]
in databricks.yml:65:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[6]
in databricks.yml:66:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.piiq_v1.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_dma_raw.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.gold.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_oip_nursing.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_external.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_enriched.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.silver.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.reporting_internal_analytics.grants[0].privileges[7]
in databricks.yml:67:9
Warning: invalid value "CREATE_MODEL_VERSION" for enum field. Valid values are [ALL_PRIVILEGES APPLY_TAG CREATE_FUNCTION CREATE_TABLE CREATE_VOLUME MANAGE USE_SCHEMA EXECUTE MODIFY REFRESH SELECT READ_VOLUME WRITE_VOLUME]
at resources.schemas.bronze_flat_file_raw.grants[0].privileges[7]
in databricks.yml:67:9
Run URL: https://adb-2652773376136008.8.azuredatabricks.net/?o=2652773376136008#job/768419134914721/run/278081733251684
2025-11-13 16:39:57 "zz dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb | IPD Master Job" RUNNING
2025-11-13 16:50:26 "zz dependabot_github_actions_dot_github_actions_deploy_databricks_sandbox_schemas_version_updates_f03e88bfbb | IPD Master Job" TERMINATED SUCCESS

Example of these permissions being applied correctly by the bundle configuration desspite of the warnings above.

Image

OS and CLI version

  • CLI: v0.278.0
  • OS: Linux

Is this a regression?

Yes, this issue appeared in v0.267.0

Metadata

Metadata

Assignees

Labels

BugSomething isn't workingDABsDABs related issues

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions