`google.cloud.storage.StorageException: 401 Unauthorized`

[JonathonO]

`google.cloud.storage.StorageException: 401 Unauthorized`

[sfc-gh-xhuang]

Hi @JonathonO I believe we have identified the issue. Can you share your account name with me?

[JonathonO]

Hi @Xin Huang ***@***.***>, unfortunately the account no longer exists. They moved to Snowflake on AWS instead.

…

On Tue, 2 Jan 2024 at 23:30, Xin Huang ***@***.***> wrote: Hi @JonathonO <https://github.com/JonathonO> I believe we have identified the issue. Can you share your account name with me? — Reply to this email directly, view it on GitHub <#760 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AMAK337UTPR7J42WYEOVBBDYMSKBXAVCNFSM6AAAAABAJJQCZSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZUGY4DGOJQGY> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[acristu]

@sfc-gh-xhuang we've hit this again, will share account id

[2024-01-31 09:17:46,631] ERROR [ingest-build-upload-thread-22] [destination_65b1e2479dbc1ec795ccdd72|task-4] [SF_INGEST] Building blob failed, client=KC_CLIENT_destination_65b1e2479dbc1ec795ccdd72_10, file=2024/1/31/9/17/s84chm_AAVNK3HyMBvRbZ0zbAA930t0liGIpQOzdL4ZghccPYXX8CC_3001_3631_22.bdec, exception=net.snowflake.client.jdbc.internal.google.cloud.storage.StorageException: 401 Unauthorized
POST https://storage.googleapis.com/upload/storage/v1/b/gcpuscentral1-ifw2pge-stage/o?projection=full&uploadType=multipart, detail=401 Unauthorized
POST https://storage.googleapis.com/upload/storage/v1/b/gcpuscentral1-ifw2pge-stage/o?projection=full&uploadType=multipart, trace=
net.snowflake.client.jdbc.internal.google.cloud.storage.spi.v1.HttpStorageRpc.translate(HttpStorageRpc.java:286)
net.snowflake.client.jdbc.internal.google.cloud.storage.spi.v1.HttpStorageRpc.create(HttpStorageRpc.java:367)
net.snowflake.client.jdbc.internal.google.cloud.storage.StorageImpl.create(StorageImpl.java:183)
net.snowflake.client.jdbc.cloud.storage.SnowflakeGCSClient.uploadWithDownScopedToken(SnowflakeGCSClient.java:723)
net.snowflake.client.jdbc.cloud.storage.SnowflakeGCSClient.uploadWithPresignedUrlWithoutConnection(SnowflakeGCSClient.java:551)
net.snowflake.client.jdbc.SnowflakeFileTransferAgent.pushFileToRemoteStoreWithPresignedUrl(SnowflakeFileTransferAgent.java:2149)
net.snowflake.client.jdbc.SnowflakeFileTransferAgent.uploadWithoutConnection(SnowflakeFileTransferAgent.java:2058)
net.snowflake.ingest.streaming.internal.StreamingIngestStage.putRemote(StreamingIngestStage.java:179)
net.snowflake.ingest.streaming.internal.StreamingIngestStage.putRemote(StreamingIngestStage.java:143)
net.snowflake.ingest.streaming.internal.StreamingIngestStage.put(StreamingIngestStage.java:374)
net.snowflake.ingest.streaming.internal.FlushService.upload(FlushService.java:544)
net.snowflake.ingest.streaming.internal.FlushService.buildAndUpload(FlushService.java:525)
net.snowflake.ingest.streaming.internal.FlushService.lambda$distributeFlushTasks$8(FlushService.java:429)
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
java.base/java.lang.Thread.run(Thread.java:840), all channels in the blob will be invalidated (net.snowflake.ingest.streaming.internal.FlushService)