Forum Discussion

BCBSTnathan's avatar
BCBSTnathan
Frequent Visitor
1 year ago
Solved

Lakehouse Tables Not Appearing in SQL Endpoint Schema

Hello everyone, I’m using notebooks to create several lakehouse tables from CSV files. The tables are being created successfully in the lakehouse, but they are not appearing under the lakehouse SQL ...
data engineering
lakehouse
notebook
  • BCBSTnathan's avatar
    BCBSTnathan
    1 year ago

    Thank you all for your support! I was able to successfully create the delta tables, and they are now visible in the SQL endpoint. I must admit, the issue was due to blank spaces in the column names, and a blank line at the end of the files. Once I removed those, everything worked OK!

     

    Through this process, I also added code to catch exceptions and handle blank spaces, which will help similar issues in the future. 


    A special thank you to Anonymous and AndyDDC  -- I appreciate you both for checking in and providing support. Thank you!

BCBSTnathan's avatar
BCBSTnathan
Frequent Visitor
1 year ago

Thank you all for your support! I was able to successfully create the delta tables, and they are now visible in the SQL endpoint. I must admit, the issue was due to blank spaces in the column names, and a blank line at the end of the files. Once I removed those, everything worked OK!

 

Through this process, I also added code to catch exceptions and handle blank spaces, which will help similar issues in the future. 


A special thank you to Anonymous and AndyDDC  -- I appreciate you both for checking in and providing support. Thank you!