1

I’m trying to connect snowflake with stitch, I’m trying to get google sheets data to snowflake using stitch. I’ve strictly followed documentation but the connection exits with 403 error. Please help me resolve this issue

tomdxb0004
  • 61
  • 1
  • 6
  • This is not enough to understand why you're getting 403. Is there any error message? Are you able at least to connect to Snowflake? Are you using the proper role? – Sergiu Dec 13 '21 at 08:21
  • a couple of reasons for 403 are listed here: https://docs.snowflake.com/en/search.html#q=403&t=All&sort=relevancy – FKayani Dec 13 '21 at 09:15
  • Issue is fixed. @sergiu- 403 error was caused because I made a new user to access the db, but user permissions were not granted. – tomdxb0004 Dec 13 '21 at 20:33
  • @Fkyani - in snowflake documentation it mentions to use account as abcde.snowflakecomputing.com. In my case it did not work. I had to mention the region & whitelist IPs(stitch IPs & my local IP) – tomdxb0004 Dec 13 '21 at 20:36

1 Answers1

0

Issue is fixed. @sergiu- 403 error was caused because I made a new user to access the db, but user permissions were not granted. Stitch documentation is incomplete in this regard.

tomdxb0004
  • 61
  • 1
  • 6