To connect TextQL with your Amazon Redshift database, you will need to gather the following connection details from your Redshift cluster:

  • Host URL and Port (default: 5439)
  • Database name and Schema
  • Username and Password with appropriate permissions
  • SSL configuration (if required)

​
Creating the Connector in TextQL

Navigate to the TextQL Connectors Page and click Create New Connector. Select Redshift from the available connectors to open the configuration form.

The form requires the following information:

  • Connector Name: A descriptive name to identify this specific Redshift connection in TextQL.
  • Host URL: The endpoint URL of your Redshift cluster.
  • Port: The port number for your Redshift connection (default is 5439).
  • User: Your Redshift username with appropriate query permissions.
  • Password: The corresponding password for your Redshift user.
  • Database: The name of your target Redshift database.
  • Schema: The schema name within your database.
  • Dialect: Choose between “Redshift” for native Redshift SQL or “Postgres” for PostgreSQL-compatible queries.

If your Redshift cluster requires SSL, the connection will automatically use SSL encryption for data transfer. This ensures secure communication between TextQL and your Redshift instance.

​
Testing the Connection

After entering your credentials, click Create to establish the connection. TextQL will validate your credentials and create the connector. If the connection fails, verify your credentials and ensure your Redshift cluster is accessible from TextQL’s IP address.

​
Next Steps

Once connected, you can use TextQL to query your Redshift data. The connector supports both Redshift’s native SQL dialect and PostgreSQL-compatible queries, allowing you to leverage the full capabilities of your Redshift cluster through TextQL’s interface.

For enhanced security and performance:

  • Use a dedicated Redshift user for TextQL connections
  • Configure appropriate resource limits in your Redshift cluster
  • Consider using SSL encryption for sensitive data
The Connectors PageSnowflake Connector