The Connectors Page is where technical users can manage the data-sources available to Ana. The Connectors Page facilitates:Documentation Index
Fetch the complete documentation index at: https://docs.textql.com/llms.txt
Use this file to discover all available pages before exploring further.
- Adding new connectors,
- Previewing tables and assets previously connected to TextQL, and
- Resyncing connectors after schema drift.
Permissions
Actions on the Connectors Page are gated by theconnector:write permission. Users without this permission can still view and use connectors, but the following actions will be hidden or disabled:
| Action | Requires connector:write |
|---|---|
| Create a new connector | Yes |
| Edit a connector | Yes |
| Delete a connector | Yes |
| Duplicate a connector | Yes |
| Manage Access | Yes |
| Open / Connect (per-member OAuth) | No — available to all users |
connector:write on public connectors. Admins always have full access. See Role-Based Access Control for details on configuring connector permissions.
Supported Datasources and Connectors
Structured Data Connectors
TextQL supports the following Data Warehouse connectors:- Amazon Redshift
- Amazon Aurora - MySQL and PostgreSQL compatible
- Snowflake
- BigQuery
- Azure Synapse Analytics
- PostgreSQL
- Supabase
- MySQL
- ClickHouse
- AWS Athena
- Databricks
BI Tools and Dashboards
Currently, the following BI tools are supported:Adding New Connectors
To add an additional connector for your organization, first, navigate to the Connectors Page and select New Connector. Then select your desired data source from the form that appears.The New Connector button is only visible to users with the
connector:write permission.
Setup Guides
For detailed step-by-step instructions on setting up specific connectors:- PostgreSQL Connector Setup - Connect to PostgreSQL databases
- Amazon Aurora Connector Setup - Connect to Aurora MySQL or PostgreSQL
- Azure Synapse Analytics Connector Setup - Connect to Azure Synapse workspaces
- Network Configuration Guide - Configure firewall rules for all database providers
Network Configuration
Most database connectors require whitelisting TextQL’s IP addresses in your firewall or security group settings. See the Network Configuration Guide for detailed instructions for:- AWS (RDS, Aurora, Redshift)
- Azure (Synapse, SQL Database, PostgreSQL)
- Google Cloud (BigQuery, Cloud SQL)
- Databricks
- Other providers
VPC and Private Deployments: IP whitelisting does not apply to VPC, on-premises, or single-tenant deployments. Contact your TextQL representative for custom deployment network requirements.
Questions and Troubleshooting
If you have questions after reading the documentation:- Check the Network Configuration Guide for firewall setup
- Review connector-specific troubleshooting sections
- Contact us via Slack or email: support@textql.com
Related Documentation
- Salesforce Integration - Connect to Salesforce