Data Explorer Query Fails After Creating Data Model - "Table does not exist" Error in Data Cloud

Question:

Hi Community,

I'm experiencing an issue with Salesforce Data Cloud in my Developer Org and would appreciate your help.

Background:

I recently enabled Data Cloud and successfully created multiple data streams using:

• AWS S3 connectors
• Other Salesforce orgs
• File uploads

All data streams were ingesting data correctly into the Data Lake object, and I was able to query the data through the Data Explorer without any issues. 

After creating a Data Model for one of the data streams, I can no longer query that data in the Data Explorer. I'm receiving the following error:

Failed to execute query: table "Employee_Salary_Data__dll" does not exist 
[TraceId: 03ee4f5f7bbd2900] 
SQLSTATE: 42P01 
QUERY-ID: MTAuNzYuMTUyLjIxNjo3NDg0_62dbcd6e-8bd0-41ad-9e69-8b3c17b1ed92 
DETAIL: line 1, column 197: ...ion__c" from "Employee_Salary_Data__dll" fetch next 10... ^~~~~~~~~~~~~~~~~~~~~~~~~~~ 
QUERY: select "cdp_sys_SourceVersion__c", "Credit_Card__c", "KQ_UUID__c", "DataSource__c", "DataSourceObject__c", "First_Name__c", "Gender__c", "Bank_Name__c", "Email__c", "InternalOrganization__c" from "Employee_Salary_Data__dll" fetch next 100 rows only

Troubleshooting Steps Already Completed:

1. ✓ Deleted all data streams and created new ones → Same error persists
2. ✓ Deleted all data models and data streams, then recreated → Same error occurs
3. ✓ Logged out and logged back into the org → Issue remains

Environment Details:

• Org Type: Developer Edition
• Data Cloud Status: Enabled
• Data Streams Created: Multiple (AWS S3, Salesforce-to-Salesforce, File Upload)
• Issue Triggered After: Creating a Data Model

1. Root Cause Analysis:
   • What could be causing the "table does not exist" error after creating a Data Model?
   • Why does the error persist even after deleting and recreating data streams?
   • Could there be a caching or indexing issue in Data Cloud?
2. Solutions:
   • What are the recommended steps to resolve this issue?
   • Are there any hidden settings or metadata cleanup steps I should perform?
   • Should I try clearing cache or running any diagnostic tools?
3. Disabling Data Cloud:
   • If I can't resolve this, can I disable or fully delete Data Cloud from my org?
   • Will disabling Data Cloud affect any other Salesforce features?
   • Is there a safe way to remove all Data Cloud components?
4. Prevention:
   • What's the correct workflow for creating Data Streams and Data Models to avoid this issue in the future?

Additional Context:

• I didn't modify any security settings or permissions related to Data Cloud
• I haven't made changes to the data source files
• The issue occurs across all newly created data streams after the first Data Model creation

Has anyone encountered this issue before? Any suggestions on how to move forward would be greatly appreciated! 

Thanks in advance!