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.
Add Connectionto create a new
PostgreSQLconnection. You'll need to enter your Postgres credentials.
Add a PostgreSQL Connection in Arctype
Test Connectionand then
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.
From the table list in the left sidebar (empty in this example), click
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
Preview of the CSV data
Select the correct data types for each column and click
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:
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
positioncolumn, averages of the
GROUP BY positionso that it looks like:
AVG(height) AS avg_height,
AVG(weight) AS avg_weight,
AVG(age) AS avg_age
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
Chartbutton directly above the query results pane
- 2.In the ride sidebar, drag
nameto the x-axis
- 3.Then drag
avg_ageto 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:
•••directly above the query results pane, next to
Create New Dashboardif 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