ONBOARDING BEST PRACTICES

Avalanche Cloud Data Platform

The Avalanche cloud data platform offers a more trusted, flexible, and easy-to-use experience than traditional data warehouses. Leveraging Kubernetes technology, Avalanche provides blazingly fast performance across cloud, multi-cloud and hybrid environments. Native integration capabilities allow you to securely design, deploy and automate data pipelines across your organization.

video-ico

Avalanche 101

MPP Architecture-Icon_80x80

Reference Architecture

High Concurrency-Icon_80x80

Documentation

View Avalanche Getting Started Tutorials

Fast-track your Avalanche experience with our short, quickstart tutorials.

Register for Avalanche Account

Register for Avalanche Trial. Visit this page if you need to register for access to the Avalanche Data Platform trial experience.

Actian Communities

Access the forums to get answers to your questions and collaborate with the community. Community allows you to open and track support tickets, access the Avalanche knowledge base, and give us suggestions for ways we can improve the Avalanche platform.

Actian Academy

View training and product videos on-demand and track your classes for certification.

Download center

Access the download center to download Actian products including ODBC/JDBC drivers for Avalanche.

Documentation

View Actian Avalanche technical documentation.

FAQs

How do I add users and configure access management?

Data Warehouse Access

After new users log into the Avalanche platform, they will see only the data warehouses they own or have access to. Therefore, the warehouse list will be empty when a new user logs in.

To access existing warehouses, you must GRANT rights on the Warehouse. Learn more about granting warehouse access to users.

You may also create a user from the Query Editor panel in the Administrative DB: iidbdb

Sample SQL:

CREATE USER 'user123’ WITH PASSWORD=’pswd123’, profile=useradmin, group=dbadmingrp;

Table Access

By default, a user does not have access to tables in a warehouse unless they own the warehouse or create the tables. A best practice is to create groups of users and assign table access via groups.

Sample SQL:

GRANT SELECT ON TPCH.supplier TO PUBLIC;
GRANT SELECT ON TPCH.supplier TO user123;

Learn More:

Column Restrictions and Masking

Column masking (data masking) lets you assign the MASKED attribute to columns so that unprivileged users cannot view the data. Visit our documentation to learn more about using data masking.

facebooklinkedinrsstwitterBlogAsset 1PRDatasheetDatasheetAsset 1DownloadForumGuideLinkWebinarPRPresentationRoad MapVideo