Documentation

Everything you need to connect your Supabase database to Looker Studio and start building reports.

Getting Started

Prerequisites

  • A Supabase project with at least one table containing data.
  • A Looker Studio account (free with any Google account).
  • Your Supabase project URL and API key.

Finding Your Supabase Credentials

  1. Go to your Supabase Dashboard.
  2. Select your project.
  3. Navigate to Settings → API.
  4. Copy the Project URL (e.g., https://xyzcompany.supabase.co).
  5. Copy the anon public key (for public data) or the service_role key (for full access).

⚠️ Security note: The service_role key bypasses Row Level Security. Use it only if you need access to all rows regardless of RLS policies.

Connecting to Looker Studio

  1. Open Looker Studio.
  2. Click Create → Data Source.
  3. Search for "Supabase Connector" in the connector gallery.
  4. Authorize the connector when prompted.
  5. Enter your Supabase Project URL in the Path field.
  6. Enter your API Key in the Key field.
  7. Click Connect.

Configuration Options

Table Selection

After connecting, you'll see a dropdown listing all tables and views in your Supabase project. Select the one you want to visualize.

Date Range Filtering

Enable the "Enable Date Range Filter" checkbox to allow Looker Studio's date picker to filter your data. Then specify the date column name (e.g., created_at, updated_at).

Custom PostgREST Filters

You can add custom filters using PostgREST syntax. Examples:

status=eq.active
age=gte.18
name=like.*John*
category=in.(electronics,books)

See the PostgREST documentation for the full filter syntax.

Schema & Type Mapping

The connector automatically maps PostgreSQL column types to Looker Studio field types:

PostgreSQL Type Looker Studio Type Field Type
text, varchar, char Text Dimension
int, bigint, float, numeric Number Metric
boolean Boolean Dimension
date Date (YYYYMMDD) Dimension
timestamp, timestamptz Date & Time Dimension
uuid, json, jsonb Text Dimension

Data Caching

The connector caches data to improve performance and reduce API calls to your Supabase project:

  • Free tier: Data is cached for 24 hours.
  • Pro / Enterprise: Data is cached for 1 hour (minimum).

To force a data refresh in Looker Studio, right-click on any chart and select "Refresh data".

Troubleshooting

"Invalid Credentials" Error

  • Verify your project URL format: https://<project-ref>.supabase.co (no trailing slash).
  • Ensure you're using a valid API key from Settings → API in the Supabase dashboard.
  • Check that your Supabase project is active and not paused.

"Failed to Fetch Tables" Error

  • Your API key might not have permissions to access the PostgREST endpoint.
  • If using the anon key, ensure your tables have appropriate RLS policies or are public.

Missing Columns or Tables

  • Tables must be exposed via the Supabase API (check Database → Tables in your dashboard).
  • Columns with custom PostgreSQL types may appear as Text dimensions.

Data Limits

  • Free tier: 100 rows per query, 3 tables maximum.
  • If you need more, upgrade to Pro.

Support

Need help? Here's how to reach us: