Create a New Dataset

Use these steps if you are a PostgreSQL administrator creating a new database, schema, and user for FDSA to connect to.

Important:

• FDSA only supports PostgreSQL databases.
• The maximum size supported for each schema/dataset is 500 MB.
• Do not use the root user’s credentials or the `public` schema when adding a data source in FDSA.

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:

1. Login as root user (or whatever admin user you have) to your database server
   
2. Create a new user (the one we are going to use to add the DB to FDSA)
   
   Note: The <username> and <password> used here are the ones required when adding a Data Source.
3. Give access to the new user
   
   
4. Exit and login with the new user:
   
   
5. As “<username>”, create the data source DB and switch to it.
   
   
6. Then create a schema/dataset and add your research data there:
   
   To ensure queries and joins work correctly in the Query Builder:
   – Add tables with their required columns.
   – Define primary keys on each table.
   – Configure foreign keys to represent relationships.
   – Add appropriate indexes to support performant joins.

What's Next

Next, go to FDSA → Connect Data to add this database as a data source and register your new dataset.