Triet Le
01/26/2023, 5:03 PMprefect_bigquery
lib, what should I fill in the location
param if I’ve specified the region for my GCP project as asia-southeast1?
I’ve tried to leave it as default (“US”),fill it as None
,Asia
, ASIA
, and asia-southeast1
,but it’s kept showing the same error as below
File <my_path_to_venv>/lib/python3.10/site-packages/prefect_gcp/bigquery.py", line 223, in bigquery_create_table
client = gcp_credentials.get_bigquery_client(project=project, location=location)
AttributeError: 'SecretDict' object has no attribute 'get_bigquery_client'
Andrew Huang
01/26/2023, 5:18 PMTriet Le
01/26/2023, 5:30 PMgcp_cred = GcpCredentials.load(<my_block_name>).service_account_info
table_name = bigquery_create_table(
dataset=dataset,
table=table,
gcp_credentials=gcp_cred,
external_config=external_config,
location="asia-southeast1")
return table_name
Andrew Huang
01/26/2023, 5:35 PMservice_account_info
property; simply pass in gcp_cred
gcp_cred = GcpCredentials.load(<my_block_name>)
table_name = bigquery_create_table(
dataset=dataset,
table=table,
gcp_credentials=gcp_cred,
external_config=external_config,
location="asia-southeast1")
Triet Le
01/26/2023, 5:58 PMAndrew Huang
01/26/2023, 6:08 PM