How to solve “Invalid uri specification. Option ‘uri’ value must be a wild card URI.”

  Kiến thức lập trình

When I run this query

EXPORT DATA OPTIONS (   uri=CONCAT('gs://gcp_monthly_consumption/GCP_Consumption_Data/_GCP_Consumption_', FORMAT_TIMESTAMP('%Y%m', DATE_SUB(CURRENT_DATETIME(), INTERVAL 1 MONTH)),'.csv'),   format= 'csv',   overwrite=true,   header=true,   field_delimiter=',' ) AS

the name of my file in the bucket it writes to is 000000000000_GCP_Consumption_202403.csv. When removing the wildcard “*”, I get the error How to solve “Invalid uri specification. Option ‘uri’ value must be a wild card URI.”

Aim: get the file name to GCP_Consumption_202403.csv

  • google-cloud-platform
  • google-bigquery

New contributor

Lewis L-3VO Vansteenkiste is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT