I have connected presto database to my metabase and although whiile making a connection i did chose let me choose when Metabase syncs and scans but for some reason i can see metabase hitting queries on presto clusters for scanning tables .
Could anyone help to stop this scan as it is causing a lot of load on the server.
Hi @shadma
Post "Diagnostic Info" from Admin > Troubleshooting.
Which queries are you seeing on Presto?
So did you disable Scanning?
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html#choose-when-metabase-syncs-and-scans
Hii @flamber
i am seeing queries like
-- Metabase
SELECT "db"."table"."column" AS "column" FROM "db"."table" GROUP BY "db"."table"."column" ORDER BY "db"."table"."column" ASC LIMIT 5000
and yes i did disable scanning
@shadma You have not disabled scanning, besides enabling custom scheduling. You have to click the Scheduling-tab. See the screenshot in the link I provided.
@flamber i checked that and its disabled
Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+10",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+10",
"os.name": "Linux",
"os.version": "5.4.0-1018-aws",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"postgres",
"mysql",
"redshift",
"presto",
"druid",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.4"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"date": "2020-12-03",
"tag": "v0.37.3",
"branch": "release-x.37.x",
"hash": "2f1e783"
},
"settings": {
"report-timezone": null
}
}
}
@flamber could you help me disable this metabase scans?
@shadma You're seeing this issue - see the workaround:
https://github.com/metabase/metabase/issues/16101 - upvote by clicking 
on the first post
Hii @flamber ,
The solution you suggested doesn't seem feasible as there are a lot of tables that have different columns and to manually set the Filtering to plain text/search box may take a lot of bandwidth is there any other way to stop all scanned queries metabase is hittting?
@shadma Go to the application database table metabase_field and change the column has_field_values to none or search
1 Like
Thanks that would be really helpful @flamber ,
and doing this will stop metabase to hit scan queries forever?
Also could you let me know what timezone metabse uses its GMT right?
@shadma Yes, it will not make those types of scan queries anymore.
I cannot tell you the timezone, since that depends on your setup - post "Diagnostic Info" from Admin > Troubleshooting.
I have updated the has_field_values from auto-list to search but there are still scanned queries hitting my presto cluster and also i can see feild type list in my database does this needs to be changed too? @flamber
@shadma You need to change to none or search like I wrote.
okay got it Thankss a lot again!! @flamber
A post was merged into an existing topic: Avoid Database sync