Ingestion fails for SF Views with an empty column name

[tkdrahn]

Describe the bug

This PR added validation to enforce that schema fieldPaths are always non-empty. This causes ingestion to fail for Snowflake Views which have empty column names. Requesting that the validation be reverted or adjusted

#11619

To Reproduce
Run Snowflake ingestion
Find a dataset for a View with an empty column name
Note that Schema tab is empty (failed to ingest)

Expected behavior
Expected SchemaMetadata aspect to get ingested for any valid Snowflake View

Screenshots
N/A

Desktop (please complete the following information):
N/A

Additional context
Add any other context about the problem here.