Database

Overview

Visualize and analyze database resources, including tables, views, schemas, and queries. Monitor data access and usage to ensure security and compliance. Track performance metrics, identify vulnerabilities in database structures, and enable efficient data crawling for actionable insights. Ensure robust backup and recovery processes while maintaining the integrity and security of sensitive data.

Configurations

Configuration	Description
Blueprint Account Name	A human-readable name for your account that will be used to identify this account across the application.
Host	The address of your database server (e.g., waleed-test-us-east-2.redshift.amazonaws.com).
Port	The port number used to connect to your database (e.g., 5439 for Redshift).
User Name	The username used to log in to your database.
Password	The password associated with the username.
Database Name	The specific name of the database you want to connect to.
Dialect	The type of database you are connecting to (e.g., Redshift, PostgreSQL, MySQL, SQLServer, etc.).
Enable Rows Crawl	Option to enable crawling of individual rows in your database tables. If enabled, Kaleidoscope will inspect the data within your tables.
Data Crawl Frequency	The frequency at which Kaleidoscope will crawl the database for new data.

Permissions

Postgres

• pg_database

• pg_namespace

• pg_user

• role_table_grants

• pg_class

• tables

• table_constraints

• key_column_usage

• constraint_column_usage

• pg_constraint

• pg_attribute

• pg_attrdef

• triggers

• views

• pg_matviews

• pg_tables

• pg_roles

• columns

MSSQL

• sys.databases

• sys.schemas

• sys.tables

• sys.partitions

• sys.allocation_units

• sys.procedures

• INFORMATION_SCHEMA.VIEWS

• sys.indexes

• sys.dm_db_partition_stats

• sys.columns

• sys.key_constraints

• sys.check_constraints

• sys.default_constraints

• sys.objects

• INFORMATION_SCHEMA.COLUMNS

• sys.triggers

• sys.trigger_events

• sys.sql_modules

• sys.index_columns

• sys.database_principals

• sys.server_principals

• sys.database_permissions

• sys.foreign_keys

• sys.foreign_key_columns

• sys.extended_properties

MySQL

• information_schema.schemata

• information_schema.TABLES

• information_schema.TABLE_CONSTRAINTS

• information_schema.KEY_COLUMN_USAGE

• information_schema.COLUMNS

• information_schema.TRIGGERS

• information_schema.STATISTICS

• information_schema.ROUTINES

• information_schema.VIEWS

• mysql.user

• mysql.db

• information_schema.TABLE_PRIVILEGES

• information_schema.statistics

For more details on the Database permissions, you can refer to the following documentation:

• PostgreSQL Permissions

• MSSQL Permissions

• MySQL Permissions

Schema Model

Resources	Source Entity	Normalized Entity	Description
Database Table	database.sql.Table	Table	A table within a database.
Database Column	database.sql.Column	Column	A column within a database table.
User Privilege	database.sql.UserPrivilege	Privilege	A user's privilege in the database.
Foreign Key	database.sql.ForeignKey	ForeignKey	A foreign key relationship between columns.
Database Schema	database.sql.Schema	Schema	A schema within the database.
Database User	database.sql.User	User	A user in the database system.
Database Role	database.sql.Role	Role	A role defined in the database system.
Database Constraint	database.sql.Constraint	Constraint	A constraint applied to a database table.
Database Instance	database.sql.Database	Database	An instance of a database.
Database View	database.sql.View	View	A view in the database.
Materialized View	database.sql.MaterializedView	MaterializedView	A materialized view in the database.
Database Index	database.sql.Index	Index	An index applied to a table for efficiency.
Database Trigger	database.sql.Trigger	Trigger	A trigger applied to database tables.
Database Procedure	database.sql.Procedure	Procedure	A stored procedure in the database.
Database Cluster	database.sql.Cluster	Cluster	A cluster of database instances.
Schema Access	database.sql.SchemaAccess	Access	Access permissions for a schema.
Database Row	database.sql.Row	Row	A row in a database table.