How to fix “Computed columns are not supported with external tables for sharded data.”

corey

corey

This post was written the first day I encountered this error on Azure SQL Server because I could not find any web page that contained this error message.

If you’re getting the error, Computed columns are not supported with external tables for sharded data. while trying to create External Tables, remove the computed column definitions. Treat computed columns like normal columns and provide a data type. Read this: https://stackoverflow.com/a/43382300/338432

Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Comments