Link Search Menu Expand Document

Connecting to a Data Store

  • Time required: 5 minutes

Prerequisites


Introduction

By default, every workspace is backed by a PostgreSQL database managed by Matatika. This is set as the default data store for the workspace.

Changing the default data store of a workspace will change where data is loaded into by data imports and queried from by datasets.


Connecting to a data store

Matatika supports connecting to a number of data stores, such as PostgreSQL and Snowflake.

  1. Within the Matatika app, switch to the workspace that you wish to set an alternate data store for
  2. Navigate to the workspace ‘Data Stores’ page
  3. Click ‘Add’, select your preferred data store and click ‘Connect’
  4. Enter the relevant credentials and other properties for the selected data store
  5. Click ‘Save’ and then navigate back to the ‘Data Stores’ page
  6. Locate the data store you wish to set as default, click the ‘More’ context menu button, and then select ‘Make default’
    • Once a data store is set the default for a workspace, it cannot be deleted until another data store is made the default

After completing these steps:

No data is transferred or deleted from the Matatika-managed PostgreSQL database, and it can be made the default data store again at any time.


Custom data stores

For custom data stores (i.e. those not provided by Matatika):

If a custom data store is set as the default for a workspace, data will be loaded into the data store as normal, but any datasets will be empty.