Google Big Query: The specified bucket does not exist when using Normal Output Tool

I get this error when using the BIG QUERY BULK LOADER DATA SOURCE in the Output Tool and I have ensured that my table name is correct. How do I solve this issue?

Failed to complete write to Google Big Query: The specified bucket does not exist.

I used different bucket names such as prj-edw-sandbox.New_analytics.STORAGE , New_analytics.STORAGE, STORAGE

Publish

Datasets

Output

Tips and Tricks

Custom Tools

Connectors

Transformation

Help

Google Analytics

Accepted answers

vibes360

Hi, you are correct as the storage bucket name should not have any prefix. However, I noticed that the connection only worked when I put a dataset name in my connection settings even though Alteryx said a dataset name is not compulsory.

Thank you for your support here

All comments

Raj

@vibes360
The error you're encountering suggests that the Google Cloud Storage (GCS) bucket specified in your Alteryx configuration does not exist or is not correctly referenced.

In the Alteryx Output Tool configuration for Google BigQuery, try using the bucket name only and is correctly entered without additional table or project names. It should just be the bucket name, not prj-edw-sandbox.New_analytics.STORAGE or New_analytics.STORAGE.

hope this helps.

vibes360

Hi, I tried all these things you said and it didn't work. I need a specific syntax or template on how to connect to a Google Cloud Bucket in Google Cloud. Also, Alteryx is confusing with their language. A Google Bucket is a folder to store random files, a table is a database that can hold tabular data. I don't even know if Alteryx is referring to a Bucket or Table with their statement

Raj

@vibes360
try referring this
How to set up Google Big Query Bulk Write in Designer 22.3 (alteryx.com)

vibes360

Thank you for the article but honestly, it does not solve my issue as Alteryx does not specify how to connect to a bucket in Google Cloud in the article. All my Input connections in Google Cloud work just the write has an issue

apathetichell

Do you have a GCS storage bucket already connected to your BQ DB? Do you have access to the storage bucket api (ie can you create/access a GCS storage bucket?). I'd look into that. Storage bucket naming conventions should be mystoragebucket-for-my-bq - It will not have a period or an uppercase character in it.

vibes360

Thank you for your support here

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703