I want to transfer data from xlsx in storage account to Azure Postgres database, but some of the columns which are there in database tables are missing in xlsx. How can I achieve that without pipeline to fail.

Dinesh Prajapati 126 Reputation points
2023-02-12T17:25:58.3766667+00:00

I want to transfer data from xlsx in storage account to Azure Postgres database, but some of the columns which are there in database tables are missing in xlsx. How can I achieve that without pipeline to fail.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,670 questions
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 26,156 Reputation points
    2023-02-13T21:39:48.9366667+00:00

    @Dinesh Prajapati Hello and welcome to Microsoft Q&A.

    I understand you are trying to copy from excel to Postgres, but the excel has fewer columns than the postgres table, and this mismatch is causing copy to fail.

    To get around this, use the Additional columns feature to generate extra columns to hold the place of the missing columns. You will then need to add these to the mapping, so we know which placeholder goes with which table column.

    User's image

    User's image

    If this solves your problem, please mark as accepted answer. If not, let me know your blocker.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.