search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

Getting "Unsupported external data source type '6'." #18235

Closed ashishmg-gds closed 2 years ago

ashishmg-gds commented 2 years ago

Steps to Reproduce:

  1. Created external data sources for reading parquet files in ADLS gen 2
  2. Tried create project from database and recieving error :

Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlExternalDataSource: Unsupported external data source type '6'.

Does this issue occur when all extensions are disabled?: Yes/No

ashishmg-gds commented 2 years ago

This was due to a data source created in source db , which was not queryable, I guess due to snappy.parquet format. After removing the same, its working now

asackmann commented 2 years ago

This was due to a data source created in source db , which was not queryable, I guess due to snappy.parquet format. After removing the same, its working now

Can you give more details, i have the same error. Thanks.