George's
Reputation: 1
How can I read google-cloud-storage file's metadata from BigQuery
I have a csv file in my google-cloud storage and I have some custom meta-data on this file. I want to read this metadata from my BigQuery. Is this possible. If so please let me know how this should be done.
Upvotes: 0
Views: 1278
Answers (1)
guillaume blaquiere
Reputation: 76093
With BigQuery, it's not possible to query external API. You can only process data reachable by bigquery (native table, google drive files, GCS files, BigTable tables and Cloud SQL request) and not perform API call, for example to get the file metadata.
You can only know the file name, not more.
Upvotes: 1
Related Questions
- In BigQuery, query to get GCS metadata (filenames in GCS)
- How to query column metadata in BigQuery
- Is it possible to read gcs object's metadata from BigQuery using UDF
- Cloud Storage Text to BigQuery using GCP Template
- Is it possible to query Google Cloud Storage custom metadata?
- Bigquery and Google Cloud Storage
- Load data from Google Cloud Storage to BigQuery using Java
- Google BigQuery, How to load data from google cloud storage to BigQuery
- BigQuery - How to set the file stored in google cloud storage as schema file reference for BQ LOAD command?
- Load data from Google Cloud Storage to BigQuery using Java