1

I've created a DLT table by specifying database in the target, but while querying the same using SQL endpoint, its throwing exception. 'Failure to initialize configuration'

Please note that source is defined as ADLS. The DLT table should be queryable.

metastore is hive_metastore catalog

Ravindra
  • 31
  • 2
  • do you have correct configuration of the service principal, etc. in the DBSQL admin console? – Alex Ott Nov 16 '22 at 20:12
  • Hi @Ravindra Please add more information and error message with your code. – B. B. Naga Sai Vamsi Nov 17 '22 at 03:04
  • Hi @AlexOtt I missed to configure SP in SQL admin console settings. [Data access configuration - Azure Databricks - Databricks SQL | Microsoft Learn](https://learn.microsoft.com/en-us/azure/databricks/sql/admin/data-access-configuration#storage-access) – Ravindra Nov 18 '22 at 13:29
  • yes, it's typical. Here is answer about that: https://stackoverflow.com/questions/74375042/databricks-sql-database-creation-with-location-azure-data-lake/74376819#74376819 – Alex Ott Nov 18 '22 at 14:15

0 Answers0