Publish as a Database (DB)

The Publish as a DB function lets you publish your View as a table on Mammoth managed database server. This function eliminates the need of having a dedicated self-hosted Database to host your transformed data.

Quick Start

You can publish your current View with just a click. Here’s how:

1. Login to your Data Library.

2. Navigate to the Dataset>View you want to publish.

3. Click on the “Publish as a DB” button on the taskbar.

Publish as a DB button in your View

1. A dialog box will appear with the default Data Server (PostgreSQL) and an option to change your Table’s name.

2. Click Publish to publish your View as a DB.

Publishing a View as a Data Source

Note

The system only allows unique Table names. You will get a prompt to choose a different Table name if the Database already has a table with the same name.

Once your View is published on the server, you will receive credentials to access the published database.

Credentials for the published table

Further, Publish as a DB will also be recorded as a task at the end of the Data Pipeline.

Publish as a DB task appears in the Pipeline

Supported Options

• Show credentials: This displays credentials to access the published table.

• Regenerate password: Generates a new password. Make sure to re-authenticate connected applications once you do this.

Connect third-party apps after regenerating database password

• Run now: This option syncs all Pipeline modifications to the published table.

• Delete: This removes the Publish as a DB task from the Data Pipeline as well as the table from the database server.

Note

1. There can be only one Publish to DB in a view.

2. Users have read-only access to the database and the tables.

3. Mammoth maintains a table named reference_table in the same database. Mammoth maintains a list of all published views and tables in this. Use this for quick reference of all published views.

4. For each user, there exists a unique database.