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 to create a new
PostgreSQL connection. You'll need to enter your Postgres credentials.
Test Connection and then
You will be redirected to a new tab. 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
••• and select
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
Select the correct data types for each column and click
Open Table Data
Because our CSV data is now stored in a PostgreSQL table, you can now view the data in Arctype's spreadsheet view:
You can also view the data by opening the query editor and running the following query:
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
age columns, and
GROUP BY position so that it looks like:
SELECTposition,AVG(height) AS avg_height,AVG(weight) AS avg_weight,AVG(age) AS avg_ageFROMmlb_player_dataGROUP BYposition
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:
Chart button directly above the query results pane
In the ride sidebar, drag
name to the x-axis
avg_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:
••• directly above the query results pane, next to
Create New Dashboard if you do not have any dashboards yet
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.