Introduction and Concepts
Introducing Actian Warehouse
Overview of Actian Warehouse on the Actian Data Platform
Performance and Concurrency
Actian Data Platform Features
Video: Actian Data Platform Architecture
Actian Data Platform Security Overview
Supported Cloud Platforms
Concepts to Understand
Actian Units
Warehouse or Database Cost and Actian Units
Access Documentation and Help
Using the Actian Data Platform Assistant
Getting Started
Access the Actian Data Platform
Generating Your Platform Login Credentials
Log In
Log Out
Check Actian Data Platform Health Status
Monitor AU Usage
Set Up Key Management Service for Data Encryption
Before You Begin
Using an Actian-managed Encryption Key
Set Up the AWS Key Management Service (AKMS)
Add an access key in the Actian Data Platform
Add the Actian Data Platform AWS Account ID to Your AKMS Policy
Availability of Your KMS When Starting and Stopping Warehouses
Create a Warehouse
Create a New Warehouse
Actian Data Platform Warehouses Console
Warehouse Details
Comparing Warehouses and Databases
Automated Backup Process
Create a Database Instance
Create a New Database Instance
Actian Database Instances Console
Database Instance Details
Manage Public RSA Keys for Database Administrator Access
Generate SSH RSA Keys
Upload a Public RSA Key to Enable DBA Access to a Database
Disable DBA Access to a Database
Establish Database Access of SSH
Set Up Access Credentials for Cloud Storage Accounts
Set Up Google Cloud Access
Step 1: Create a Google Cloud Service Account
Step 2: Generate a Google Cloud Service Account Key
Step 3: Authorize Your Google Cloud Service Account for Actian Data Platform Access
Set Up Amazon S3 Access
Set Up Amazon S3 Access Permissions
Set Up Microsoft Azure Access
Step 1: Create an App Registration
Step 2: Obtain the Application ID and the Directory ID
Step 3: Assign a Scoped Role to the Application
Step 4: Generate a Client Secret for the Application
Grant Access to Warehouse or Database for External Tables Access
Give Your Actian Warehouse Access to Google Cloud Storage
Give Your Actian Warehouse Access to AWS Cloud Storage
Give Your Actian Warehouse Access to Azure Cloud Storage
Warehouse and Database Management
Access Warehouse or Database Connection Information
Connection Tools
Actian Client Runtime Package
Actian JDBC Driver
Copy Connection Strings to the Clipboard
Update Allow List IP Addresses
Scale a Warehouse
Actian Warehouse Clone
Cloning a Warehouse
Administrate Warehouses or Databases
Stop a Warehouse
Restart a Warehouse
Stop a Database
Restart a Database
Automatic Stopping of Idle Warehouses or Databases
Modify Idle Stop Period
Schedule a Warehouse
Cron Expressions
Building a Cron Expression
Examples
Modify Maintenance Window Starting Times
Delete Warehouses
Warehouse Administration
Access the Administration Interface
Manage Users
View Access Policy Management
Manage Groups
Manage Listeners
Open a Service Request
Contact Support
Manage Users
Overview of User Management
User Profiles
User Groups
User Roles
Types of Users
Set the dbuser Connection Password
Add Native Users
Add SSO Users
Add an SSO User to a Warehouse
Register an SSO User with an Actian ID
Give SSO User Administrative Rights
Delete Users and Their Schemas
Update Users
Display Users from the Warehouse Details or Database Instances Page
Add Platform Users
API access with Platform User Accounts
Monitor Warehouses
Display the Warehouse Monitoring Console
Warehouse Monitoring Services
Service Information
Active Queries
Cluster CPU Load
Connected Sessions
Error Log
Execution Memory
Pending Disk Updates
Query Parallelism
System Data Skew
Table Data Skew
Warehouse Disk Usage
Service Statuses
Check a Service
Graphing Service Information
Graphing Toolbar Icons
Zoom in on Graphing Data
Download a Chart as a PNG File
Query Editor
Overview of the Query Editor
Features and Restrictions
Query Editor Diagram
Single Sign-on Users, Native Users, and Platform Users
How Authentication Works
Using the Query Editor
Launch Query Editor
Examine the Database Schema
Create and Save a New Query
Save an Existing Query as a New Query
Import Queries
Edit Queries
Open a Saved Query
Run Sample Queries
Run Your Own Queries
Tag a Query
Display Query History
AWS AV-1 and Azure Query History
Google Cloud and AWS AV-2 Query History
Make a Query Shared or Private
Clone a Query
Format Query Text Automatically
List and Sort Queries
Export an Open Query
Export All Queries from Saved Queries or Query History
Export Query Results to a File
Display Query Results as a Formatted Table
Display Query Results as Chart Visualizations
Display a Line Chart
Display a Horizontal Bar Chart
Display a Vertical Bar Chart
Display a Scatterplot Chart
Display a Pie Chart
Display a Vertical Stacked Bar Chart
Display a Horizontal Stacked Bar Chart
Open a Chart in a New Window
Save a Chart Image as a PNG File
Working with Monitoring (imadb) Tables
Restrictions on IMA Use
Query Examples on IMA Tables
Troubleshooting the Query Editor
Command Palette Reference
Troubleshooting
SSO Authentication Troubleshooting
Network Data Encryption Troubleshooting
Errors Creating Tables
Common Data Loading Error Messages
Network Disconnects Due to Perceived Inactivity
Loading Fails When Using External Tables (Spark)
Query Editor Troubleshooting
Appendixes
Mapping Blob URI Syntax to ABFS Syntax
Blob Resource URI Syntax
Mapping Blob URI to ABFS Syntax
Connect to DBeaver with JDBC
Install DBeaver and Set Up an Actian Driver
Set a Connection Password
Get Connection Properties for DBeaver
Select the Actian Database Driver and Connect to a Warehouse
Run a Query
Connect to Looker with JDBC
Connect to Power BI with ODBC
Connect to Tableau with ODBC
Run Sample Queries
Introduction and Concepts
Run Sample Queries