# Data

- [Get familiar with our Data module](/data/get-familiar-with-our-data-module.md): Explore the Tellius Data module—connect data sources, build datasets, prepare transformations, and create Business Views that simplify analysis for every user.
- [Data Architect Agent](/data/data-architect-agent.md): Use the Tellius Data Architect Agent to build governed data models—automate schema discovery, joins, and validation to create analytics-ready semantic layers fast.
- [Getting started with Data Architect](/data/data-architect-agent/getting-started-with-data-architect.md)
- [What the data architect agent can do?](/data/data-architect-agent/what-the-data-architect-agent-can-do.md)
- [Creating a new Business View workflow](/data/data-architect-agent/creating-a-new-business-view-workflow.md)
- [Detection and resolving issues](/data/data-architect-agent/detection-and-resolving-issues.md)
- [Connect](/data/connect.md): Connect: Navigate, manage, and sort all your datasources in Tellius. Easily refresh, share, filter, and create new connections for seamless data access.
- [Create new datasource](/data/create-new-datasource.md): Discover how to create new data sources in Tellius, optimize connections, and understand connectors for various data types in this comprehensive guide.
- [Connecting to Oracle database](/data/create-new-datasource/connecting-to-oracle-database.md): Learn how to connect Tellius to Oracle—set host, port, service, credentials, browse schemas, load tables, run custom SQL, and configure advanced dataset settings.
- [Connecting to MySQL database](/data/create-new-datasource/connecting-to-mysql-database.md): Connect Tellius to MySQL by entering host details, browsing schemas, importing tables, running custom SQL, and adjusting dataset, caching, or partition settings.
- [Connecting to MS SQL database](/data/create-new-datasource/connecting-to-ms-sql-database.md): Learn how to connect Tellius to an MS SQL database, configure credentials, load tables or custom SQL, enable live mode, and optimize datasets for analysis.
- [Connecting to Postgres SQL database](/data/create-new-datasource/connecting-to-postgres-sql-database.md): Learn how to connect Tellius to Postgres—set host, port, database, schema, load tables, run custom SQL, and configure live mode, caching, and partitioning.
- [Connecting to Teradata](/data/create-new-datasource/connecting-to-teradata.md): Connect Tellius to Teradata using JDBC. Configure host, port, database, and credentials to load tables or run custom SQL queries for analytics and reporting.
- [Connecting to Redshift](/data/create-new-datasource/connecting-to-redshift.md): Connect Tellius to Redshift by entering host, database, schema, region, loading tables, running custom SQL, and configuring live mode, caching, and partitioning.
- [Access S3 Data with Redshift Spectrum](/data/create-new-datasource/connecting-to-redshift/access-s3-data-with-redshift-spectrum.md): Discover how to analyze S3 data effortlessly using Redshift Spectrum. Learn to connect and leverage live datasets without data duplication.
- [Connecting to Hive](/data/create-new-datasource/connecting-to-hive.md): Connect Tellius to Hive using JDBC or Native mode—configure host, schemas, load tables, run custom SQL, and tune dataset, caching, and partition settings.
- [Connecting to Azure Blob Storage](/data/create-new-datasource/connecting-to-azure-blob-storage.md): Connect Tellius to Azure Blob Storage using secure credentials to load, query, and prepare blob files for analysis with support for schema setup, SQL, and advanced settings.
- [Connecting to Spark SQL](/data/create-new-datasource/connecting-to-spark-sql.md): Connect Tellius to Spark SQL securely—configure host, port, and JDBC URL, load tables, or run custom SQL queries for seamless data exploration.
- [Connecting to generic JDBC](/data/create-new-datasource/connecting-to-generic-jdbc.md): Connect to any database using a generic JDBC driver. Configure URLs, drivers, SQL queries, and load or cache datasets for flexible data integration.
- [Connecting to Salesforce](/data/create-new-datasource/connecting-to-salesforce.md): Connect Salesforce to Tellius with this step-by-step guide covering authentication, table loading, custom SQL, and advanced dataset settings.
- [Connecting to Google cloud SQL](/data/create-new-datasource/connecting-to-google-cloud-sql.md): Learn how to connect MySQL, MSSQL, and PostgreSQL Cloud SQL instances on Google Cloud to Tellius. Follow step-by-step setup, prerequisites, and key configuration details.
- [Connecting to a PostgreSQL cloud SQL instance](/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-a-postgresql-cloud-sql-instance.md): Connect Tellius to a PostgreSQL Cloud SQL instance with this step-by-step guide, covering setup, network access, required credentials, and configuration tips.
- [Connecting to an MSSQL cloud SQL instance](/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-an-mssql-cloud-sql-instance.md): Learn how to connect Tellius to a GCP Cloud MSSQL instance with steps for networking, IP allowlisting, credentials, and configuring your connection in the platform.
- [Connecting to a MySQL Cloud SQL Instance](/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-a-mysql-cloud-sql-instance.md): Connecting to a MySQL Cloud SQL Instance is easy with this step-by-step guide. Learn how to set up access, configure networking, and connect securely in Tellius.
- [Connecting to Amazon S3](/data/create-new-datasource/connecting-to-amazon-s3.md): Learn how to connect Tellius to Amazon S3 with this step-by-step guide, covering key-based and role-based access, prerequisites, setup, and permissions.
- [Connecting to Google BigQuery](/data/create-new-datasource/connecting-to-google-bigquery.md): Configure Google BigQuery in Tellius with service accounts, permissions, and support for tables, views, external data, and SQL materialization.
- [Steps to connect to a Google BigQuery database](/data/create-new-datasource/connecting-to-google-bigquery/steps-to-connect-to-a-google-bigquery-database.md): Connect Tellius to Google BigQuery: Set up service accounts, configure JSON keys, assign roles, and manage external tables for seamless data integration.
- [Connecting to Snowflake](/data/create-new-datasource/connecting-to-snowflake.md): Connecting to Snowflake in Tellius is easy with direct authentication. Set up your host, role, and credentials, browse schemas, and import tables for fast analysis.
- [OAuth support for Snowflake](/data/create-new-datasource/connecting-to-snowflake/oauth-support-for-snowflake.md): Learn how to connect Snowflake to Tellius using OAuth for secure, compliant data access. Set up client ID, client secret, and automatic token refresh.
- [Integrating Snowflake with Azure AD via OAuth](/data/create-new-datasource/connecting-to-snowflake/integrating-snowflake-with-azure-ad-via-oauth.md): Integrate Snowflake with Azure AD via OAuth—configure app registrations, scopes, and security settings to enable secure, role-based access.
- [Integrating Snowflake with Okta via OAuth](/data/create-new-datasource/connecting-to-snowflake/integrating-snowflake-with-okta-via-oauth.md): Integrate Okta with Tellius for Snowflake using OIDC. Follow this guide to configure apps, scopes, claims, and OAuth settings for secure authentication.
- [Azure PrivateLink](/data/create-new-datasource/connecting-to-snowflake/azure-privatelink.md): Integrate Snowflake with Azure Private Link in Tellius—configure private endpoints, DNS zones, and secure connections for enhanced data protection.
- [AWS PrivateLink](/data/create-new-datasource/connecting-to-snowflake/aws-privatelink.md): Securely connect Tellius to Snowflake using AWS PrivateLink—establish private VPC endpoints for direct, secure data access without public internet.
- [Best practices](/data/create-new-datasource/connecting-to-snowflake/best-practices.md): Optimize the Snowflake performance with Tellius using best practices for Live Mode, data modeling, indexing, transformations, and efficient ML insights.
- [Connecting to Databricks](/data/create-new-datasource/connecting-to-databricks.md): Learn how to connect Databricks to Tellius by generating a JDBC URL and personal access token, configuring the connection, and securely browsing warehouse data.
- [Connecting to Databricks Delta Lake](/data/create-new-datasource/connecting-to-databricks-delta-lake.md): Connect Databricks Delta Lake to Tellius to securely browse, query, and load Delta tables. Import data with custom SQL, live mode, caching, and advanced settings.
- [Connecting to an AlloyDB Cluster](/data/create-new-datasource/connecting-to-an-alloydb-cluster.md): Connect an AlloyDB cluster to Tellius using the AlloyDB Auth Proxy. Set up credentials, gather instance URIs, and securely browse and load data for analysis.
- [Connecting to HDFS](/data/create-new-datasource/connecting-to-hdfs.md): Load data from HDFS into Tellius with support for CSV, Parquet, JSON, XML, and Excel. Configure parsing, caching, and advanced settings for faster analytics.
- [Connecting to Looker SQL Interface](/data/create-new-datasource/connecting-to-looker-sql-interface.md): Set up and authenticate the Looker SQL Interface in Tellius, configure connections with Client ID and Secret, and import Looker tables for analysis.
- [Loading Excel sheets](/data/create-new-datasource/loading-excel-sheets.md): Upload Excel sheets into Tellius with ease—set dataset names, choose sheets, enable caching, and configure geospatial or date fields for fast, accurate analysis.
- [Understanding partitioning your data](/data/create-new-datasource/understanding-partitioning-your-data.md): Learn how data partitioning boosts performance in Tellius by splitting large datasets into efficient, balanced partitions for faster loading and querying.
- [Time-to-Live (TTL) and Caching](/data/time-to-live-ttl-and-caching.md): Learn how TTL and caching work in Tellius—optimize query performance, manage cache expiration, and balance speed with data freshness for analytics.
- [Refreshing a datasource](/data/refreshing-a-datasource.md): Keep your data up-to-date with immediate, one-time, or recurring datasource refresh options in Tellius, ensuring accurate and timely analytics.
- [Managing your datasets](/data/managing-your-datasets.md): Manage all your datasets in Tellius with a unified view of types, refresh times, owners, schedules, and actions like sharing, copying, archiving, or deleting.
- [Swapping datasources](/data/managing-your-datasets/swapping-datasources.md): Swap datasources seamlessly during migrations or vendor changes, keeping dashboards, datasets, and workflows intact with minimal disruption.
- [Preparing your datasets](/data/preparing-your-datasets.md): Prepare datasets in Tellius by transforming, cleansing, and organizing data—use metadata, scripting, and scheduling to make data analytics-ready and scalable.
- [Actions that can be done on a dataset](/data/preparing-your-datasets/actions-that-can-be-done-on-a-dataset.md): Manage datasets with options to rename, copy, share, classify as fact or dimension, export, or delete, making it easier to organize and prepare data for analysis.
- [Data Pipeline](/data/preparing-your-datasets/data-pipeline.md): Track every transformation in your dataset with a visual pipeline that logs each step, shows who made changes, and lets you restore previous versions instantly.
- [SQL code snippets](/data/preparing-your-datasets/sql-code-snippets.md): Explore SparkSQL code snippets to handle time zones, averages, bins, window functions, and conditional logic in the Tellius SQL editor for faster prep.
- [Writeback window](/data/preparing-your-datasets/writeback-window.md): Customize how you export datasets with flexible column selection, preview options, and overwrite or append modes to publish refined data back to your chosen system.
- [Editing Prepare → Data](/data/preparing-your-datasets/editing-prepare-data.md): Review column stats, apply filters, sort values, and perform essential data transformations—like type changes, merges, and text cleanup—within Prepare → Data.
- [Handling null or mismatched values](/data/preparing-your-datasets/handling-null-or-mismatched-values.md): Handle missing or inconsistent data in Tellius by dropping rows, replacing nulls with mean or fixed values, and reconciling mismatched column types.
- [Metadata view](/data/preparing-your-datasets/metadata-view.md): Master the Metadata view in Tellius to edit display names, data types, aggregations, special types, synonyms, and indexing for accurate analytics and Insights.
- [List of icons and their actions](/data/preparing-your-datasets/list-of-icons-and-their-actions.md): Explore all icons in Data → Prepare, including undo, SQL, Python, filters, hierarchies, and export tools to manage, transform, and refine datasets in Tellius.
- [Functions](/data/preparing-your-datasets/list-of-icons-and-their-actions/functions.md): Create custom dataset transformations with Indicators and Signatures in Tellius, using formulas and conditional logic to build new metrics and classifications.
- [SQL Transform](/data/preparing-your-datasets/list-of-icons-and-their-actions/sql-transform.md): Create, edit, and validate SQL transformations in Tellius to join, filter, aggregate, and cleanse datasets. Run code on your warehouse and apply changes instantly.
- [Python Transform](/data/preparing-your-datasets/list-of-icons-and-their-actions/python-transform.md): Python Transform in Tellius lets you create, edit, and apply Pandas or PySpark code to cleanse, enrich, and engineer data—validate, run, and save.
- [Standard Aggregation](/data/preparing-your-datasets/list-of-icons-and-their-actions/standard-aggregation.md): Create summary tables with Standard Aggregation. Group data, apply sums, averages, and counts, and generate multi-dimensional insights for deeper analysis.
- [Creating Hierarchies](/data/preparing-your-datasets/list-of-icons-and-their-actions/creating-hierarchies.md): Create clear multi-level data hierarchies for intuitive drill-down analysis, enabling smooth navigation from summary metrics to detailed insights for smarter decisions.
- [Dataset Scripting](/data/preparing-your-datasets/dataset-scripting.md): Create advanced datasets in Tellius using custom SQL. Join multiple tables, run complex transformations, validate scripts, and build powerful reusable data pipelines.
- [Fusioning your datasets](/data/preparing-your-datasets/fusioning-your-datasets.md): Learn how to quickly merge two datasets in Tellius using Data Fusion. Choose join types, match columns, and create a fused dataset without writing SQL.
- [Scheduling refresh for datasets](/data/preparing-your-datasets/scheduling-refresh-for-datasets.md): Schedule automated dataset refreshes, manage linked updates, and receive delivery reports to keep your data, dashboards, and Business Views accurate and up to date.
- [Preparing your Business Views](/data/preparing-your-business-views.md): Prepare Business Views in Tellius by organizing datasets, configuring columns, adding calculations, and managing refresh settings for analytics-ready data.
- [Create a new Business View](/data/preparing-your-business-views/create-a-new-business-view.md): Learn how to create a new Business View to organize datasets, configure advanced settings, and optimize performance for analytics.
- [Editing a Business View](/data/preparing-your-business-views/editing-a-business-view.md): Learn how to edit a Business View in Tellius—update metadata, manage datasets, and configure settings to improve query performance, search accuracy, and analytics.
- [Creating calculated columns](/data/preparing-your-business-views/creating-calculated-columns.md): Create custom row-level or aggregated calculated columns in Tellius to extend datasets with business metrics, KPIs, and reusable formulas—all without altering source data.
- [Creating dynamic parameters](/data/preparing-your-business-views/creating-dynamic-parameters.md): Create dynamic parameters in Tellius to power flexible what-if analysis, letting users adjust values in real time and reuse calculations without modifying the underlying Business View.
- [Scheduling refresh for Business Views](/data/preparing-your-business-views/scheduling-refresh-for-business-views.md): Schedule refresh for Business Views in Tellius—sync with dataset updates to keep analytics accurate, up to date, and aligned with real-time data changes.
- [Setting up custom calendars](/data/preparing-your-business-views/setting-up-custom-calendars.md): Create custom ISO or fiscal calendars in Tellius to match your business timelines. Set weeks, months, and quarters for accurate reporting.
- [Custom Calendars for Live Connections](/data/preparing-your-business-views/custom-calendars-for-live-connections.md): Configure and map custom fiscal calendars for live Snowflake, Redshift, BigQuery, and Spark SQL connections in Tellius to enable accurate time-based filtering and analysis.
- [Dynamic metric matching](/data/preparing-your-business-views/dynamic-metric-matching.md): Create context-aware dynamic metrics that replace long CASE WHEN logic in Tellius, automatically adapting calculations based on grouping levels and filters.
- [Mapping measures to date columns](/data/preparing-your-business-views/mapping-measures-to-date-columns.md): Use Date Mapping in Tellius to align measures with their correct date columns, ensuring accurate time filters and consistent timelines across Vizpads.
- [Tellius Engine: Comparison of In-Memory vs. Live Mode](/data/tellius-engine-comparison-of-in-memory-vs.-live-mode.md): Compare in-memory vs live mode in Tellius—balance speed, real-time data access, and ML capabilities to choose the best approach for analytics workflows.
- [Refresh pipeline](/data/refresh-pipeline.md): The new Refresh Pipeline offers a  a smart orchestration layer to schedule, manage, and monitor Business View and dataset refreshes.