Issue on Automating Snowpipe for Google Cloud Storage

[NiharikaAg2597]

When my trying to create pipe via below command ,I am getting error 

Command:

CREATE OR REPLACE PIPE GCS_SNOWPIPE_BANK

  AUTO_INGEST = true

  INTEGRATION = notification_snowflake_bank

  AS

  COPY INTO SNOWPIPE

  from @gcs_stage_bank1

  file_format = (type = 'JSON');

Error :

090040 (XX000): Pipe Notifications bind failure "Could not monitor projects/banking-project-396814/subscriptions/snowpipe_sub; io.grpc.StatusRuntimeException: PERMISSION_DENIED: Permission monitoring.timeSeries.list denied (or the resource may not exist)."

Kindly help to resolve this.

[ms4446]

The error message indicates that the service account you have provided to Snowflake does not have the required permissions to monitor the specified Pub/Sub subscription. To resolve this, follow these steps:

1. Go to the Google Cloud Platform Console.
2. From the navigation menu, select IAM & Admin > Service accounts.
3. Find and click on the service account you are using with Snowflake.
4. In the Roles section, click the Add button to add a new role.
5. Search for and select the Monitoring Viewer role.
6. Click the Save button.

Additional checks:

• Ensure the Pub/Sub subscription exists in the project associated with the service account.
• Verify the Pub/Sub subscription is active and not filtered to exclude certain events.