Hi ,
I’m using Metabase Open Source connected to BigQuery. I’m able to run queries successfully on the table LOCO_AB_daily_record through the SQL editor, but this table does not appear in the Metabase table metadata (Data Model or Browse Data).
Here’s what I’ve tried so far:
• Verified that the table exists in BigQuery and is a BASE TABLE
• Confirmed I have admin access
• Tried clearing the browser and used differnt browser
• Triggered a manual schema sync and field value re-scan via API:
POST /api/database/39/sync_schema
POST /api/database/39/re_scan_values
• Verified through /api/table that the table is not registered at all in Metabase’s internal metadata
• Attempted to rename the table to lowercase (loco_ab_daily_record) – it still didn’t appear
• Checked and confirmed that the table doesn’t use complex types like STRUCT or ARRAY
I have also checked the logs, we are not seeing any error or issues wrt sync call.
Diagnostic Info
{
"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/137.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"h2",
"mysql",
"redshift",
"bigquery-cloud-sdk",
"postgres"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-08-26",
"tag": "v0.50.22",
"hash": "16a6c22"
},
"settings": {
"report-timezone": "Asia/Calcutta"
},
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.32"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.15+6-LTS",
"java.vendor": "Amazon.com Inc.",
"java.vendor.url": "Production-ready distribution of OpenJDK – Amazon Corretto – AWS",
"java.version": "17.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.15+6-LTS",
"os.name": "Linux",
"os.version": "5.10.157-139.675.amzn2.x86_64",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
}
}
I have added this table 1 week back on BQ.
Please let me know how i can fix this?
Regards,
Deepanshu