Connection security review
![Fabrice](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar11.png)
Fabrice
Registered Posts: 2 ✭
Hello,
I need to export the list of connections and the users who have access to these connections. There is an Authorization Matrix that can be exported for projects, but for connections?
Sincerely
Fabrice
Operating system used: RedHat
Tagged:
Best Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,211 Dataiker
There is not such Matrix available in the UI.
You can use the Dataiku API to build something similar , not you would need to run this with Admin user:import dataiku import pandas as pd # Get a list of connections client = dataiku.api_client() dss_connections = client.list_connections() # Initialize lists to store the values connection_list = [] allowed_groups_list = [] # Iterate over the connections and extract the relevant values for connection in dss_connections: conn = client.get_connection(connection).get_definition() if conn['usableBy'] == 'ALLOWED': allowed_groups = conn['allowedGroups'] else: allowed_groups = ["ALL"] connection_list.append(connection) allowed_groups_list.append(allowed_groups) # Create a dataframe with the extracted values df_connection = pd.DataFrame({ 'connection': connection_list, 'allowed_groups': allowed_groups_list }) # Explode the 'allowed_groups' column df_connection = df_connection.explode('allowed_groups').reset_index(drop=True) df_connection
Thanks -
It's working
Thanks for your help
Fabrice