I have successfully connect to google analytics but I'm unable to pull any data, i keep getting This database doesn't have any tables.
Hi @shafii
Post "Diagnostic Info" from Admin > Troubleshooting.
It can take a little while to sync newly added databases.
You can following the process in Admin > Troubleshooting > Logs.
And you can manually force sync via Admin > Databases > (your-db) > Sync database schema now.
Hi @flamber,
I tried force synced still same, the connection has been successful for more than a week now
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:01:07+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 3.2 ms (3 DB calls) App DB connections: 4/15 Jetty threads: 4/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:01:59+03:00 DEBUG metabase.server.middleware.log PUT /api/database/6 200 229.5 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:01:59+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 3.0 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.task.sync-databases Starting sync task for Database 6.
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: Sync metadata for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA' (237.4 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA' (192.2 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA' (666.1 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA' (398.9 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA' (410.6 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 6 'Achieveone GA' (609.2 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA' (381.6 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA' (192.6 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA' (181.7 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 6 'Achieveone GA' (3.2 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: Refingerprinting tables for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util STARTING: step 'refingerprinting fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: step 'refingerprinting fields' for googleanalytics Database 6 'Achieveone GA' (1.9 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:00+03:00 INFO metabase.sync.util FINISHED: Refingerprinting tables for googleanalytics Database 6 'Achieveone GA' (6.4 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:03+03:00 INFO metabase.sync.util STARTING: Cache field values in googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:03+03:00 INFO metabase.sync.util STARTING: step 'update-field-values' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:03+03:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for googleanalytics Database 6 'Achieveone GA' (693.8 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:03+03:00 INFO metabase.sync.util FINISHED: Cache field values in googleanalytics Database 6 'Achieveone GA' (3.1 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:03+03:00 DEBUG metabase.server.middleware.log POST /api/database/6/rescan_values 200 4.7 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:06+03:00 INFO metabase.sync.util STARTING: Sync metadata for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:06+03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:06+03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA' (486.3 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:06+03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:06+03:00 DEBUG metabase.server.middleware.log POST /api/database/6/sync_schema 200 6.5 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA' (914.4 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA' (530.2 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA' (385.9 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:07+03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA' (1.0 s)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 6 'Achieveone GA' (2.0 s)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA' (319.9 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA' (217.7 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA' (260.9 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:08+03:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 6 'Achieveone GA' (3.8 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:11+03:00 DEBUG metabase.server.middleware.log POST /api/database/6/discard_values 200 19.2 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: Sync metadata for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for googleanalytics Database 6 'Achieveone GA' (373.5 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 DEBUG metabase.server.middleware.log POST /api/database/6/sync_schema 200 4.5 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for googleanalytics Database 6 'Achieveone GA' (178.0 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA' (533.2 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for googleanalytics Database 6 'Achieveone GA' (400.4 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:12+03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for googleanalytics Database 6 'Achieveone GA' (1.4 s)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: Sync metadata for googleanalytics Database 6 'Achieveone GA' (1.6 s)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util STARTING: Analyze data for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA' (204.1 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for googleanalytics Database 6 'Achieveone GA' (289.6 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA' (175.6 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:13+03:00 INFO metabase.sync.util FINISHED: Analyze data for googleanalytics Database 6 'Achieveone GA' (3.2 ms)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:14+03:00 DEBUG metabase.server.middleware.log POST /api/database/6/rescan_values 200 926.1 µs (1 DB calls) App DB connections: 2/15 Jetty threads: 4/50 (4 idle, 0 queued) (135 total active threads) Queries in flight: 0 (0 queued)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:14+03:00 INFO metabase.sync.util STARTING: Cache field values in googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:14+03:00 INFO metabase.sync.util STARTING: step 'update-field-values' for googleanalytics Database 6 'Achieveone GA'
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:14+03:00 INFO metabase.sync.util FINISHED: step 'update-field-values' for googleanalytics Database 6 'Achieveone GA' (701.5 µs)
[428b3069-6185-4a4b-b26a-69c2d310feb0] 2022-04-05T15:02:14+03:00 INFO metabase.sync.util FINISHED: Cache field values in googleanalytics Database 6 'Achieveone GA' (2.3 ms)
Blockquote
You mean this
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14+9-Ubuntu-0ubuntu2.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.14",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14+9-Ubuntu-0ubuntu2.20.04",
"os.name": "Linux",
"os.version": "5.4.0-73-generic",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"mysql",
"h2",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-03-23",
"tag": "v0.42.3",
"branch": "release-x.42.x",
"hash": "33fb268"
},
"settings": {
"report-timezone": null
}
}
}
@shafii So I'm guessing you did the setup of GA on 0.42.3, or did you do it before?
The reason is that there's a completely different setup now, because Google deprecated their API, so it now requires Service Accounts:
https://www.metabase.com/docs/latest/administration-guide/databases/google-analytics.html
If you are using Service Accounts, then make sure that someone didn't change/disable some configuration in Google/GA.
You should migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
I did the setup on the Metabase latest version
I tried migrating from H2 to Postgres but now I cant start the service again; below is the most occurring error
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!!
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 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-Ubuntu-0ubuntu1.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1-Ubuntu-0ubuntu1.20.04",
"os.name": "Linux",
"os.version": "5.4.0-97-generic",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"mysql",
"googleanalytics"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.3.34-MariaDB-0ubuntu0.20.04.1"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.5"
}
},
"run-mode": "prod",
"version": {
"date": "2022-03-23",
"tag": "v0.42.3",
"branch": "release-x.42.x",
"hash": "33fb268"
},
"settings": {
"report-timezone": null
}
}
}
Try starting with more debug logging, since I have no idea what it's not working.
I don't know if Google has made another change. If it does not work for any new setups, then I guess something has been deprecated, but it's hard to find information.
JAR - example, expecting MB_DB_* variables are already used otherwise include those as well:
java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar
Hate to be a bearer of bad news but ran into the same issue as above.
I have a metabase install of v0.42.3 using this image:
https://hub.docker.com/layers/metabase/metabase/metabase/v0.42.3/images/sha256-9bf0329afe81e17d979989e12f1636baefcf2a57b3716b33560290394650cfb5?context=explore
Followed, the new GA steps from this guide:
Everything connected well.
But I'm getting:
This database doesn't have any tables.
Hi! I also can not get all date from GA. Have you managed to solve the problem? Is it because metabase doesn't support the latest version of GA4? I will appreciate any information you can share)