Table: databricks_settings_ip_access_list - Query Databricks IP Access Lists using SQL
Databricks IP Access Lists is a feature within Databricks that allows you to control which IP addresses have access to your Databricks workspace. It provides a mechanism to ensure that only trusted IP addresses can access your Databricks resources, enhancing the security of your data and applications. This feature is crucial for managing access permissions and maintaining the integrity of your Databricks workspace.
Table Usage Guide
The databricks_settings_ip_access_list table provides insights into the IP Access Lists within Databricks. As a security analyst or a DevOps engineer, you can explore detailed information about the IP addresses and their access permissions through this table. You can use it to audit access permissions, identify trusted IP addresses, and ensure that only authorized IP addresses have access to your Databricks resources.
Examples
Basic info
Explore the creation and composition of IP access lists within your Databricks settings. This allows you to understand who created each list, when it was created, and how many addresses it contains, which can be useful for auditing and security purposes.
List access lists modified in the last 7 days
Discover the segments that have seen modifications in their access lists within the past week. This can be beneficial in monitoring recent changes to enhance security and control access within your digital environment.
List all access lists which are disabled
Discover the segments that have disabled access lists in your Databricks settings. This is useful for identifying potential security risks or areas where access has been restricted.
List all the addresses in each access list
Explore which IP addresses are included in each access list in your Databricks settings, useful for maintaining network security and controlling access to your data.
Get access lists that allow all the requests
Explore which access lists are allowing all requests, including those that are currently disabled. This is useful for identifying potential security vulnerabilities in your Databricks settings.
Schema
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- databricks
You can pass the configuration to the command with the --config
argument:
steampipe_export_databricks --config '<your_config>' databricks_settings_ip_access_list