Pigment Setup Guide Lite Private Preview
Follow our setup guide to connect Pigment to Fivetran.
Prerequisites
To connect Pigment to Fivetran, you need a Pigment account and you need to be Pigment Workspace Admin to access and manage the API Keys.
Setup instructions
Create API key
Log in to your Pigment account.
Open your Workplace settings and click API Keys at the bottom of the Sidebar.
To create a new API key, just click on + Create API key.
There are the 3 fields you will need to fill:
i. API Key name: Name the API Key with something easily recognizable.
ii. Expiration date: The date when the API key will no longer be valid. > Note: The expiration day isn't included when you select the expiration date. For example, if your expiration date is July 1st, your API key is only valid until June 30th.
iii. Key type: Select Export.
Make a note of the API key. You will need it to configure Fivetran.
NOTE: If you face any difficulties in creating the API Key, please reach out to the Pigment support team.
To find View ID, open the block (Metric, List, or Table) within Pigment’s UI and copy the URL. It should look like https://pigment.app/application/{applicationId}/tables/{blockId}?displayMode=Grid&viewId={viewId}, retrieve the view Id from that URL as indicated.
Similarly, you can find all the Block IDs(metric, list, table) within the URL for respective blocks.
NOTE: All the parameters—List ID, Metric ID, and Table ID—are optional when creating the connector. However, the View ID is a required parameter.
Finish Fivetran configuration
- In the connector setup form, enter your Destination schema name.
- Enter the API key you created Step 1
- Enter Respective Block IDs(Metric ID, List ID, Table ID), and View ID.
- Click Save & Test. Fivetran will take it from here and sync your Pigment data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration