This guide shows how to analyze the data in your Supabase Postgres database in Deepnote. We configure an integration that allows you to query the data and use them in an analysis or an automation workflow.
Supabase is an open source Firebase alternative. Start your project with a Postgres Database, Authentication, instant APIs, Realtime subscriptions and Storage.
Go to supabase.com and create a free account, and start a new project.
You will need the connections details for the database: host, database, port, user and password. You can find them in the settings of your Supabase project, in the Database section.
Open Integrations in the left side bar, and select the Postgres integration. You will be prompted for the credentials from the previous step.
When you create a new project, navigate to Integrations in the right side bar, and connect your database. This will allow you to:
- Insert and execute SQL blocks in your notebook
- Browse the schema
You can ask analytical questions about your data and leverage the entire Python ecosystem. Visualize things like cumulative user count, or the popularity of various authentication providers. Create charts, forecasts or dashboards and organize them in your data workspace.
When you want to share the results or get some feedback, easily share your Deepnote projects with your colleagues or friends. Get their comments, or get some technical help with your code.
Automate your work by scheduling notebooks. Create a simple ETL pipeline, or run a periodic clean up job.