Quick Start Guide
Make the first few minutes on Arctype count.
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.
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.
SELECT * FROM mlb_player_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
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.Click the
Chart
button directly above the query results pane - 2.In the ride sidebar, drag
name
to the x-axis - 3.Then drag
avg_height
,avg_weight
andavg_age
to the y-axis

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.Click
•••
directly above the query results pane, next toChart
- 2.Click
Create New Dashboard
if you do not have any dashboards yet - 3.Give your dashboard a title in the right sidebar to save it and find it easily later
Last modified 1yr ago