{"id":24612,"library":"soda-core-trino","title":"Soda Core Trino","description":"Soda Core Trino is an extension of Soda Core that integrates with Trino/Presto databases for data quality testing. It allows users to define and run checks (e.g., missing values, duplicates, schema changes) using SodaCL. Version 3.5.6 is the latest release. Release cadence is irregular, typically following Soda Core releases.","status":"active","version":"3.5.6","language":"python","source_language":"en","source_url":"https://github.com/sodadata/soda-core","tags":["data-quality","testing","trino","presto","soda"],"install":[{"cmd":"pip install soda-core-trino","lang":"bash","label":"Install Soda Core Trino"}],"dependencies":[{"reason":"Core library required for Soda checks","package":"soda-core","optional":false},{"reason":"Trino/Presto Python client","package":"trino","optional":false}],"imports":[{"wrong":"from soda.scan import Scan","symbol":"Scan","correct":"from soda.scan import Scan"}],"quickstart":{"code":"from soda.scan import Scan\n\nscan = Scan()\nscan.set_scan_definition_name('test')\nscan.set_data_source_name('my_trino')\nscan.add_configuration_yaml_str(f'''\ndata_source my_trino:\n  type: trino\n  host: {os.environ.get('TRINO_HOST', 'localhost')}\n  port: {os.environ.get('TRINO_PORT', '8080')}\n  catalog: {os.environ.get('TRINO_CATALOG', 'tpch')}\n  schema: {os.environ.get('TRINO_SCHEMA', 'sf1')}\n  username: {os.environ.get('TRINO_USER', 'admin')}\n  password: {os.environ.get('TRINO_PASSWORD', '')}\n''')\nscan.add_sodacl_yaml_str('''\nchecks for orders:\n  - row_count > 0\n''')\nscan.execute()\nprint(scan.get_logs_text())","lang":"python","description":"Basic Soda scan against Trino with authentication from environment variables."},"warnings":[{"fix":"Use Scan object with configuration YAML or dictionary instead of importing data source classes directly.","message":"In Soda Core 3.x, the API changed significantly from 2.x. The Scan object replaced the old SodaServerClient. Direct imports of data source classes are deprecated.","severity":"breaking","affected_versions":">=3.0.0"},{"fix":"Add 'verify: false' under the data source configuration or set environment variable SODA_VERIFY=false.","message":"Trino password authentication requires SSL/TLS by default; if your cluster doesn't use SSL, set 'verify' to False in the config.","severity":"gotcha","affected_versions":"all"},{"fix":"Verify network connectivity with a simple trino client test before using Soda.","message":"The Trino host and port must be reachable from the environment where Soda runs; connection errors often stem from network/firewall issues.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"search_vec":"'3.5.6':39 'allow':23 'cadenc':45 'chang':35 'check':29 'core':2,5,12,51 'data':19,54 'data-qu':53 'databas':17 'defin':26 'duplic':33 'e.g':30 'extens':9 'follow':49 'integr':14 'irregular':47 'latest':42 'miss':31 'presto':58 'qualiti':20,55 'releas':43,44,52 'run':28 'schema':34 'soda':1,4,11,50,59 'sodacl':37 'test':21,56 'trino':3,6,57 'trino/presto':16 'typic':48 'use':36 'user':24 'valu':32 'version':38","created_at":"2026-05-01T08:14:00.411816+00:00","updated_at":"2026-05-01T08:14:00.411816+00:00","problems":{"verify_error":"Traceback (most recent call last):\n  File \"<string>\", line 1, in <module>\n  File \"/tmp/tmpugtlj12b/venv/lib/python3.12/site-packages/soda/scan.py\", line 12, in <module>\n    from soda.common.env_helper import EnvHelper\n  File \"/tmp/tmpugtlj12b/venv/lib/python3.12/site-packages/soda/common/env_helper."},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"3.5.6","cli_name":"soda","cli_version":"soda-core, version 3.5.6","type":"library","homepage":"https://www.soda.io","github":null,"docs":null,"changelog":null,"pypi":"https://pypi.org/project/soda-core-trino/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["data","database","testing"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"import_fail","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-07-10","install_tag":null}}