Unable to resolve column error while trying to query the view

nkrom456
New Contributor III
  • I have a federated table from snowflake in data bricks say employee.
  • When i executed print schema i am able to see schema as "employeeid": long,"employeename":string
  • Tried to create a view as 
  • create view vw_emp with schema binding as select `"employeeid"` from employee 
  • now when i query the view in sql editor select * from vw_emp its giving the unable to resolve column
  • but same query if i try in it notebook with all purpose cluster %sql select * from  vw_emp no issues it gives me the output.
  • Is there any way we can also get the output with sql editor.