How do I identify the Google Cloud Storage URI from my Google Developers Console?

google-cloud-platform google-bigquery google-cloud-storage
Kelly picture Kelly · Aug 19, 2014 · Viewed 29.8k times · Source

When I attempt load data into BigQuery from Google Cloud Storage it asks for the Google Cloud Storage URI (gs://). I have reviewed all of your online support as well as stackoverflow and cannot find a way to identify the URL for my uploaded data via the browser based Google Developers Console. The only way I see to find the URL is via gsutil and I have not been able to get gsutil to work on my machine.

Is there a way to determine the URL via the browser based Google Developers Console?

Answer

nmore picture nmore · Aug 19, 2014

The path should be gs://<bucket_name>/<file_path_inside_bucket>.

Related questions

What's the difference between BigQuery and BigTable?

Is there any reason why someone would use BigTable instead of BigQuery? Both seem to support Read and Write operations with the latter offering also advanced 'Query' operations. I need to develop an affiliate network (thus I need to track …

Read More
Random Sampling in Google BigQuery

I just discovered that the RAND() function, while undocumented, works in BigQuery. I was able to generate a (seemingly) random sample of 10 words from the Shakespeare dataset using: SELECT word FROM (SELECT rand() as random,word FROM [publicdata:samples.shakespeare] …

Read More
Converting JSON into newline delimited JSON in Python

My goal is to convert JSON file into a format that can uploaded from Cloud Storage into BigQuery (as described here) with Python. I have tried using newlineJSON package for the conversion but receives the following error. JSONDecodeError: Expecting value …

Read More