Retool Database
Adding Test Data
Because the aim of our app is to display player records from a data source. Retool has a wide range of integrations but for this example, we will use their managed database for demonstration.. Specifically we will use their in-built Retool managed PostgreSQL database as our source.
Later on we will look at how we can integrate Retool with external databases in order to import real player data.
We will need to create a new database table .
Start by going to the Retool “root” menu at the top left corner of the dashboard. Select “Database” from the drop-down here. This should open a new tab in your browser.
Each table here is listed via tab. As you have created a new account, you should not see any tables here so you can instead click on the (+) tab to add a new table. Name this table “players”.
For this example we will add the following fields to the table:
- player_id <UUID>
- player_name <Text>
- player_email <Text>
- created_date <Date + Time>
- last_login <Date + Time>
- access_type <Enum>
- level <Number>
- xp <Number>
- data <JSON>
Note
Not all of these fields will be needed for searching or listing players but we will use these fields later for editing player details.
Uploading to Retool
For this example we are going to need to add some test players to our table so we can play around with listing, filtering and searching for player-data in order to ensure it all works correctly later. We will also come back to editing player data in the next section.
Data can be added manually by individual rows or bulk imported from CSV.
The link below will download a ‘retool_demo_data.csv’ file.
Select ‘Import CSV -> Into a new table’ and drag the demo data into it.
First, rename the table to ‘players’, then remove the types from the field names.
Set the field types for each column and click ‘Create Table’.
Note, it is possible to use the player UUID as a primary key on import, but for the purpose of this tutorial we will let Retool handle this.
Summary
Now we have our test data uploaded to Retool.
From here you need to use queries to access the data.