0

Find all references to a table

Suppose you create a new table in a schema called Stock2.  You then plan to replace all references of the old table Stock1 with the new table Stock2.  Is there a way on a managed Incorta instance (i.e. with no direct server access) to find all the dashboards and business views/schemas that reference the old Stock1 table?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • If I were doing it right now, today, I'd export the content, unzip, open Notepad++ and do a "find in files"  search and replace.

     

    Then rezip and import.

     

    Painful if you have a lot of business schemae and content.   It might be easier to export just the physical schema, find/replace "stock1" with "stock_original" and then rename "stock2" to "stock1"    That way the business schema wouldn't need to be touched, nor the dashboards/insights.   

    Like 1
  • The inspector tool https://docs.incorta.com/cloud/tools-inspector-tool/ can provide the lineage dashboard, which include the mapping from the dashboard columns or metrics to the business schema and physical schema.

    Like 1
  • Thank you!  I'll try that out

    Like 1
Like Follow
  • 8 days agoLast active
  • 3Replies
  • 14Views
  • 3 Following

Product Announcement

Incorta 5 is now Generally Available