Supabase is now available on Sourcetable
Today, we're excited to announce that Supabase is now available as a data integration on Sourcetable. This means that Supabase users can access their database data live inside Sourcetable, and use Sourcetable as their reporting and analysis solution.
TL;DR: if you're considering using Tableau or PowerBI, your operations team will love you if you chose to connect your Supabase data to Sourcetable instead.
For the uninitiated, Supabase is an open-source, real-time PostgreSQL database. It is wildly popular and used by over 40% of companies in the latest batch of YCombinator, the no.1 startup accelerator in the world. Companies use Supabase as their storage solution and to handle things like Authentication, instant APIs, Edge Functions, Realtime subscriptions and Vector embeddings.
If you don't know what any of that means, don't worry. All you need to know is that Supabase is a popular and successful database used by many of the most successful new startups in Silicon Valley. The people who setup and use Supabase are developers who know how to code. For everybody else on the team who needs to access that data in order to do their job, that's where Sourcetable comes in.
Sourcetable's Supabase connector allows non-technical team members to access their Supabase data directly in an Excel-style spreadsheet. No-code is required for setup, and Sourcetable users can access their data in one of three ways:
- First: Users can click on the data fields they want in our GUI, and that data will be available in Sourcetable. (e.g. users, purchases, product data, etc.).
- Second: Users can ask Sourcetable's AI to retrieve relevant data, or analyze it for them. Requests are made using natural language and Sourcetable validates responses to ensure that answers are accurate and hallucination-free.
- Third: Technical users can write SQL directly against their Supabase data inside Sourcetable. SQL-generated reports can be modified by non-technical users later using Sourcetable's GUI.
The most common use case is reporting, typical by operations folk who need to build daily and weekly reports; because data integrations stay synced in Sourcetable, all reports built using Sourcetable automatically stay up to date. Sourcetable has has all the charts and graphs you might need, and more advanced users will enjoy an AI-to-plotly interface.
The second most popular use case is analysis; commonly there is a question about the business that needs answering in order to make decisions, and having easy access to data is critical to getting fast and accurate answers. This Business Intelligence use case compares Sourcetable against Tableau and PowerBI, with the distinct advantages in ease of use, and the familiarity of our Excel-style spreadsheet interface, with all the formulas, functions, pivots and formatting that regular spreadsheet users enjoy. Sourcetable's AI functionality also provides opportunities for asking analysis questions of a Supabase database directly.
To use Supabase in Sourcetable, just sign up and go to the integrations tab. You will need to give Sourcetable permission to access your Supabase database using the database credentials provided in your Supabase dashboard. You will also need to ensure that the IPV4 addon is turned on inside Supabase ($4/month) so that read-replicas are enabled before adding your Supabase integration to Sourcetable.
Once done, you can access Supabase inside Sourcetable and start asking questions of your data. You can also join your data with any of the 100+ integrations available on Sourcetable for cross-channel reporting. Alternatively, if you are an engineer reading this blog post, by giving your business team (read-only) access to your Supabase data inside Sourcetable, they can now self-serve their data queries and leave you alone so you can focus on writing code.
Finally, if you're new to Sourcetable, all accounts receive a 14-day free trial.
Enjoy!