Hello @jia si ,
Thanks for the ask and using the Microsoft Q&A platform .
From the error it looks to be the user which is setup in the linked service is not able to access a file . I am not sorry but why it is complaining about a file , have you enabled staging Option , if yes can you please check the credential there ? Sharing the snapshot below .
The below linked service for Snowflake works for me .
Please do let me know how it goes .
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members