Create test data

Create a data source and a dataset inside test database

It is necessary to define the data that you are going to insert and the schema that you are going to provide to make possible the creation of the data source/dataset.

• Copy data file

docker cp <file_path> fdsa_db:/home/data.csv

• Login to the local database "PGDATABASE and PGUSER can be read in the .env file"

docker exec -it fdsa_db bash

cd /home

psql -d <PGDATABASE> -U <PGUSER>

• Create database and a schema

create database <database_name>;

\c <database_name>

create schema <schema_name>;

• Now create the table with the schema definition.

create table <schema_name>.<table_name>(

...

);

• Copy the data into the table        

\copy <schema_name>.<table_name> from '/home/data.csv' WITH DELIMITER ',' csv;

• Now use the fdsa admin GUI to add the data source and dataset