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.
View Avalanche Getting Started Tutorials
Fast-track your Avalanche experience with our short, quickstart tutorials.
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.
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
CREATE USER 'user123’ WITH PASSWORD=’pswd123’, profile=useradmin, group=dbadmingrp;
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.
GRANT SELECT ON TPCH.supplier TO PUBLIC;
GRANT SELECT ON TPCH.supplier TO user123;