Connect Mozenda to Trifacta
  • 25 May 2021
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Connect Mozenda to Trifacta

  • Dark
    Light
  • PDF

Article Summary

Trifacta is a data wrangling tool that allows you to clean and prepare your data for further analysis by you or your stakeholders.

Follow the steps below to connect your Mozenda account to Trifacta via Amazon S3.

Import into Trifacta

  1. See Publish data to Amazon S3 to publish your data to an Amazon S3 bucket.
Note:

If you’re using Trifacta Enterprise, you may have to contact your CSM to add the bucket you would like to access from Amazon S3. If you're using a cloud.trifacta account, you likely have full access to Amazon S3 buckets.

  1. Sign in to your Trifacta account.
  2. Access your Library.
    Trifacta 1
  3. Select S3 and navigate to your file.
  4. Select Create Dataset with Parameters and browse to select your file.
    Trifacta 2(1)
  5. Highlight the date, then select Add Pattern Parameter to save as a filenaming pattern.
    Trifacta 3

If you’re importing a JSON file, make sure to select edit settings and uncheck detect structure. Using RegEx, you can also pull only files that match a certain pattern.
By using the wildcard (*) and highlighting the date (assuming you followed the naming suggestions from the Amazon S3 Publishing file), you can combine data from different run dates into a single data set.

Publish from Trifacta

To manipulate JSON data into a functional dataset.

  1. Select the recipe step you are wanting to publish from.
  2. When a recipe step is selected, there is a small icon in the top right corner of the main recipe icon. Select that icon and you may choose to manually publish or publish on a schedule. You then select where to publish from that.
    Trifacta 4(1)

Transform JSON

  1. Navigate to a recipe for the data set.
    All of the JSON data should be consolidated into a single cell. Replace the “\n” delimiter with ‘},’
    trifacta 5
  2. Open the recipes on the right and select Edit on the Break into rows… step.
    Trifacta 6
  3. Follow the steps below, replacing "Export" with the name of your published table. If you used the default Mozenda table, the name is "Default."
    Trifacta 7(1)
  4. Search the Recipe step Unnest Objects into columns. Enter the column names.
    Trifacta 8(1)
  5. Delete column1.

Was this article helpful?