dataverbinders / toepol

Making Dutch open data more easily accesible
0 stars 0 forks source link

Platform Data Gap - The CBS tables that are in ProjectId - dataverbinders-cbs-dl does not sync from BigQuery to DBSchema with Big connection ProjectId dataverbinders-open-dwh. #8

Open Michelangelo367 opened 2 years ago

Michelangelo367 commented 2 years ago

With DBSchema connection (ProjectId - dataverbinders-open-dwh) it's only possible to sync the tables/views that are in the same ProjectId.

As a workaround solution I create in BigQuery views (select * from dataverbinders-cbs-dl.table) in dataverbinders-open-dwh in dataset "source" and those views can be synced to DBSchema.