Forum Discussion

amenbouallagui's avatar
amenbouallagui
Frequent Visitor
1 year ago
Solved

Views - Renaming Columns

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 ch...
Warehouse
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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's avatar
v-sgandrathi
Community Support
1 year ago

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's avatar
    v-sgandrathi
    Community Support
    1 year ago

    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's avatar
      v-sgandrathi
      Community Support
      1 year ago

      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.