Create a New Dataset

NOTE: FDSA only supports PostgreSQL Databases, and the maximum size supported for schemas/datasets is 500 MB.

When adding a data source in FDSA, avoid using the root user's credentials and refrain from saving datasets under the 'public' schema. Follow these instructions:

Login as root user (or whatever admin user you have) to your database server
```
psql -h <HOST IP/url> -p <PORT> -U <user> postgres
```
Create a new user (the one we are going to use to add the DB to FDSA)
```
CREATE USER <username> WITH PASSWORD '<password>';
```
Note: The <username> and <password> used here are the ones required when adding a Data Source.

Give access to the new user

ALTER USER <username> CREATEDB;

ALTER USER <username> CREATEROLE;

Exit and login with the new user:

\q

psql -h <HOST IP/url> -p <PORT> -U <username> postgres

As “<username>”, create the data source DB and switch to it.
```
CREATE DATABASE <test-database>;
```
```
\c <test-database>
```
Then create a schema/dataset and add your research data there:
```
CREATE SCHEMA <test-dataset>; 
```
IMPORTANT: Additionally, add tables with their respective columns, foreign keys, primary keys, and indexes in this schema, this is required to be able to execute queries/tasks with joins from the Query Builder Tool. The maximum size supported for schemas/datasets is 500 MB.

FDSA Resources

Create a New Dataset