Support Questions

Find answers, ask questions, and share your expertise

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`