Creating Analytics Buckets

This feature is in Private Alpha. API stability and backward compatibility are not guaranteed at this stage. Request access through this form.

Analytics buckets use Apache Iceberg, an open-table format for efficient management of large analytical datasets. You can interact with analytics buckets using tools such as PyIceberg, Apache Spark, or any client supporting the Iceberg REST Catalog API.

Analytics Buckets are still available, but managed replication into Analytics Buckets through Supabase ETL is no longer supported. If you need managed replication today, use Database Replication with BigQuery. If you want to use Analytics Buckets, bring your own ingestion pipeline.

Creating an Analytics bucket

You can create an analytics bucket using either the Supabase SDK or the Supabase Dashboard.

Using the Supabase SDK

<Tabs scrollable size="small" type="underlined" defaultActiveId="javascript" queryGroup="language"

import { createClient } from '@supabase/supabase-js'

const supabase = createClient('https://your-project.supabase.co', 'your-service-key')

const { data, error } = await supabase.storage.analytics.createBucket('analytics-data')

if (error) {
  console.error('Failed to create analytics bucket:', error)
} else {
  console.log('Analytics bucket created:', data)
}

from supabase import create_client

supabase = create_client('https://your-project.supabase.co', 'your-service-key')

response = supabase.storage.analytics().create('analytics-data')

print('Analytics bucket created:', response)

Using the Supabase Dashboard

1. Navigate to the Storage section in the Supabase Dashboard.
2. Click Create Bucket.
3. Enter a name for your bucket (e.g., my-analytics-bucket).
4. Select Analytics Bucket as the bucket type.
5. Click Create.

Next steps

Once you've created your analytics bucket, you can:

• Connect with Iceberg clients like PyIceberg or Apache Spark
• Query data with Postgres using the Iceberg Foreign Data Wrapper