关闭雪花数据库日志记录，同时仍保持日志级别为调试

Question

是否可以禁用雪花SQL日志记录，该日志记录DB连接的开始和结束以及正在执行的所有查询，同时保留logging.basicConfig(level=logging.INFO)以调试我的开发。在

也许这不是雪花专用的，而是Python的一个通用DB连接？在

我使用的是snowflake-connector-python版本1.8.1

我目前有一个简化的日志示例。在

2019-06-10 16:27:10,015 INFO: /*Need this line*/

2019-06-10 16:27:10,015 INFO: Snowflake Connector for Python Version: 1.8.1, Python Version: 3.7.3, Platform: Windows-7-6.1.7601-SP1
2019-06-10 16:27:10,015 INFO: This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2019-06-10 16:27:10,020 INFO: Starting new HTTPS connection (1): xyz.snowflakecomputing.com
2019-06-10 16:27:11,227 INFO: query: [USE WAREHOUSE test_wh]
2019-06-10 16:27:11,481 INFO: query execution done
2019-06-10 16:27:11,481 INFO: query: [SELECT COLUMN_NAME FROM DB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG =...]
2019-06-10 16:27:12,830 INFO: query execution done
2019-06-10 16:27:12,830 INFO: fetching data done
2019-06-10 16:27:12,830 INFO: closed
2019-06-10 16:27:13,185 INFO: /*Need this line*/
2019-06-10 16:27:13,581 INFO: /*Need this line*/
2019-06-10 16:27:14,604 INFO: /*Need this line*/

Answer 1

在导入snowflake.connector的Python模块中，在调用连接器上的任何方法之前，添加

logging.getLogger('snowflake.connector').setLevel(logging.WARNING)

只记录警告或更高级别。在