Forum Discussion
Copy a Table in SQL Server into Parquet Format in Blob Storage
Hi KylieF,
We would need to some debugging to understand which values are actually causing the problem.
Please enable fault tolerance with 'Skip incompatible rows'. This will load all correct data into the table.
Enable logging so that a log is created which contains rows that are causing the problem. You can check individual columns to understand any special character/value that is causing the problem.
In addition to that, you can try mapping manually giving the column names and data types. Note that, parquet has some restrictions on column names.
Hi KylieF,
We would need to some debugging to understand which values are actually causing the problem.
Please enable fault tolerance with 'Skip incompatible rows'. This will load all correct data into the table.
Enable logging so that a log is created which contains rows that are causing the problem. You can check individual columns to understand any special character/value that is causing the problem.
In addition to that, you can try mapping manually giving the column names and data types. Note that, parquet has some restrictions on column names.