Question 137387 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – Data Factory reading boolean from parquet into SQL server

I have Azure Data Factory, with Integration Runtime, with installed Java (OpenJDK), Parquet files in Azure Blob, and a destination table in SQL Server.

I manage to get some fields read from Parquet and written into the SQL Server table correctly.

But one field in Parquet source is boolean.
There is an error when writing the Boolean into SQL Server tinyint field (which looks sensible).

Type=Microsoft.Azure.Data.Governance.Plugins.Core.TypeConversionException,Message=Exception occurred in type conversion

removed the Boolean field, it worked fine. So TypeConversionException is for sure caused by the boolean.
The original field that Parquet file is generated from is a SQL Server tinyint column.

What field type corresponds to Parquet Boolean?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    To answer own question, I let Data Factory create the destination table. For Boolean source It expects [bit] destination in SQL server table.


  2. 0

    When mapping Parquet field of Boolean type, create a database field of "bit" type.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search