@Nixon Rodrigues I have tried adding ranger policies for atlas service however there is something I am doing wrong, probably I will ask as a different question. Thanks a lot and appreciate your help. Dhieru ... View more

@Nixon Rodrigues After adding the user in atlas-simple-authz-policy.json and chnaging the property atlas.authorizer.impl = simple worked from me it is working now. Thanks a lot for your help. However please do explain how it worked because I am confused after searching a lot in the community. Thanks dhieru ... View more

@Nixon Rodrigues Thanks a lot for the help yes it did help I am using HDP3.1 sandbox. I went ahead and added the user holger_gov in the userRoles section as shown below however I am not able to see the metadata of hive tables and lineage in Atlas UI. The Atlas UI looks like below In addition when I searched in this community, they advised to run hive-import.sh, when I did that, I receive the following error using "holger_gov" as user using "admin" as user Is this related to ranger? when I to hdfs dfs -ls /user I do not see holger_gov user, but then admin is there so admin should work. Do I need to change the below property from ambari ? from ranger to simple atlas.authorizer.impl = simple? at present it is ranger I am confused now apologies for long winded question Thanks for your help! ... View more

@Nixon Rodrigues I was able to add the user holger_gov in the users-credentials.properties file. For users having the same issue, they need to edit the users-credentials.properties file using vi or any editor holger_gov=<ROLE YOU want to give>::<sha256sum of the password> in order to generate the sha256sum use the below command in *nix terminal echo -n "yourpassword" | sha256sum it will give you some output like below 4d20573d20756b4b2cd80e41def04b52907710000b038f0f901d4b568e254fc6 - copy the sum till 6 leave out the space and - (dash) and paste it in the users-credentials.properties files. Restart you ATLAS server from ambari, and it will work Thanks again to @Nixon Rodrigues Another question? Do I also need to cretae and add policy-store.txt , as of now I do not have any such file in the directory /usr/hdp/current/atlas-server/conf/. Thanks Dhieru ... View more

@Nixon Rodrigues Thanks for the response, appreciate your help No there is no holger_gov in the users-credentails.properties file. Attached is the image how do I add the user holger_gov in here? ... View more

@Jobin George Thanks a lot for this awesome post. I had a question so to monitor every queue I need to have monitor individually right? ... View more

@Matt Burgess Can we do join query here from differen tables. I looked at the properties for QueryDatabase table, there is no property for entering query? Any help when query is join query from 2 different tables ... View more