PostgreSQL (Beta)
How to set up our PostgreSQL Imports + Deployments.
Last updated
Was this helpful?
How to set up our PostgreSQL Imports + Deployments.
Last updated
Was this helpful?
PostgreSQL support is currently in beta. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.
Our PostgreSQL integration allows you to import your data, allowing you to clean and transform your data as well as ask it questions via Chat Explore. When ready, you can then deploy models trained on PostgreSQL data, allowing you to make predictions off of data still in your PostgreSQL database.
You must allow network traffic from the public IP address 54.197.189.139 in order to allow Akkio to access your data.
To import data, first create a new project.
Select the PostgreSQL button.
Click "Connect Dataset" to add a new dataset.
Enter connection details for your PostgreSQL integration:
Select Continue, then select a schema from the pulldown:
Select Continue, then select a table from the pulldown:
Make sure your security settings allow us to connect to your database. You'll need to add our IP Address, 54.197.189.139, to your security settings so that we can connect and pull your data in.
To pull in your data, input the following:
Hostname: The hostname of your PostgreSQL instance (this looks like the URL).
Database / Schema Name: The name of the database within your PostgreSQL instance that your table is inside. NOTE: a database instance holds multiple databases or schemas, and each database or schema holds multiple tables.
Username/Password: Credentials for the database user to authenticate. This user must have read permissions for a table to import and write permissions to deploy.
Port: The port we should use to connect to your database. This is generally 5432 but should be verified.
Table Name: The name of the table to pull from.
When complete, hit Continue and Akkio will then validate the connection and begin the import process.
If we're successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.
You may need to wait for a little bit for the data to import. Rest assured that we're importing data behind the scenes. Small datasets should only take a few minutes; large datasets may take longer.
Once your data is done importing, you'll see it populate onto the screen.
From here, you can do anything you like to the data - clean and transform it on the Prepare tab, ask Chat Explore questions on the Explore tab, you name it!
