How-to Guides
These practical guides show you how to solve specific problems and accomplish specific tasks in Coginiti.
Available Guides
Installation and Setup
- How to Install Coginiti Team - Complete installation guide from prerequisites through final configuration
- How to Install Coginiti Enterprise on EKS - Enterprise deployment on Amazon Elastic Kubernetes Service with AWS-native services
- How to Install Coginiti Enterprise on GKE - Enterprise deployment on Google Kubernetes Engine using public container registries
- How to Install Coginiti Enterprise on GKE (Air-Gapped) - Enterprise deployment on Google Kubernetes Engine in air-gapped environments
Authentication and Security
- How to Configure OAuth OIDC Authentication - Set up single sign-on with popular identity providers like Okta, Azure AD, and Google
- How to Configure User Management - Manage users with manual creation, LDAP integration, or OAuth OIDC authentication
- How to Set Up a Consumer with a Semantic Connection and AI Access - Onboard a read-only Consumer: assign the Consumer role, share the database and semantic connections, and confirm AI chat access
- How to Configure AI Assistant - Set up AI-powered code generation with Azure OpenAI, Amazon Bedrock, OpenAI, and Anthropic
Operations and Monitoring
- How to Configure Logging and Monitoring - Access system logs and integrate with external monitoring systems like Graylog, Logstash, and ELK Stack
Data Connections
- How to Set Up Data Connections - Comprehensive JDBC setup, driver management, and authentication methods for databases, object stores, and local files
- How to Connect to Databases - Step-by-step connection setup for PostgreSQL, MySQL, and SQL Server
- How to Connect to Semantic Layer via JDBC - Connect BI tools and applications to the Semantic Layer using JDBC driver
- How to Connect to Semantic Layer via ODBC - Connect BI tools and applications to the Semantic Layer using the ODBC driver on Windows
- How to Connect to Object Stores - Configure connections to AWS S3, MinIO, Azure Blob Storage, and Google Cloud Storage
- How to Manage Local Files - Access and work with local directories, CSV, Parquet, and SQL files directly in Coginiti
- How to Manage Connection Templates - Standardize database connections and manage user access with templates
Project Management
- How to Structure Your Project Hub - Choose organizational patterns and implement security-conscious folder structures with waterfall permissions
- How to Manage Analytics Catalog - Organize, version, share, and publish data analysis projects across Personal, Shared, and Project Hub workspaces
- How to Share Project With Semantic Layer - Publish a project with a configured semantic layer to Project Hub and grant users access to query it via semantic SQL or JDBC
Data Visualization
- How to Create Advanced Charts and Visualizations - Create candlestick charts, box plots, and interactive data visualizations with filtering
AI and Automation
- AI Assistant Use Cases - Comprehensive guide to AI-powered code analysis, generation, testing, and optimization
- How to Use AI Assistant Slash Commands - Use /fetch, /web, and /help commands for enhanced AI capabilities with real-time web access
CoginitiScript
- How to Create and Use Macros - Create reusable code snippets with CoginitiScript macros
- How to Dynamically Generate SQL - Build flexible queries using loops, conditionals, and templates
- How to Configure Runtime Environments - Set up multiple named environments with connection and schema overrides
- CoginitiScript for dbt Core Users - Map dbt models, refs, materializations, Jinja, and tests to their CoginitiScript equivalents
Project Review
- Create Project Review - Create your first Project Review
Coginiti Actions
- Creating Coginiti Actions - Create your automated data workflows using Coginiti Actions to streamline your data processing tasks
Coming Soon
We're working on adding more how-to guides. Topics will include:
- Query optimization
- Data export and import
- Security configuration
- Integration setup
Each guide focuses on a specific problem and provides clear, actionable steps to solve it. These guides assume you have some familiarity with Coginiti basics.