Pinterest

Pinterest is a social media platform for discovering and sharing ideas using visual bookmarks.

Bruin supports Pinterest as a source for Ingestr assets, allowing you to ingest data from Pinterest into your data warehouse.

To connect to Pinterest you must add a configuration item to the .bruin.yml file and the asset file. You will need access_token.

Follow the steps below to correctly set up Pinterest as a data source and run ingestion.

Step 1: Add a connection to .bruin.yml file

Add the connection configuration to the connections section of .bruin.yml:

connections:
  pinterest:
    - name: "pinterest"
      access_token: "your-token"

• access_token: The token used for authentication with the Pinterest API. You can obtain an access token from the official Pinterest documentation.

Step 2: Create an asset file for data ingestion

Create an asset configuration file to define the data flow:

name: public.pinterest_pins
type: ingestr

parameters:
  source_connection: pinterest
  source_table: 'pins'

  destination: postgres

• source_connection: name of the Pinterest connection defined in .bruin.yml.
• source_table: Pinterest table to ingest. Available tables:

Table	PK	Inc Key	Inc Strategy	Details
pins	id	created_at	merge	Retrieves a list of pins.
boards	id	created_at	merge	Retrieves a list of boards.

• destination: name of the destination connection.

Step 3: Run asset to ingest data

bruin run assets/pinterest_asset.yml

Executing this command ingests data from Pinterest into your Postgres database.