Forum Discussion

MK007's avatar
MK007
Frequent Visitor
1 year ago
Solved

OneLake shortcuts in source control

Hi,

I have been trying to test Git compatibility with OneLake shortcuts. I've created a Lakehouse and attempted to create both a schema shortcut and a table shortcut. However, while the Lakehouse, including the lakehouse.metadata.json file, is available in Git, I am unable to see the shortcuts.metadata.json file under the Lakehouse folder in Git, as mentioned in this article: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-git-deployment-pipelines#onelake-shortcuts-git-integration-capabilities

Do you have any thoughts or ideas?

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi MK007,

    Thank you for your detail explanation.

     

    We regret any inconvenience this may cause, If you've completed the given steps and the shortcuts.metadata.json file still does not appear in your Git repository, the issue may be related to a specific OneLake or Fabric configuration.

    I suggest you to kindly submit a support ticket for assistance.

     

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MK007 ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    Please ensure that your Lakehouse is properly connected to your Git repository. Any incorrect configuration could prevent metadata files from syncing correctly.

    There may occasionally be a delay in syncing metadata files to the Git repository. Wait for a brief period and check again to see if the shortcuts.metadata.json file appears. Also, verify that you have the required permissions to access all files in the Git repository. Limited permissions could result in certain metadata files being hidden.

     

    I hope my suggestion give you good idea, if you need any further assistance, feel free to reach out.

     

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

    • DSZ's avatar
      DSZ
      Advocate I

      HI Anonymous 

      We are facing with the same issue. I can tell you We have Full admin rights to see anything on anywhere. 
      scanario:

      1. Create a Test 1 LH
        1. Create a TestTable
      2. Create a Test 2 LH
        1. Shortcut The TestTable

      Are you sure this is unleashed in West Europe? 

    • MK007's avatar
      MK007
      Frequent Visitor

      Hi Anonymous ,

      Thanks for your response. Please see my comments below:

      1. Please ensure that your Lakehouse is properly connected to your Git repository. Any incorrect configuration could prevent metadata files from syncing correctly.
        I believe this is properly connected as my newly created Lakehouse shows up in git folder including the lakehouse.metadata.json file. Is there anything else I should check to confirm connection?
      2. There may occasionally be a delay in syncing metadata files to the Git repository. Wait for a brief period and check again to see if the shortcuts.metadata.json file appears.
        It has been over 24 hours but still no shortcuts.metadata.json file.
      3. Also, verify that you have the required permissions to access all files in the Git repository. Limited permissions could result in certain metadata files being hidden.
        I am able to see the lakehouse.metadata.json file in git repository. Do I need any other permission(s) view shortcuts.metadata.json file?
      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi MK007,

        Thank you for your detail explanation.

         

        We regret any inconvenience this may cause, If you've completed the given steps and the shortcuts.metadata.json file still does not appear in your Git repository, the issue may be related to a specific OneLake or Fabric configuration.

        I suggest you to kindly submit a support ticket for assistance.

         

        To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
        How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

         

        If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

         

        Thank you.

  • JonMoz's avatar
    JonMoz
    Regular Visitor

    I'm also interested in this, the wiki page suggests that functionality is now in preview but it doesn't work for me and I can't see anywhere to enable the preview functionality (e.g. in fabric/tenant admin).

  • DSZ's avatar
    DSZ
    Advocate I

    Update!

    We noticed that the functionality became available one day later. You need to commit the Lakehouse in your workspace; however, you’ll already see that a change has occurred in the Lakehouse. After that, save the new metadata file.

    • Kosta_M's avatar
      Kosta_M
      New Member

      Could you elaborate on this one?

      So I already have a lakehouse, and it's tracked in git.

      I added a schema shortcut to a SharePoint folder with an Excel file, and nothing shows up under pending changes.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MK007 ,

     

    Could you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster. 

    If we don’t hear back, we’ll go ahead and close this thread.Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

     

    Thank you.

  • Are there any updates on the issues? It's still a problem.

    I have a Bronze lakehouse.

    When I add a file/folder shortcut, it records the change in shortcuts.metadata.json under the Bronze lakehouse in git.

    When I add a schema/table shortcut, nothing shows up.

    If you branch off into a new workspace, all your schema/table shortcuts are gone.