Overview
The Database Connections allow us to use SQL queries to retrieve data, and subsequently use that data for natural language processing with TableUnderstanding or TablePrep.
IBM DB2
{{ db2|query:"your db2 query" | DATABASE: "" | HOSTNAME: "" | UID: "" | PWD: "" | PORT: "" | SECURE: "true" | sentences: "true"}}
Parameters
- Query: The SQL query to pass to DB2. Double quotes must be escaped \" \" to pass through to DB2.
- DATABASE: The database name.
- HOSTNAME: The hostname of the DB2 instance.
- UID: The user ID to use for authentication.
- PWD: The user password for authentication.
- PORT: The port number.
- SECURE: Set to true or false depending on the use of SSL.
- Sentences: To return the query response in tabular format, set this to false. To return the response in natural language, set this to true.
Returns
- If Sentences is set to true, returns results in natural language description similar to TablePrep.
- If Sentences is set to false, returns the query response in tabular format.
MySQL / Others
{{ postgres | query:"" | uri: "" | sentences: "true" | rds: "false"}}
{{ mariadb | query:"" | uri: "" | sentences: "true"}}
{{ mysql | query:"" | uri: "" | sentences: "true"}}
{{ mssql | query:"" | uri: "" | sentences: "true"}}
{{ oracle | query:"" | uri: "" | sentences: "true"}}
{{ redshift | query:"" | uri: "" | sentences: "true"}}
Parameters
- Query: The SQL query to use. Double quotes must be escaped \" \" to pass through.
- URI: The connection URI. The preceding "mysql://" is not required.
- Sentences: To return the query response in tabular format, set this to false. To return the response in natural language, set this to true.
- RDS: For Postgres only - Only enable this if using RDS Proxy in front of Postgres.
Returns
- If Sentences is set to true, returns results in natural language description similar to TablePrep.
- If Sentences is set to false, returns the query response in tabular format.