Hi @Anonymous ,
Thanks for the reply from frithjof_v .
To update the table in the Fabric Data Warehouse from Lakehouse's notebook, you can use Pyodbc, here is an example:
import pyodbc
# SQL endpoint from your Lakehouse or Warehouse
server = "your_SQL endpoint"
# Name of the Lakehouse or Warehouse
database = "databaseName"
# Service principal credentials
clientId = "xxxxx"
clientSecret = "xxxxx"
# Connection string
constr = f"driver=ODBC Driver 18 for SQL Server;server={server};database={database};UID={clientId};PWD={clientSecret};Authentication=ActiveDirectoryServicePrincipal;Encrypt=yes;Timeout=60;"
# Connect to the database
con = pyodbc.connect(constr)
cursor = con.cursor()
# SQL command to rename the column in DimProduct table
update_command = """
ALTER TABLE DimProduct
RENAME COLUMN ProductName TO Name;
"""
# Execute the command
cursor.execute(update_command)
con.commit()
# Close the connection
cursor.close()
con.close()
print("Update successful")
Replace server, database, clientId, and clientSecret with your own information.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
