Hi! I want to +1 to this issue and am not sure what's wrong with my setup either...
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.74 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.144+",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.0"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-03-23",
"tag": "v0.42.3",
"branch": "release-x.42.x",
"hash": "33fb268"
},
"settings": {
"report-timezone": null
}
}
}
above is my trouble shooting info, and I have made sure I configured the Google Analytics with the latest Metabase following the new guide. (I posted Got Authorization Error when trying to integrate Google Analytics to Metabase originally so I'm sure I haven't done it in past versions of metabase), checked both GA API and Service Accounts and both looked fine to me, but it still shows This database doesn't have any tables. to me. Logs defo indicate it does something:
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: Sync metadata for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for googleanalytics Database 3 'Google Analytics ' (1.0 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: step 'sync-tables' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for googleanalytics Database 3 'Google Analytics ' (626.2 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: step 'sync-fields' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for googleanalytics Database 3 'Google Analytics ' (4.0 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: step 'sync-fks' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for googleanalytics Database 3 'Google Analytics ' (3.6 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:00+08:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for googleanalytics Database 3 'Google Analytics ' (601.2 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 3 'Google Analytics ' (1.3 s)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for googleanalytics Database 3 'Google Analytics ' (2.3 ms)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util STARTING: step 'classify-fields' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for googleanalytics Database 3 'Google Analytics ' (912.4 µs)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util STARTING: step 'classify-tables' for googleanalytics Database 3 'Google Analytics '
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for googleanalytics Database 3 'Google Analytics ' (969.9 µs)
[00f951b5-05eb-43fa-932b-3468801d8557] 2022-04-04T08:00:01+08:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 3 'Google Analytics ' (32.7 ms)
Thanks a lot!!