RedShift

A fully managed cloud data warehouse that allows organizations to store and analyze large volumes of structured data

Supported Connection Methods

• Direct

The default / typical connection option. Interfaces directly with the target system over the Internet with no mediation. Suitable for most cloud-hosted scenarios or public-facing resources. See Network Configuration for more details.

Supported Limits

• Duration Limit

An alternative to cost, queries will be stopped the system supports a duration/timeout limit and one is set/configured at the organization level (across systems).

Available Parameters

These properties are the essential source system connection properties that all queries are directed towards.

These properties are the essential source system connection properties that all queries are directed towards.

* Required parameters

Host*

Domain or IP of the database to allow a connection to Lumi AI.

👍 Valid Examples

• Domain name: docs.lumi-ai.com

• IPv4: 55.88.92.101

👎 Invalid Examples

• IPv4 with alphanumeric characters: 123.abc.def.456

• Incomplete domain name resolutions: lumi-ai.com

Port*

Access port to allow for connections to the database.

👍 Valid Examples

• Default PostgreSQL port: 5432

👎 Invalid Examples

• Known Port Numbers (0-1023): 80

Username*

Username of the generated database user which will be used for interactions and transactions.

Special Considerations

• If double quotes are used, then the name will be case sensitive

👍 Valid Examples

• Uses alphanumeric characters : lumi1

• Utilizing underscore (_) in place of spaces: user_number

👎 Invalid Examples

• Starting with a number: 1lumi

• Utilizing spaces: user name

• Using invalid characters: user#1

Password*

Password of the generated database user which will be used for interactions and transactions.

Database*

Literal database name that will be used for transactions within the agents.

Special Considerations

• If case sensitivity is required, utilize double quotes for database name; ex. "New_database"

👍 Valid Examples

• Uses alphanumeric characters: lumi1

• Utilizing underscore (_) in place of spaces: new_database

👎 Invalid Examples

• Starting with a number: 1lumi

• Utilizing spaces: user name

• Using reserved words unquoted: select

System Permissions & Configuration

Provided user must have the following:

• ROLE with LOGIN privileges

• PRIVILEGE to CONNECT on database

• PRIVILEGE to USAGE on schema

*Note — To ensure every schema can be accessed, please run the following code command:

GRANT USAGE ON SCHEMA <schema> TO <user>;

• SELECT PRIVILEGE in table(s)

*Note — To ensure every table can be accessed, please run the following code command:

GRANT USAGE ON SCHEMA <schema>.<table> TO <user>;

• (if applicable) SELECT PRIVILEGE on table(s) for column(s)

For configurations:

• Ensure the server is allowing connections from the Lumi gateway or server

Special Considerations

• Special characters and case sensitivity can be utilized in database names and usernames via encasing the name in double quotes (" "), but is not recommended

Common Issue

• Ensure the firewall settings allow for a connection to a database