Unable to rename Lakehouse Table

[Potpot]

Using the UI renaming a LakeHouse table doesn't update the table name. No change is made.

[Heaven]

HOW CAN WE CHANGE THE COLUMN HERE??

[GilbertQ]

Hi @Potpot 

As far as I am aware, you would likely need to use a Python notebook to rename the table.

Here is the same code below where I am renaming my table from "fact_daily_f2" to "fact_daily"

# Welcome to your new notebook
# Type here in the cell editor to add code!
from pyspark.sql import SparkSession

# Create a Spark session
spark = SparkSession.builder \
    .appName("RenameDeltaTable") \
    .config("spark.databricks.delta.retentionDurationCheck.enabled", "false") \
    .getOrCreate()

# Rename Delta table
spark.sql("ALTER TABLE fact_daily_f2 RENAME TO fact_daily")

# Stop the Spark session
spark.stop()