I have a problem creating a table from a data warehouse backup file (in cloud storage)
A problem arises with a certain kind of entity. I have about 20 kinds of entities in the application data store. If I back up the database for all kinds of entities, I have no problem importing into bigquery almost all the relevant {EntityName} .backup_info files, either using the Bigquery UI interface (creating a table) or using the API through this nice pyton package https://github.com/tylertreat/BigQuery-Python
The problem occurs when backing up for a specific type of object. When I try to import it through the user interface or API, I get the following job load error
Field {field_name} already exists in the schema
I am upset trying to solve this problem. I will be happy to provide the URL of the .backup_info file in the cloud storage and give permission to someone on google to fix this problem.
Further research:
I see in the statistics of the repository (a breakdown by properties and composite indices) that the Credit property, which is the cause of the error, appears twice in the scheme
Credit Key 35.23 KB 173.94 KB 0
Credit NULL 501.34 KB 6.77 MB 2
A model that once had a key property, but was deleted, so some objects with this property may presumably exist. Another property of Credit NULL does not know what this means.
, , , , . ( 50K) ( ). ? "", .