0

Discovery Data Catalog Export

Hello folks.
Is it possible to export the data catalog from a discovery object in a format which is not .pdf?
I see I can export the data catalog from a data model object as a json file, which allows me to analyze in more detail.

Thanks, Dave

12 replies

null
    • NPANS
    • 1 yr ago
    • Reported - view

    You can import/export the definitional aspects from the admin. The Data Catalog export in Discovery is for end users - who typically would not want to use a JSON file.

      • Dave_Carbery
      • 1 yr ago
      • Reported - view

      NPANS Brilliant - many thanks for that. I hadn't been able to find my way to that location, knowing that there must be a way to retrieve that information as the .pdf catalog must have been generated from a .json (well, to my eye at least).
      Cheers, Dave

    • "making the sophisticated simple"
    • AviPerez
    • 1 yr ago
    • Reported - view

      • Dave_Carbery
      • 1 yr ago
      • Reported - view

      Avi Perez I was just about to ask for another pointer on where to find...many thanks!

    • Dave_Carbery
    • 1 yr ago
    • Reported - view

    Avi Perez Actually, I may have communicated the original question poorly. Or, more likely as I'm still learning, I might be missing something. What I'm trying to find out...are the 'instructions' for generating a discovery (e.g. a json file) available.
    My actual context is: if a model has multiple tables and in two different tables there exist a column in each with the same name, can I identify from the discovery object which table in the model that column originates from?

    Thanks, Dave

    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    Hi Dave,

    Discover objects are not available as JSON exports.

    Hope that helps.

    Ian

      • Dave_Carbery
      • 1 yr ago
      • Reported - view

      Ian Macdonald Hi Ian, thanks for confirming what I suspected - I reckoned I would have found some way forward with finding some doc wrt that.
      It might be naivety, but, the rationale for not being able to access a json export for a discovery, as per a model object....is this technical, lack of need, conceptual? I'm working on trying to deconvolute some complex discoveries that have evolved over time and working with an 'in' and and 'out' json would have made this a massively more tractable task.
      Hope you're well, all the best, Dave

      • Senior Director of Product
      • Ian_Macdonald
      • 1 yr ago
      • Reported - view

      Dave Carbery we may have a different approach / solution. Watch yhis dpace.

      • Dave_Carbery
      • 1 yr ago
      • Reported - view

      Ian Macdonald hmmmmm...will do 🤔👍

    • David_Gordon
    • 1 yr ago
    • Reported - view

    Hi Dave,

    You can use the Pyramid usage model that will allow you to create a discovery with all the required columns.

    Instructions on how to implement the model can be found here Pyramid Usage Model and Analysis - Tech Blogs - Pyramid Analytics Community Forum

    In this example I have used the item name, the column type and the column unique name (this will display both the table and the column name.) You can then export the results to excel if required. 

    • Michael_Raam.1
    • 1 yr ago
    • Reported - view

    Hi,

    If you want to know what table a column is coming from, one option is to open a custom member / measure in script mode and drag the column into it.

    The table name should be visible as a part of the unique name of the column.

    It would be useful to have a popup or something similar that shows the unique name when hovering over the column 

    • "making the sophisticated simple"
    • AviPerez
    • 3 mths ago
    • Reported - view

    The new API 3.0 in our latest release Pyramid 2023.10 as this functionality.

Content aside

  • Status Answered
  • 3 mths agoLast active
  • 12Replies
  • 73Views
  • 6 Following