I want to stop auto scanning for tables in metabase

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?

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": [
"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 :+1: 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