This connector is currently in development and requires approval for access.
Please contact us via Discord or email at
[email protected] to request access.
Getting Started
1
Create a Looker Studio Account
If you don’t already have one, sign up for a free account at Looker
Studio
2
Create a New Data Source
In Looker Studio, click on “Create” and then select “Data Source”. Scroll down
to the bottom and select “Build your own connector”. Enter the following
Deployment ID in the provided field:
AKfycbyCvuGqvABcfe46rvgGfCTDzbJuORX14LQcVkx1CHy4LPSEr9TNWTQ5EtIN_guUuACBpw
3
Configure the Connection
You’ll need your Chakra DB Session Key, which can be found in the settings
page.
4
Enter Your SQL Query
Enter the SQL query you want to use for your dashboard. For example:
SELECT * FROM duckdb.main.unicorn
5
Create Your Report
Once connected, you can create visualizations using your Chakra data. Looker
Studio will automatically detect field types and suggest appropriate
visualizations.
Advanced Configuration
Field Type Handling
The connector automatically detects field types based on your data:Data Type | Looker Studio Type | Notes |
---|---|---|
Numeric values | NUMBER | Automatically set as metrics |
Strings | TEXT | Set as dimensions |
Date strings (YYYY-MM-DD) | YEAR_MONTH_DAY | Properly formatted for time series |
Timestamps | YEAR_MONTH_DAY_SECOND | Full datetime support |
Booleans | BOOLEAN | Supports true/false filtering |
SQL Query Tips
For optimal performance with the connector:- Add LIMIT Clauses - For large datasets, add a LIMIT clause to your query
- Use Aggregations - Pre-aggregate data when possible using GROUP BY
- Optimize Joins - Keep joins simple for better performance
- Use WHERE Clauses - Filter data in your SQL rather than in Looker Studio
Using Filters
The connector supports Looker Studio’s filter controls. You can add filter widgets to your dashboard that will dynamically modify your SQL query.For optimal performance, only use filters on dimensions (not metrics) and
limit the number of filter controls to 3-5 per dashboard.
Troubleshooting
Common Issues
Issue | Solution |
---|---|
Authentication failed | Double-check your DB Session Key format |
Query failed | Verify your SQL syntax and table names |
No data returned | Check that your query returns data in the Worksheets section |
Date formatting issues | Ensure dates are in standard ISO format (YYYY-MM-DD) |
Slow performance | Add LIMIT clauses and optimize your query |