Looker Studio

Visualize your Birkini data through interactive dashboards in Looker Studio.

ℹ️ This connector is currently in development and requires approval for access. Please contact us via Discord or email at [e-mail] to request access.

Birkini’s Looker Studio connector enables you to build rich visualizations and dashboards by connecting your warehouse data directly within Google Looker Studio.

1

Create a Looker Studio Account

If you don’t have one yet, sign up for a free account at Looker Studio.

2

Add a New Data Source

In Looker Studio, click on Create, then select Data Source. Scroll to the bottom and choose Build your own connector. Paste the following Deployment ID into the field provided:

AFkycbyCvuGqvABcFe46rvgGfCTDZbJuORX14LQcVkx1CHy4LPSER9TNWTQ5EtIN_guUuACBpw

3

Set Up the Connection

You’ll need your Birkini DB Session Key, which you can find in the settings page.

4

Write Your SQL Query

Input the SQL query you'd like to use for your report. For example:

SELECT * FROM duckdb.main.unicorn

5

Build Your Report

After connecting, you can build interactive dashboards using your Birkini data. Looker Studio will detect data types automatically and suggest matching visualizations.

Custom Configuration

Field Recognition The connector intelligently identifies field types based on the structure of your dataset.

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 Best Practices

To ensure strong performance when using the connector:

• Limit your results: For large datasets, always include a LIMIT clause in your query

• Aggregate early: Summarize your data with GROUP BY before sending it to Looker Studio

• Simplify joins: Keep joins minimal to reduce processing overhead

• Filter at the source: Use WHERE clauses in your SQL to reduce the amount of data returned

Example optimized query:

SELECT
  date_trunc('month', created_at) AS month,
  category,
  SUM(revenue) AS total_revenue,
  COUNT(DISTINCT user_id) AS unique_users
FROM sales
WHERE created_at > '2023-01-01'
GROUP BY 1, 2
ORDER BY 1 DESC
LIMIT 5000;

Using Filters

Looker Studio supports interactive filters that update your SQL queries dynamically. To get the best performance:

• Apply filters to dimensions only, not metrics

• Limit your dashboard to no more than five filter controls

Troubleshooting

Issue	Recommended Action
Authentication failed	Confirm your DB Session Key is entered correctly
Query did not run	Double-check SQL syntax and table names
No results returned	Verify that the query returns rows in the Worksheets section
Incorrect date formatting	Ensure your dates follow the YYYY-MM-DD ISO format
Slow query performance	Use LIMIT and optimize joins or filters