Smartello Analytics

AI - Snowflake Assistant by Smartello Analytics A comprehensive Snowflake Native Application built with Python and Streamlit that provides data management, documentation, governance, quality assurance, and analytics capabilities directly within your Snowflake environment. 🚀 Overview Smartello Snowflake Assistant leverages Snowflake's compute, storage, and AI capabilities (Cortex) to deliver a complete suite of tools for modern data operations. The application runs entirely within your Snowflake account, ensuring maximum data security and minimal data movement.

✨ Key Features Data Onboarding Management - Register and track data solutions Data Quality Assurance - Comprehensive data validation and monitoring Automated Documentation - AI-powered code and data documentation Governance & Optimization - User access management and query optimization Code Generation - AI-assisted data pipeline creation 📦 Installation Step 1: Install from Snowflake Marketplace Navigate to Snowflake Marketplace Search for "Smartello Snowflake Assistant" Click "Install" The application will be available in your Apps section for the entire organization Step 2: Grant Database Access Note : Due to Snowflake marketplace restrictions, newly created tables will require explicit access grants. ) Various processing tools (PySpark, SQL Script) Standard features (logging, error handling) Flow diagram upload capability Governance & Optimization User & Role Governance Interactive permission tree visualization User, role, and object-based access analysis Comprehensive permission auditing Warehouse & Query Optimization 30-day credit usage monitoring Slowest query identification (last 7 days) AI-powered query optimization suggestions 🔧 Configuration Application Settings Access admin-level settings via Manage App section (typically for administrators). Help & Support Access built-in help documentation through the Help section within the application.