Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Customize search output in Apache Atlas 0.7 / HDP 2.5

avatar

Is it possible to customize the search output in Apache Atlas 0.7?

For example, can i include type information to easily show if the match output is Table or Column etc.

1 ACCEPTED SOLUTION

avatar
Guru

@Pranav Vashisht

You can achieve this using the DSL search feature. DSL is a SQL like syntax. Here are some examples from the Atlas website:

DSL Examples

For the model, Asset - attributes name, owner, description DB - supertype Asset - attributes clusterName, parameters, comment Column - extends Asset - attributes type, comment Table - supertype Asset - db, columns, parameters, comment Traits - PII, Log Data

DSL queries: * from DB

  • DB where name="Reporting" select name, owner
  • DB where name="Reporting" select name, owner orderby name
  • DB where name="Reporting" select name limit 10
  • DB where name="Reporting" select name, owner limit 10 offset 0
  • DB where name="Reporting" select name, owner orderby name limit 10 offset 5
  • DB where name="Reporting" select name, owner orderby name desc limit 10 offset 5
  • DB has name
  • DB is JdbcAccess
  • Column where Column isa PII
  • Table where name="sales_fact", columns
  • Table where name="sales_fact", columns as column select column.name, column.dataType, column.comment
  • `Log Data`

View solution in original post

2 REPLIES 2

avatar

avatar
Guru

@Pranav Vashisht

You can achieve this using the DSL search feature. DSL is a SQL like syntax. Here are some examples from the Atlas website:

DSL Examples

For the model, Asset - attributes name, owner, description DB - supertype Asset - attributes clusterName, parameters, comment Column - extends Asset - attributes type, comment Table - supertype Asset - db, columns, parameters, comment Traits - PII, Log Data

DSL queries: * from DB

  • DB where name="Reporting" select name, owner
  • DB where name="Reporting" select name, owner orderby name
  • DB where name="Reporting" select name limit 10
  • DB where name="Reporting" select name, owner limit 10 offset 0
  • DB where name="Reporting" select name, owner orderby name limit 10 offset 5
  • DB where name="Reporting" select name, owner orderby name desc limit 10 offset 5
  • DB has name
  • DB is JdbcAccess
  • Column where Column isa PII
  • Table where name="sales_fact", columns
  • Table where name="sales_fact", columns as column select column.name, column.dataType, column.comment
  • `Log Data`