@@mastering_snowflake I face the same issue while trying out with csv. My question is while creating the pub/sub topic, should I specify -f json or -f none , since my file is a .csv?
Can you please create a video how to move data the other direction, from Snowflake table to GCP using service account? For this direction, does the service account have to be created by GCP or created by Snowflake?
I have done simiilar configuation setup for AWS, very helpful content to learn from Google side as well. Thank you for sharing!
Great job!
I did the same with GCP (With CSV format), pipe is hitting GCP but NOT reading the data. Any ideas?
Check the file format is correct
And then you can attempt to run the copy into statement manually to aid with troubleshooting before you wrap it in a create pipe statement
@@mastering_snowflake I face the same issue while trying out with csv. My question is while creating the pub/sub topic, should I specify -f json or -f none , since my file is a .csv?
Can you please create a video how to move data the other direction, from Snowflake table to GCP using service account? For this direction, does the service account have to be created by GCP or created by Snowflake?
It’s actually quite different and straightforward to unload data from Google to a GCS bucket using the COPY INTO command
That did not work, the command line......
For anyone facing bind issue - give monitoring viewer role to gcp_pubsub_service_account
Try going to GCP dashboard -> Add people to this project -> Add SA and select monitoring viewer
@@HimanshuSharma-fg2nj does this resolve bind issue
how can we add this role i am unable to by pass this bind issue