Set up connection
Set up connection to your data sources to get started
Looking for our new Data Plane experience for connecting your data?
Connect to your data sources
- Navigate to the Connect application using the side navigation bar.
- Select your data source type.
Postgres
Postgres
To connect to a Postgres database, you’ll need:
- Host: The server address of the Postgres instance.
- Port: The port number where Postgres is running (default: 5432).
- Database Name: The specific Postgres database to connect to.
- User: The Postgres username.
- Password: The corresponding password for the user.
- Pool Size (optional): Number of active connections to maintain (default: 10).
- Concurrency Limit (optional): Maximum number of concurrent queries.
- Interval Limit (optional): Maximum number of operations in a time interval.
- Interval Time (optional): Time interval in milliseconds (e.g., 1000 ms for 1 second).
- Row-level-security (RLS) variable (optional): Variable name used in RLS policies (recommended: “app”).
- Default row-level-security (RLS) value (optional): Default user value applied to RLS policies when in the Upsolve Hub.
Note on RLS: When using row-level security, ensure the database user for connection is not a superadmin, as RLS policies are bypassed by superusers.
Clickhouse
Clickhouse
To connect to Clickhouse, you’ll need:
- Host: The Clickhouse server address (e.g.,
https://clickhouse-host
). - Port: The port number (default: 8443 for HTTPS connections).
- User: The Clickhouse username.
- Password: The corresponding password for the user.
- Database Name: The Clickhouse database to connect to.
- Concurrency Limit (optional): Maximum number of simultaneous queries.
- Interval Limit (optional): Maximum operations allowed during a time interval.
- Interval Time (optional): Time interval in milliseconds.
Snowflake 🔒
Snowflake 🔒
To connect to Snowflake, you’ll need:
- Account: The Snowflake account identifier (e.g.,
account_name.region.cloud_provider
). - User: Your Snowflake username.
- Password: Your Snowflake password.
- Database Name: The specific Snowflake database to connect to.
MySQL 🔒
MySQL 🔒
To connect to a MySQL database:
- Host: The MySQL server address.
- Port: The port number (default: 3306).
- Database Name: The MySQL database to connect to.
- User: The MySQL username.
- Password: The password for the user.
MS SQL 🔒
MS SQL 🔒
To connect to Microsoft SQL Server:
- Host: The MS SQL server address.
- Port: The port number (default: 1433).
- Database Name: The MS SQL database to connect to.
- User: The MS SQL username.
- Password: The corresponding password for the user.
DynamoDB 🔒
DynamoDB 🔒
For AWS DynamoDB:
- Region: The AWS region where DynamoDB is hosted (e.g.,
us-east-1
). - AWS Access Key: The access key from your AWS IAM user.
- AWS Secret Key: The secret key from your AWS IAM user.
Redshift 🔒
Redshift 🔒
To connect to Amazon Redshift:
- Host: The Redshift cluster endpoint.
- Port: The port number (default: 5439).
- Database Name: The Redshift database to connect to.
- User: The Redshift username.
- Password: The password for the user.
Timescale 🔒
Timescale 🔒
To connect to TimescaleDB (Postgres with time-series capabilities):
- Host: The server address where Timescale is running.
- Port: The port number (default: 5432).
- Database Name: The Timescale/Postgres database to connect to.
- User: The database username.
- Password: The password for the user.
Supabase 🔒
Supabase 🔒
To connect to Supabase, use the following credentials and configuration steps:
-
Create the
execute_raw_sql
Function: To enable secure execution of SQL queries, run the following SQL in your Supabase SQL editor: -
Set Up Credentials in Upsolve Hub: Use the following details to connect to your Supabase instance:
- URL: The unique URL of your Supabase instance.
- Anon Key: The public API key for accessing Supabase.
- Service Key: The secret API key for accessing Supabase.
You can find these details in your Supabase API settings.
For enterprise features, look for the 🔒 symbol. These features are available in our Enterprise plan. Please contact us for more information.
- Input the corresponding credentials for the data source.
- Click Save to see if connection is set up successfully.
You are now good to go to start building charts and creating dashboards. If you do not see the data source type you want to connect to in the Connect application, please raise a support ticket.