Connecting Data Sources
Connect Lucaro to your data warehouse or database to start building dashboards and analytics.
Supported Data Sources
Lucaro supports connections to all major data warehouses and databases:
Security Best Practices
- Create a dedicated read-only user for Lucaro connections
- Use encrypted connections (SSL/TLS) when available
- Limit access to only the schemas and tables needed for analytics
- Rotate credentials periodically according to your security policy
Adding a Data Source
- Navigate to your project and click Settings in the sidebar
- Select Data Sources from the settings menu
- Click Add Data Source and select your database type
- Enter your connection credentials and click Test Connection
- Once the connection is verified, click Save
Connection Configuration
Snowflake
Connect to Snowflake data warehouses
{
"account": "your-account.snowflakecomputing.com",
"user": "LUCARO_USER",
"password": "your-password",
"warehouse": "COMPUTE_WH",
"database": "ANALYTICS",
"schema": "PUBLIC"
}PostgreSQL
Connect to PostgreSQL databases
{
"host": "your-host.example.com",
"port": 5432,
"database": "analytics",
"user": "lucaro_read",
"password": "your-password",
"ssl": true
}BigQuery
Connect to Google BigQuery
{
"project_id": "your-gcp-project",
"credentials_json": "path/to/service-account.json",
"dataset": "analytics"
}Redshift
Connect to Amazon Redshift
{
"host": "cluster.region.redshift.amazonaws.com",
"port": 5439,
"database": "analytics",
"user": "lucaro_user",
"password": "your-password"
}MySQL
Connect to MySQL databases
{
"host": "your-host.example.com",
"port": 3306,
"database": "analytics",
"user": "lucaro_read",
"password": "your-password"
}API Configuration
You can also configure data sources via the API:
curl -X POST "https://api.lucaro.dev/v2/projects/{projectId}/integrations" \
-H "Authorization: Bearer YOUR_API_TOKEN" \
-H "Content-Type: application/json" \
-d '{
"type": "snowflake",
"name": "Production Warehouse",
"config": {
"account": "your-account.snowflakecomputing.com",
"user": "LUCARO_USER",
"password": "your-password",
"warehouse": "COMPUTE_WH",
"database": "ANALYTICS",
"schema": "PUBLIC"
}
}'Schema Discovery
After connecting, Lucaro automatically discovers your database schema including:
- Tables and views available in the connected schema
- Column names, types, and descriptions
- Primary keys and relationships
- Row counts and data statistics
This metadata powers intelligent features like auto-complete in the query editor and AI-suggested visualizations.
Troubleshooting
Connection Timeout
Ensure your database allows connections from Lucaro's IP addresses. For Lucaro Cloud, whitelist our static IPs listed in your project settings.
Authentication Failed
Verify your username and password are correct. Check that the user has appropriate permissions on the target database and schema.
SSL Certificate Error
If using self-signed certificates, you may need to provide the CA certificate in your connection configuration.