Get to know ben_p with this User Highlight Learn More

DSS using Database

Level 3
DSS using Database

I went through the documentation and found that DSS is shipped with PostgresDB.

How can I find DSS is using which DB instance and what is the name of Database?

Or is it the case that database is not used in DSS?

0 Kudos
3 Replies
Dataiker
Dataiker

Hi,

DSS ships with the JDBC drivers for Postgres databases, not with an actual running Postgres database.

Regards,

     Frederic

Level 3
Author

Where does dss store its data, user /groups / project related info?

0 Kudos
Dataiker
Dataiker

Hi,

the storage for objects and settings of a DSS instance is mostly file-based. Some info, like which jobs and scenarios where run, and usage information, are stored in H2 databases with an option to store them in an external Postgres database.

The data of the datasets is stored on the server's filesystem for filesystem-type connections and for uploaded datasets. All the rest (SQL datasets, HDFS datasets, S3 datasets...) stays in their respective database/cluster/cloud.

Regards,

    Frederic