Columns not showing up in SQL Analytics Endpoint of a Lakehouse

[jjaeger94]

Here is a screenshot of the columns in the Lakehouse:

Here is the columns available in the SQL Analytics endpoint

I am missing two fields __START_AT and snapshot_date. I don't know why that is. I've waited a few days and still nothing changes.

[AndyDDC · Accepted solution]

Looks like the snapshot_date and _start_at should be date/datetime data types? What are the current data types of those 2 columns? It's possible there is a sync issue due to the current data type of those 2 columns.

[jjaeger94]

Changing the data type to Date fixed the issue.

[AndyDDC]

Good to hear