Forum Discussion

BCBSTnathan's avatar
BCBSTnathan
Frequent Visitor
2 years 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
    2 years 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!

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hi BCBSTnathan @can you share how you're creating the tables in your Notebook? Only Delta tables are supported in the SQL Endpoint.  EG if you create external tables directly over CSV, you won't see those tables in SQL Endpoint.


Also, is your Lakehouse enabled for the new schema public preview? EG you can create additional schemas inside the Lakehouse? If so then currently SQL Endpoint is not supported so you won't see any tables appearing.