admin管理员组

文章数量:1291309

I have created an external table in BigQuery, which is based on the GCS path that holds data in Delta format. I updated the schema of that GCS data using the mergeSchema command. Now, I am attempting to refresh the schema of the BigQuery table, but it seems to be functioning as a table creation command instead.

Refresh code used: REQUEST='{ "externalDataConfiguration": { "sourceFormat": "DELTA_LAKE", "sourceUris": [ "DELTA_TABLE_GCS_BASE_PATH" ], "connectionId": "PROJECT_ID.REGION.CONNECTION_ID", "autodetect": true }, "tableReference": { "tableId": "DELTALAKE_TABLE_NAME" } }' echo $REQUEST |curl -X POST -d @- -H "Content-Type: application/json" -H "Authorization: Bearer $(gcloud auth print-access-token)"

error: "{ "error": { "code": 409, "message": "Already Exists: Table Name", "errors": [ { "message": "Already Exists: Table :TableName", "domain": "global", "reason": "duplicate" } ], "status": "ALREADY_EXISTS" } } "

To update the Schema of the BQ table

本文标签： google bigqueryRefresh Schema for external tables for Delta LakeStack Overflow

版权声明：本文标题：google bigquery - Refresh Schema for external tables for Delta Lake - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741530575a2383732.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。