Connect Soda to Trino
Last modified on 31-May-23
For Soda to run quality scans of your data, you must configure it to connect to your data source.
- For Soda Core, add the connection configurations to your
configuration.yml
file. Read more. - For Soda Cloud, add the connection configurations to step 3 of the New Data Source workflow. Read more.
Configuration
Install package: soda-core-trino
Reference Trino documentation for assistance.
data_source my_datasource_name:
type: trino
host:
port:
username:
password:
catalog:
schema:
Property | Required | Notes |
---|---|---|
type | required | |
host | required | |
port | optional | |
username | required | Consider using system variables to retrieve this value securely using, for example, ${TRINO_USER} . |
password | required | Consider using system variables to retrieve this value securely using, for example, ${TRINO_PASSWORD} . |
catalog | required | |
schema | required |
Test the data source connection
To confirm that you have correctly configured the connection details for the data source(s) in your configuration YAML file, use the test-connection
command. If you wish, add a -V
option to the command to returns results in verbose mode in the CLI.
soda test-connection -d my_datasource -c configuration.yml -V
Supported data types
Category | Data type |
---|---|
text | CHAR, VARCHAR |
number | NUMBER, INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT, FLOAT, FLOAT4, FLOAT8, DOUBLE, DOUBLE PRECISION, REAL |
time | DATE, DATETIME, TIME, TIMESTAMP, TIMESTAMPT_LTZ, TIMESTAMP_NTZ, TIMESTAMP_TZ |
Was this documentation helpful?
What could we do to improve this page?
- Suggest a docs change in GitHub.
- Share feedback in the Soda community on Slack.
Last modified on 31-May-23