Google Fly Cup Challenge: Recruit - Error in creating dataset and shows no existing bucket

[felitz69]

I am unable to create a dataset in bigquery. It shows the following error, so I went to create it manually.

Even after I created the dataset manually and tried to load the bucket data in my dataset, it gave me these errors and upon checking I found that there is no existing bucket to load data from.

Any resolution that I can do if I face these issues again??

[Altamash_Dev]

such problems happen when u login in normal tab , always login in incognito tab.

also clear browser cache data 

and before starting cloud shell always type gcloud auth list 

then authorize it.

[felitz69]

I did all the things you mentioned but it was the same. I have to waste my attempt and give another try. The same commands then worked.

[Altamash_Dev]

no problem, Good Luck

[GrzWas77]

Hi,

@felitz69 you have alternative as standard DDL commands directly in BigQuery. 

Please see this: cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#create_schema_statement

Is very simple:

CREATE SCHEMA drl;

Best,

Greg