CloudLink Script Setup

# Must meet Snowflake password requirements:
# - At least 8 characters
# - Mix of uppercase, lowercase, numbers
# - At least one special character
# - Cannot contain username or common words

# Example strong password format:
ElementumData2024!SecurePass

-- The script includes these main sections:

-- 1. Variable Setup
set USER_PASSWORD='YourSecurePassword123!';

-- 2. Role Creation
CREATE ROLE IF NOT EXISTS ELEMENTUM;
GRANT ROLE ELEMENTUM TO ROLE SYSADMIN;

-- 3. User Creation
CREATE USER IF NOT EXISTS ELEMENTUM
MUST_CHANGE_PASSWORD=false
PASSWORD=$USER_PASSWORD;

-- 4. Warehouse Creation
CREATE WAREHOUSE IF NOT EXISTS ELEMENTUM
WITH WAREHOUSE_SIZE='MEDIUM',
MIN_CLUSTER_COUNT = 1,
MAX_CLUSTER_COUNT = 10,
AUTO_SUSPEND=60;

-- 5. Database and Schema Setup
CREATE DATABASE IF NOT EXISTS ELEMENTUM;
CREATE SCHEMA IF NOT EXISTS ELEMENTUM_PLATFORM;
CREATE SCHEMA IF NOT EXISTS PUBLIC;

-- 6. Cortex AI Access
GRANT DATABASE ROLE SNOWFLAKE.CORTEX_USER TO ROLE ELEMENTUM;

-- Uncomment and customize these lines for each table:
USE ROLE SYSADMIN;
USE DATABASE "YOUR_DATABASE_NAME";
GRANT SELECT ON TABLE "YOUR_TABLE_NAME" TO ROLE ELEMENTUM;

-- For tables that need write access:
GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE "YOUR_TABLE_NAME" TO ROLE ELEMENTUM;

-- Example for a customer table:
USE DATABASE "SALES_DB";
GRANT SELECT ON TABLE "CUSTOMERS" TO ROLE ELEMENTUM;
GRANT SELECT ON TABLE "ORDERS" TO ROLE ELEMENTUM;

-- Test that the service account can log in
-- (Run this in a new worksheet or session)
USE ROLE ELEMENTUM;
USE WAREHOUSE ELEMENTUM;
USE DATABASE ELEMENTUM;

-- Should execute without errors
SELECT CURRENT_ROLE(), CURRENT_WAREHOUSE(), CURRENT_DATABASE();