I am having an issue when trying to do a full refresh of a DLT pipeline.
I am getting the following error below:
com.databricks.sql.managedcatalog.UnityCatalogServiceException: [RequestId=97d4fe52-b185-4757-b0b1-113cb96ae0bb ErrorClass=TABLE_ALREADY_EXISTS.RESOURCE_ALREADY_EXISTS] Table 'animal_settings_hie_dim' already exists
When I try to read from the table
select * from aadp_dev.edwa_stream.animal_settings_hie_dim
I receive the following error below:
[STREAMING_TABLE_OPERATION_INTERNAL_ERROR] Internal error during operation SELECT on Streaming Table: Please file a bug report. SQLSTATE: XX000
Could you advise me what to do about it?
