Introduction
Outerbase is an AI-powered data tool, that let’s you view, edit, query, and visualize your data collaboratively with your team.
In this tutorial we will cover two different ways to get started quickly with Outerbase.
-
Connecting to your database
Bring your own database and start analyzing it with Outerbase.
-
Uploading a CSV
Don’t have a database? That’s fine upload a CSV and get started.
Before we get started
To make the most of thisy tutorial you will need:
-
An Outerbase account
-
A supported* database or a CSV file
*Outerbase supports Postgres, MySQL, SQLite, ClickHouse, Microsoft SQL Server, MongoDB, Snowflake, Google BigQuery, Amazon Redshift, with more coming soon!
Connecting to your database
There are a few different ways you can connect to a database in Outerbase. You can use the connection parameters, the connection string, or if you’re using one of our partner providers you can simply authenticate into your account.
Using Connection Parameters
After ensuring you are connecting to a supported database type you’ll want to grab your credentials. Check out our guides on where you can find those for popular cloud providers.
-
First you will want to sign into your Outerbase account and click on the
New Base
button. -
Next you will choose your database type. If you can’t find your database, please let us know, and we will look into adding support for it.
-
Now you will need to add in your connection parameters. Pay close attention and make sure you are adding in the correct parameter into each input. The order is database name, host, port, username, password, and then an optional allowlisting option.
4. Now click
Connect to Database
and give your new base a name, this is the name that everyone in the workspace will use to reference your database. -
That’s it you’re done, congratulations! Now it’s time for all the fun stuff.