Forum Discussion

akanane's avatar
akanane
Frequent Visitor
2 years ago

Fabric Rest API Partition Loss when Overwriting CSV Table

Hello everyone,

 

I've encountered an issue while using the Fabric REST API to load a CSV file into a table in overwrite mode. 

 

Here's an outline of the steps I've followed:

  1. Created a table with column partitions
  2. Load data from a CSV file into this table in overwrite mode using the api

After performing the data load operation via the API in overwrite mode, the table appears to lose its partitioning. I've verified the table setup, but the partitions seem to vanish after the data load.

 

Any insights, suggestions, or alternative approaches to preserve partitions during the overwrite data load process would be greatly appreciated.

 

Thank you in advance for your help and insights!

Best regards

 

Amnay

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello akanane .

    Thanks for using Fabric Community.

    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi akanane ,

      Apologies for the issue you have been facing. If its a bug, we will definitely would like to know and properly address it. Please go ahead and raise a support ticket to reach our support team: https://support.fabric.microsoft.com/support

      After creating a Support ticket please provide the ticket number as it would help us to track for more information.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi akanane ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .