title: DELTA TABLES - The specified properties do not match the existing properties
body: <p>I'm using a set of user properties on DataBricks Delta Tables for metadata management. The problem is when I need to change one of those properties I'm getting the <strong>'FAILED Error: The specified properties do not match the existing properties at /mnt/silver/...'</strong> error message.</p>
  <p>Databricks documentation only states that an Exception will be raised and I didn't find any argument to force it to accept the new values.</p>
  <p>Is it possible to just update table Properties?</p>
  <p><a href="https://i.stack.imgur.com/1X7aJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1X7aJ.png" alt="enter image description here" /></a></p>
  <p>Any Suggestions?</p>
  <p>Sample Code:</p>
  <pre><code>query = f'''
  CREATE  TABLE if not exists  {tableMetadataDBName}.{tableMetadataTableName}
  (
  ... my columns ...
  -- COMMON COLUMNS
  ,Hash  string
  ,sourceFilename STRING
  ,HashWithFileDate  string
  ,Surrogate_Key  STRING
  ,SessionId  STRING
  ,SessionRunDate TIMESTAMP
  ,Year INT GENERATED ALWAYS AS ( YEAR(fileDate))
  ,Month INT  GENERATED ALWAYS AS ( MONTH(fileDate))
  ,fileDate   DATE
  )
  USING DELTA 
  COMMENT '{tableDocumentationURL}'
  LOCATION &quot;{savePath}/parquet&quot;
  OPTIONS(  &quot;compression&quot;=&quot;snappy&quot;)
  PARTITIONED BY (Year, Month, fileDate )
   TBLPROPERTIES (&quot;DataStage&quot;=&quot;{txtDataStage.upper()}&quot;
  ,&quot;Environment&quot;=&quot;{txtEnvironment}&quot;
  ,&quot;source&quot;=&quot;{tableMetadataSource}&quot;
  ,&quot;CreationDate&quot;             = &quot;{tableMetadataCreationDate}&quot;
  ,&quot;CreatedBy&quot;                = &quot;{tableMetadataCreatedBy}&quot;
  ,&quot;Project&quot;                  = &quot;{tableMetadataProject}&quot;
  ,&quot;AssociatedReports&quot;        = &quot;{tableMetadataAssociatedReports}&quot;
  ,&quot;UpstreamDependencies&quot;     = &quot;{tableMetadataUpstreamDependencies}&quot;
  ,&quot;DownstreamDependencies&quot;   = &quot;{tableMetadataDownstreamDependencies}&quot;
  ,&quot;Source&quot;                   = &quot;{tableMetadataSource}&quot;
  ,&quot;PopulationFrequency&quot;      = &quot;{tableMetadataPopulationFrequency}&quot;
  ,&quot;BusinessSubject&quot;          = &quot;{tableMetadataBusinessSubject}&quot;
  ,&quot;JiraProject&quot;              = &quot;{tableMetadataJiraProject}&quot;
  ,&quot;DevOpsProject&quot;            = &quot;{tableMetadataDevOpsProject}&quot;
  ,&quot;DevOpsRepository&quot;         = &quot;{tableMetadataDevOpsRepository}&quot;
  ,&quot;URL&quot;                      = &quot;{tableMetadataURL}&quot;) '''
  
  spark.sql(query)
  </code></pre>