ESAP-DB: a managed database

ESAP-DB is an ESAP component providing managed database services.

In order to use ESAP-DB in Python, a client needs to be instantiated:

Creation of a project

A project defines a scope, in which collections of tables can be created. Let's create our first project:

Creation of a dataset

In this project, let's create a dataset, i.e., a group of tables:

We can check that the dataset has been created inside our project:

Creation of a table from a Pandas DataFrame

Pandas DataFrames can be used as a data source.

We can check that the table has been added to the dataset

The tables in a dataset can be accessed

The object table does not hold any data, it is a proxy object to an actual database table. To download it as a Pandas dataframe:

Creation of a table from an external resource

External CSV files can be imported into a table:

Creation of a table from a query

Inside the same project, the tables from different datasets can be combined in a query.

Creation of a table from an ESAP ESFRI query

We can store the result of an ESAP-API query into a table that belongs to the dataset that we have just created.

Creation of a table from a TAP query

All the TAP services can be access through ESAP-DB. Queries can be stored as a table in a user's dataset.

A VO table is referenced in ESAP-DB by tap_service.schema_name.table_name.