unable see data in external created based on tab delimited file

Question

I am able to query an external table made of tab delimited file via spark engine but unable to see any data when queried from SSMS

Error faced in sql:

Started executing query at Line 1 Warning: No datasets were found that match the expression 'test.test'. Statement ID: {85B0AD59-0E40-4610-853E-512E16A752AC} | Query hash: 0x2B1BAAB3BB992884 | Distributed request ID: {13084C6C-F30B-46F7-8751-0497EE95D882}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes. (0 record affected) Total execution time: 00:00:00.794

table script as below

%%pyspark

spark.sql("""CREATE EXTERNAL TABLE IF NOT EXISTS test.test (a varchar(200),b varchar(200),c varchar(200),d varchar(200)) USING csv OPTIONS (path 'abfss://******@container.dfs.core.windows.net/test/' , delimiter "\t", header "true")""")