Views - Renaming Columns

[amenbouallagui]

Hi everyone, I have multiple dba and dbb views created in Fabric Data Warehouse, and I need to rename some column names for better readability (e.g., changing employer name to Employer Name).

The challenge is that these views are quite complex, involving multiple joins from various tables. I’m looking for the best approach to rename columns efficiently without breaking dependencies or affecting performance.

Is there a way to automate this process across multiple views instead of manually updating each one?

What best practices would you recommend? any insights or suggestions would be greatly appreciated! Thank you.

[v-sgandrathi · Accepted solution]

Hi @amenbouallagui,

Thank you for being a part of the Microsoft Fabric Community.

As per my understanding rather than renaming columns at the database schema level, please use column aliases in the view definitions. This approach ensures dependencies remain intact while enhancing readability.

Currently, Microsoft Fabric Data Warehouse does not offer a built-in feature to automatically rename columns across multiple views.

Below are the Microsoft document Links for your reference:
Rename columns (Database Engine) - SQL Server | Microsoft Learn
Aliasing - Azure Synapse Analytics | Microsoft Learn

Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.

Regards,
Sahasra.

[v-sgandrathi]

Hi @amenbouallagui,

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution.
It would be greatly appreciated by others in the community who may have the same question.

Thank you for reaching out! The Microsoft Fabric Community is here to help.

[v-sgandrathi]

Hi @amenbouallagui,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thanks for using Microsoft Fabric Community Forum.