Visualize your Chakra data in Looker Studio dashboards
Create a Looker Studio Account
Create a New Data Source
AKfycbyCvuGqvABcfe46rvgGfCTDzbJuORX14LQcVkx1CHy4LPSEr9TNWTQ5EtIN_guUuACBpw
Configure the Connection
Enter Your SQL Query
SELECT * FROM duckdb.main.unicorn
Create Your Report
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 |
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 |