I have the text file as

PolicyID~Name~AccountID
1~ABC Holdings~12
2~XYZ Insurance~2

When i do a Select * from dfs.root it works