Skip to content
Okera Documentation
Reports Page
Initializing search
Okera Documentation
Home
Overview
Overview
Product Overview
Cluster Component Overview
Metadata Services Overview
Architecture Overview
Release Information
Release Information
Version 2 Release Notes
Version 2 Release Notes
Version 2.18 Release Notes
Version 2.17 Release Notes
Version 2.16 Release Notes
Version 2.15 Release Notes
Version 2.14 Release Notes
Version 2.13 Release Notes
Version 2.12 Release Notes
Version 2.11 Release Notes
Version 2.10 Release Notes
Version 2.9 Release Notes
Version 2.8 Release Notes
Version 2.7 Release Notes
Version 2.6 Release Notes
Version 2.5 Release Notes
Version 2.4 Release Notes
Version 2.3 Release Notes
Version 2.2 Release Notes
Version 2.1 Release Notes
Version 2.0 Release Notes
Compatibility Guarantees
Test Drive Okera
Test Drive Okera
Get Started
Explore the Catalog
Grant Permissions
Register New Data
Use Snowflake Policy Synchronization
USE OKERA
Before You Start
Use the Web UI
Use the Web UI
Okera UI Basics
Call-to-Action Home Page
User Profile Home Page
View User Account Details
Copy Your Access Token
Databases Page
Connections Page
Registration Page
Roles Page
Users Page
Insights Page
Workspace Page
Tags Page
System Information Page
Manage Access to UI Features
Configure the UI
Classify Data Using Tags
Classify Data Using Tags
Manage Tags
Manage Tags
Tags Overview
Who Can Manage Tags
List Tags
Create a Tag
Import Tags
(Preview Feature)
Search for Tags
Delete a Tag
Assign Tags
Understanding Tag Inheritance
Tag FAQs
Configure Autotagging
Nested Field Tags
(Preview Feature)
Connect to Data Sources
Connect to Data Sources
Manage Connections
Manage Connections
Connections Overview
Who Can Manage Connections
Create a Connection
List Connections
Filter and Search Connections
Edit a Connection
Test a Connection
View Connection Details
Delete a Connection
Connection Pushdown Processing
Object Storage Connections
Snowflake Connections
Snowflake Connections
Overview
Configure and Use Snowflake Policy Synchronization Enforcement
Configure and Use Snowflake Policy Synchronization Enforcement
Policy Synchronization Enforcement Overview
Limitations and Case Considerations
Configure Snowflake (Required)
Configure Okera (Optional)
Select Use of Policy Synchronization (Required)
Synchronization Options
Add Policy Synchronization for a New Database
Audit Log Processing
Advanced Connection Properties
Tag Users in Snowflake
Hide Column Data
Use Snowflake BI Gateway Enforcement
Create a Snowflake Connection
AWS Athena Connections
(Preview Feature)
AWS Redshift Connections
BigQuery Connections
Dremio Connections
Microsoft SQL Server Connections
MySQL Connections
Oracle Connections
PostgreSQL
Custom JDBC Data Source Connections
Crawl Connections and Register Structured Data (Datasets)
Crawl Connections and Register Structured Data (Datasets)
Crawler Overview
Who Has Access to Crawlers
Create and Run a Crawler
Configure Object Storage Crawlers
List Crawlers
Filter and Search for a Crawler
Rerun a Crawler
Delete a Crawler
Register Structured Data (Datasets)
Crawler Questions and Answers
Register and Manage Unstructured Data (URIs)
Register and Manage Unstructured Data (URIs)
Unstructured Data Support in the UI
(Preview Feature)
OkeraEnsemble Overview
(Preview Feature)
Register Unstructured Data URIs
(Preview Feature)
List and Review Unstructured Data URIs
(Preview Feature)
Edit Unstructured Data URI Tags
(Preview Feature)
Delete Unstructured Data URIs
(Preview Feature)
Search for Unstructured Data URIs
(Preview Feature)
Manage Databases
Manage Databases
Databases Overview
List and Review Databases
Search for Databases
Create a Database
Edit Database Metadata
Delete a Database
Manage Datasets and Views
Manage Datasets and Views
Dataset & View Overview
List and Review Datasets and Views
Understand Schemas
Create Internal Views
Understand View Lineage
Search for Datasets and Views
Edit Metadata
Remove a Dataset or View
Preview Datasets and Views
Use in Code
Casing Considerations for Dataset Names
Identify Favorites
Manage Roles and Permissions
Manage Roles and Permissions
Access Overview
Role-Based Access Control
Attribute-Based Access Control
Safeguard Policies
(Preview Feature)
Manage Roles
Manage Roles
Overview
Who Can Manage Roles?
Role Templates
List Roles
Create Roles
Edit Roles
Delete Roles
Manage Permissions
Manage Permissions
Overview
List Permissions
Add Permissions
Edit Permissions
Delete Permissions
Create Permissions in the UI
View and Manage Permissions in the UI
Wildcards in Permissions
Permission Examples
Access Delegation
Access Levels
Privacy and Security Functions
Useful Okera Built-In Functions
Create Row-Level Security Permissions
Audit Okera Usage
Audit Okera Usage
Audit Logs Overview
Insights Page
User Inactivity Analysis
CONFIGURE OKERA
The Configuration File
Port Configuration
Authentication and Identity
Authentication and Identity
Overview
Use JSON Web Tokens (JWTs)
Use Lightweight Directory Access Protocol (LDAP)
Use Open Authorization (OAuth)
Use Security Access Markup Languate (SAML)
Use Kerberos
Configure Logging
Configure Logging
Overview
Audit Log Configuration
Operational Log Configuration
Configure Security
Configure Security
Configure SSL for the Cluster
Configure SSL/TLS for the Okera Catalog
Configure Kubernetes Secrets
Provide Secure Credentials
Configure the Okera Database
Configure the Okera Database
Overview
Configuring the Database
Use a Hive Metastore (HMS)
Use a Hive Metastore (HMS)
Overview
Using Glue as a Third-Party Metadata Catalog
External Catalog Integration
Data Access Tool Integration
Data Access Tool Integration
Overview
Native Python Integration (PyOkera)
AWS EMR Integration
GCP Dataproc Integration
(Preview Feature)
nScale Integration
Databricks Integration
Databricks Integration
Integration Steps
OkeraEnsemble Deployment for Databricks
(Preview Feature)
Hadoop and Spark Clients
Hadoop and Spark Clients
Hadoop Client Integration
Hive and Spark Client Integration
Hive Integration - Best Practices
Apache Ranger Migration
(Preview Feature)
Presto Endpoint
Presto User Impersonation
Integrate With BI tools
Integrate With BI tools
JDBC/ODBC Overview
Tableau
Power BI
DBeaver
SQL Workbench
Integrate With External Catalogs
Okera Policy Engine Integration Best Practices
REST API Integration
User Attribute Integration
User Attribute Integration
Overview
AD/LDAP-Sourced User Attributes
Custom Script-Sourced User Attributes
JDBC Driver Use in Okera
SaaS Deployments
INSTALL & DEPLOY OKERA
Key Deployment Information and Players
Prerequisites
Deploy Okera on AWS
Deploy Okera on AWS
AWS Overview
Prerequisites
Deploy Okera With CloudFormation
Deploy Okera on EKS
Active/Active Deployment in Aurora RDS
AWS Marketplace
OkeraEnsemble Deployment on AWS S3
OkeraEnsemble Deployment on AWS S3
Overview
Default Mode Deployment
nScale Mode Deployment
Map Okera Access Permissions
Dynamic Bypass Querying
Amazon S3 Assume Secondary Role Support
Deploy Okera on Azure
Deploy Okera on Azure
Azure Overview
Prerequisites
Deploy Okera on AKS
Deploy Okera on Google Cloud Platform
Deploy Okera on Google Cloud Platform
GCP Overview
Prerequisites
Deploy Okera on GKE
Deploy Okera Using Helm Charts
Advanced Deployment Information
Advanced Deployment Information
High Availability
Cluster Sizing
Memory Usage
Upgrade Okera
REFERENCE
Okera Configuration Parameters
Home Page Access Reference
CVEs/CWEs Addressed
Okera Reserved Keywords
Supported S3 Encryption Support
Data Types
Complex Data Types
Schema Design Best Practices
Bucket (Cluster) Tables
Advanced Querying of JDBC Data Sources
SQL Reference
SQL Reference
Overview
Supported SQL
Programmatic Registration
Data Types
Expressions and Operators
Predicates
Built-In Functions
Built-In Functions
Overview
Comparison and Conditional Functions
Control Flow Functions
String Functions
Numeric Functions
Date and Time Functions
Cast Functions and Operators
Bit Functions
Information Functions
Security Functions
Miscellaneous Functions
Extending Okera
Okera okctl Utility
Frequently Asked Questions
TUTORIALS
Onboarding Datasets
Analyze Audit Logs
Managing Queries
Using PyOkera with AWS Lambda
Running PyOkera in a Container
Managing System Tokens
Configuring Okta for Okera
Obtaining Sailpoint User Attributes in Okera
(Preview Feature)
How To Read the Okera Process Logs
How to Use the Okera Auth Server
Reports Page
¶
This page has been renamed Insights. See
Insights
.