Links

Quick Start Guide

Make the first few minutes on Arctype count.

3-minute tutorial

Arctype allows you to make queries, and then connect these queries to complex internal tools. Here we will be going over how to make your first query in under a minute with a PostgreSQL database. We will then create a table, add data, and create a chart to visualize the data.

Getting started

Click Add Connection to create a new PostgreSQL connection. You'll need to enter your Postgres credentials.
Add a PostgreSQL Connection in Arctype
Click Test Connection and then Save!
Arctype will open in a new page. If your database doesn't have any tables yet, no tables will be shown in the left sidebar. Upload a CSV
Next, download a CSV into your database to create a new table. We have provided a CSV here, but you are free to create a new table and insert data yourself. For more information on that, check out Making a Query and Importing a CSV.
mlb_player_data.csv
45KB
Text
From the table list in the left sidebar (empty in this example), click ••• and select Import CSV to Table.
Import a CSV to create a table
Find the CSV file in the file selector and click Open. Arctype will display a preview of the CSV file. If the preview looks correct, click Accept :
Preview of the CSV data
Select the correct data types for each column and click Import CSV.
Columns will default to 'text', some columns may require different data types
Open Table Data
Because our CSV data is now stored in a PostgreSQL table, you can now view the data in Arctype's table view:
Spreadsheet view.
You can also view the data by opening the query editor and running the following query:
SELECT * FROM mlb_player_data;

Order Your Data

Congratulations! You made your first query with Arctype, possibly without typing a single command. Now, our data is a bit disorganized, so it won't look as good when we chart it. To fix this, we'll select the position column, averages of the height, weight, and age columns, and GROUP BY position so that it looks like:
SELECT
position,
AVG(height) AS avg_height,
AVG(weight) AS avg_weight,
AVG(age) AS avg_age
FROM
mlb_player_data
GROUP BY
position
You can also sort and filter your data in the table view with the Arctype sort and filter controls.

Turn Your Data Into a Chart

Now, our next step is to visualize this data. It looks alright as a table, but wouldn't it be much easier to understand as a chart?
To create a new chart:
  1. 1.
    Click the Chart button directly above the query results pane
  2. 2.
    In the ride sidebar, drag name to the x-axis
  3. 3.
    Then drag avg_height, avg_weight and avg_age to the y-axis

Add Chart To Dashboard

Now we have a good-looking chart, but we still need to save it for later. We can add it to a dashboard, where we can tie components like charts together and create stunning assortments of charts and tables to visualize and see changes in our data.
To Add the Chart to a Dashboard:
  1. 1.
    Click ••• directly above the query results pane, next to Chart
  2. 2.
    Click Create New Dashboard if you do not have any dashboards yet
  3. 3.
    Give your dashboard a title in the right sidebar to save it and find it easily later
There you go! You created a query and added your first chart to a dashboard. Check out the rest of our documentation to find out what other cool things you can do with Arctype, or join our Discord to get more help!