Introducing Actian Database as a Service on the Actian Data Platform
Introducing Actian Database as a Service on the Actian Data Platform
Overview
Advantages of Actian Database as a Service on the Actian Data Platform
Performance and Concurrency
Videos
Actian Data Platform Security Overview
Supported Public Cloud Platforms
Concepts to Understand
Actian Units
Database Cost and Actian Units
Access Documentation and Help
Using the Assistant
What’s New in Actian Database as a Service on the Actian Data Platform
Actian Database as a Service EAP Release Notes
Getting Started with Actian Database as a Service
Actian Ingres Database as a Service Workflow
Actian Ingres Database as a Service Workflow
Create a New Database Instance
Database Instance Details
Use of the Restricted Bash Shell (rbash)
Common Tasks
Generating Your Avalanche Login Credentials
Log In
Log Out
Check Avalanche Health Status
Monitor AU Usage
Set Up Key Management Service for Data Encryption (BETA feature)
Before You Begin
Using the Avalanche-managed Encryption Key
Set Up the AWS Key Management Service (AKMS)
Add an Access Key in Avalanche
Add the Avalanche AWS Account ID to Your AKMS Policy
Availability of Your KMS When Starting and Stopping Warehouses
Create a Database Instance
Create a New Database Instance
Actian Data Platform Database Instances Console
Database Instance Details
Database User Management
Load Data
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
Automated Database Backup Process
Use of the Restricted Bash Shell (rbash)
Commands and Tools
File access
File system layout
Databases
Making Changes
Users
Monitoring/Troubleshooting
Warehouse and Database Management
Access Warehouse or Database Connection Information
Connection Tools
Avalanche Client Runtime Package
Avalanche JDBC Driver
Video: How to Connect to an Avalanche Warehouse Using the JDBC Driver
Copy Connection Strings to the Clipboard
Scale a Database
Stop and Start Databases
Stop a Database
Restart a Database
Stop a Database
Restart a Database
Automatic Stopping of Idle Databases
Modify Idle Stop Period
Schedule a Database
Cron Expressions
Building a Cron Expression
Examples
Delete Databases
Database 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 Databases
Display the Database Monitoring Console
Database Monitoring Services
Active Queries KEEP?
Connected Sessions KEEP?
Error Log
DBMS Processes
Lock Waits
Transaction Log
OS Disk Usage
OS Load Average
OS Memory
Check a Service
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
Run Your Own Queries
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
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
Introducing Actian Database as a Service on the Actian Data Platform
Appendixes