Forum Discussion
Schema mismatch error In Warehouse
Hi Anonymous ,
Thanks for using Fabric Community.
At present schema drift is not available in Fabric.
Copy activity allows, if your destination table already exists, and the data you are writing has a column missing, it will be defaulted to null (default value) when writing to destination. If there is a new column, or if a column is not typecastable to the destination type, then this is treated as a bad row, and you can either skip writing this bad row (and log it into a temporary storage to be processed later), or fail the operation (the default).
Hi Anonymous ,
Thanks for using Fabric Community.
At present schema drift is not available in Fabric.
Copy activity allows, if your destination table already exists, and the data you are writing has a column missing, it will be defaulted to null (default value) when writing to destination. If there is a new column, or if a column is not typecastable to the destination type, then this is treated as a bad row, and you can either skip writing this bad row (and log it into a temporary storage to be processed later), or fail the operation (the default).
Hi Anonymous
Thanks for your responce.
I recently intracted with Microsoft Development team regarding this issue. they concluded that the Schema drift and Auto refresh options are not available in Microsoft Fabric.
Hi Anonymous ,
Glad to know that your query got resolved.
Please continue using Fabric Community for your further queries.