# Data

- [Get familiar with our Data module](/tellius-documentation/data/get-familiar-with-our-data-module.md): Discover how to manage data sources, refine datasets, and create Business Views in Tellius for intuitive, self-service analytics.
- [Connect](/tellius-documentation/data/connect.md): Explore how to connect, sort, share, and manage datasources with clear navigation, searchable lists, permissions, and scheduling for efficient data management.
- [Create new datasource](/tellius-documentation/data/create-new-datasource.md): Create a new datasource in Tellius—connect databases, files, and cloud sources with secure authentication, flexible connectors, and optimized data ingestion.
- [Connecting to Oracle database](/tellius-documentation/data/create-new-datasource/connecting-to-oracle-database.md): Learn how to connect Oracle databases to Tellius using host, port, service name, SQL previews, and advanced settings for live or imported datasets.
- [Connecting to MySQL database](/tellius-documentation/data/create-new-datasource/connecting-to-mysql-database.md): Connect Tellius to MySQL—configure host, port, database, and credentials to browse schemas, import tables, and run queries for scalable analytics.
- [Connecting to MS SQL database](/tellius-documentation/data/create-new-datasource/connecting-to-ms-sql-database.md): Connect Tellius to a Google Cloud SQL MSSQL instance—configure networking, IP allowlisting, and credentials to securely access and analyze data.
- [Connecting to Postgres SQL database](/tellius-documentation/data/create-new-datasource/connecting-to-postgres-sql-database.md): Learn how to connect Postgres to Tellius, load tables or custom SQL, use advanced JDBC options, enable live mode, caching, partitioning, and edit SQL loads easily.
- [Connecting to Teradata](/tellius-documentation/data/create-new-datasource/connecting-to-teradata.md): Learn how to connect Teradata to Tellius using JDBC, load tables or custom SQL, enable live mode, caching, and partitioning, and prepare datasets for analysis.
- [Connecting to Redshift](/tellius-documentation/data/create-new-datasource/connecting-to-redshift.md): Connect Tellius to Amazon Redshift—configure host, port, database, and schema to load tables, run SQL queries, and enable scalable analytics.
- [Access S3 Data with Redshift Spectrum](/tellius-documentation/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](/tellius-documentation/data/create-new-datasource/connecting-to-hive.md): A step-by-step guide to establish a new connection with Hive database using JDBC or Native mode, load tables with SQL, and optimize datasets in Tellius.
- [Connecting to Azure Blob Storage](/tellius-documentation/data/create-new-datasource/connecting-to-azure-blob-storage.md): Connect Tellius to Azure Blob Storage securely using your account credentials, container path, and file details to query, analyze, and visualize blob data.
- [Connecting to Spark SQL](/tellius-documentation/data/create-new-datasource/connecting-to-spark-sql.md): A step-by-step guide to connect Spark SQL to Tellius, configure JDBC or advanced options, load tables or custom SQL, and optimize datasets for analytics.
- [Connecting to generic JDBC](/tellius-documentation/data/create-new-datasource/connecting-to-generic-jdbc.md): Guide to connecting any database using the generic JDBC connector in Tellius, configuring drivers and URLs, loading tables or SQL, and optimizing datasets.
- [Connecting to Salesforce](/tellius-documentation/data/create-new-datasource/connecting-to-salesforce.md): Guide to connecting Salesforce to Tellius, setting credentials and security token, browsing objects, importing data, and managing dataset settings for analytics.
- [Connecting to Google cloud SQL](/tellius-documentation/data/create-new-datasource/connecting-to-google-cloud-sql.md): Connect Tellius to Google Cloud SQL—configure MySQL, PostgreSQL, or MSSQL with IP, ports, and credentials to securely access and analyze cloud data.
- [Connecting to a PostgreSQL cloud SQL instance](/tellius-documentation/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-a-postgresql-cloud-sql-instance.md): Connect to a PostgreSQL Cloud SQL instance step-by-step. Configure IP, networking, and credentials to link your database for seamless analytics.
- [Connecting to an MSSQL cloud SQL instance](/tellius-documentation/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-an-mssql-cloud-sql-instance.md): Set up your MSSQL Cloud SQL connection in Tellius with this clear guide. Learn how to configure networking, authorized IPs, database details, and user access.
- [Connecting to a MySQL Cloud SQL Instance](/tellius-documentation/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-a-mysql-cloud-sql-instance.md): Connect your MySQL Cloud SQL instance to Tellius with this configuration guide. Learn how to set up networking, authorized IPs, database details, and user access.
- [Connecting to Amazon S3](/tellius-documentation/data/create-new-datasource/connecting-to-amazon-s3.md): Connect Amazon S3 to Tellius using key-based or role-based access. Learn how to set up IAM credentials, permissions, and securely load data from your S3 buckets.
- [Connecting to Google BigQuery](/tellius-documentation/data/create-new-datasource/connecting-to-google-bigquery.md): Guide to configuring Google BigQuery in Tellius, setting service accounts and permissions, and loading data from tables, views, external sources, and SQL queries.
- [Steps to connect to a Google BigQuery database](/tellius-documentation/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](/tellius-documentation/data/create-new-datasource/connecting-to-snowflake.md): Connect Tellius to Snowflake using OAuth, key-pair, or direct login—configure secure access, roles, and credentials to query data and enable scalable analytics.
- [OAuth support for Snowflake](/tellius-documentation/data/create-new-datasource/connecting-to-snowflake/oauth-support-for-snowflake.md): Learn how to configure OAuth support for Snowflake in Tellius for secure, password-free data access, automated token refresh, and seamless connectivity.
- [Integrating Snowflake with Azure AD via OAuth](/tellius-documentation/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](/tellius-documentation/data/create-new-datasource/connecting-to-snowflake/integrating-snowflake-with-okta-via-oauth.md): Integrate Okta with Tellius for Snowflake using OIDC. Follow this step-by-step guide for app setup, claims, scopes, and OAuth connection settings.
- [Azure PrivateLink](/tellius-documentation/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](/tellius-documentation/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](/tellius-documentation/data/create-new-datasource/connecting-to-snowflake/best-practices.md): Guide to Snowflake best practices in Tellius, covering Live Mode use, clustering, data modeling, transformations, and performance tips for efficient analytics.
- [Connecting to Databricks](/tellius-documentation/data/create-new-datasource/connecting-to-databricks.md): Connect Databricks to Tellius using your JDBC URL and Personal Access Token. Learn how to retrieve credentials, configure the connection, and start loading data.
- [Connecting to Databricks Delta Lake](/tellius-documentation/data/create-new-datasource/connecting-to-databricks-delta-lake.md): Connect Tellius to Databricks Delta Lake to browse, query, and import Delta tables for analytics and AI-driven insights using JDBC URLs and custom SQL.
- [Connecting to an AlloyDB Cluster](/tellius-documentation/data/create-new-datasource/connecting-to-an-alloydb-cluster.md): Connect Tellius to your AlloyDB cluster using the AlloyDB Auth Proxy to securely browse, query, and load database tables for analysis and insights.
- [Connecting to HDFS](/tellius-documentation/data/create-new-datasource/connecting-to-hdfs.md): Connect Tellius to your Hadoop HDFS environment to browse files, parse formats like CSV, JSON, or Parquet, and load datasets for fast analytics and exploration.
- [Connecting to Looker SQL Interface](/tellius-documentation/data/create-new-datasource/connecting-to-looker-sql-interface.md): Configure the Looker SQL Interface in Tellius by setting up credentials, testing connections, and importing tables for seamless exploration and analytics.
- [Loading Excel sheets](/tellius-documentation/data/create-new-datasource/loading-excel-sheets.md): Load Excel sheets into Tellius—upload files, select sheets, and configure data types to quickly ingest spreadsheet data for analysis and insights.
- [Understanding partitioning your data](/tellius-documentation/data/create-new-datasource/understanding-partitioning-your-data.md): Learn how data partitioning in Tellius works, how to set partition columns, bounds, and counts, and how it boosts data loading and query performance.
- [Time-to-Live (TTL) and Caching](/tellius-documentation/data/time-to-live-ttl-and-caching.md): Overview of how TTL and caching work in Tellius, including in-memory and live dataset behavior, expiration rules, limits, and performance considerations.
- [Refreshing a datasource](/tellius-documentation/data/refreshing-a-datasource.md): Refresh a datasource in Tellius to keep data up to date—run immediate, one-time, or scheduled refreshes for accurate, timely analytics and insights.
- [Managing your datasets](/tellius-documentation/data/managing-your-datasets.md): Manage datasets in Tellius—view types, owners, refresh schedules, and actions like sharing, copying, and archiving to keep data organized and analytics-ready.
- [Swapping datasources](/tellius-documentation/data/managing-your-datasets/swapping-datasources.md): Swap datasources seamlessly in Tellius to support migrations, vendor changes, and environment shifts while keeping datasets, dashboards, and workflows intact.
- [Preparing your datasets](/tellius-documentation/data/preparing-your-datasets.md): Prepare datasets in Tellius by transforming, cleansing, and organizing data—use metadata, scripting, fusion, and scheduling to make data analytics-ready.
- [Actions that can be done on a dataset](/tellius-documentation/data/preparing-your-datasets/actions-that-can-be-done-on-a-dataset.md): Manage datasets easily with options to rename, copy, share, export, classify as fact or dimension, delete safely with confirmation, and organize into folders.
- [Data Pipeline](/tellius-documentation/data/preparing-your-datasets/data-pipeline.md): Visualize every transformation in your dataset with the Data Pipeline. Track actions, view details, restore past stages, and manage data changes with full transparency.
- [SQL code snippets](/tellius-documentation/data/preparing-your-datasets/sql-code-snippets.md): Quickly transform columns, create rolling averages, build bins, or run more complex window functions
- [Writeback window](/tellius-documentation/data/preparing-your-datasets/writeback-window.md): Use the Writeback window in Tellius to export datasets—select columns, preview data, and append or overwrite tables across cloud and database connectors.
- [Editing Prepare → Data](/tellius-documentation/data/preparing-your-datasets/editing-prepare-data.md): Explore dataset transformations in Tellius—review column stats, filter or sort rows, update data types, and clean fields to prepare high-quality data.
- [Handling null or mismatched values](/tellius-documentation/data/preparing-your-datasets/handling-null-or-mismatched-values.md): Manage missing and mismatched values in your datasets with flexible options to drop rows, replace nulls, fix outliers, and ensure clean, consistent data for analysis.
- [Metadata view](/tellius-documentation/data/preparing-your-datasets/metadata-view.md): Explore Tellius Metadata View to inspect, edit, and manage column properties, data types, aggregations, and insights for accurate analysis.
- [List of icons and their actions](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions.md): Explore all icons in the Tellius Data → Prepare panel. Learn each icon’s function—from Undo and Export to SQL, Python, and Aggregation—for efficient data prep.
- [Functions](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions/functions.md): Create powerful custom transformations in Tellius using Indicators and Signatures to build formulas, apply conditional logic, enrich datasets, and generate new metrics.
- [SQL Transform](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions/sql-transform.md): Use SQL Transform in Tellius to join, filter, aggregate, and cleanse datasets—run transformations directly on your data warehouse for scalable analytics.
- [Python Transform](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions/python-transform.md): Apply advanced data transformations using Python in Tellius. Cleanse, enrich, and customize datasets with Pandas or PySpark for complex logic.
- [Standard Aggregation](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions/standard-aggregation.md): Use Tellius Standard Aggregation to group data, apply sum or average functions, and create multi-dimensional summaries for sales, customer, or performance analysis.
- [Creating Hierarchies](/tellius-documentation/data/preparing-your-datasets/list-of-icons-and-their-actions/creating-hierarchies.md): Build custom hierarchies in Tellius to organize dimensions, enable intuitive drill-downs, and explore data from high-level summaries to detailed granular insights.
- [Dataset Scripting](/tellius-documentation/data/preparing-your-datasets/dataset-scripting.md): Use dataset scripting in Tellius to write custom SQL, join multiple tables, and perform advanced transformations for scalable, reusable analytics pipelines.
- [Fusioning your datasets](/tellius-documentation/data/preparing-your-datasets/fusioning-your-datasets.md): Quickly merge two datasets in Tellius using point-and-click Data Fusion. Choose join types, map columns, and create unified datasets without writing SQL.
- [Scheduling refresh for datasets](/tellius-documentation/data/preparing-your-datasets/scheduling-refresh-for-datasets.md): Schedule dataset refresh in Tellius—run instant, one-time, or recurring updates to keep data fresh, accurate, and aligned with dashboards and analytics.
- [Preparing your Business Views](/tellius-documentation/data/preparing-your-business-views.md): Create Business Views in Tellius to curate datasets, manage columns, add calculations, organize folders, control sharing, and prepare analytics-ready data.
- [Create a new Business View](/tellius-documentation/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.
- [Creating calculated columns](/tellius-documentation/data/preparing-your-business-views/creating-calculated-columns.md): Create custom calculated columns in Tellius to add row or column-level formulas, define KPIs, extend datasets with business logic, and prepare data for deeper analysis.
- [Creating dynamic parameters](/tellius-documentation/data/preparing-your-business-views/creating-dynamic-parameters.md): Create dynamic parameters in Tellius to enable what-if analysis—adjust values in real time, reuse calculations, and explore scenarios without modifying data.
- [Scheduling refresh for Business Views](/tellius-documentation/data/preparing-your-business-views/scheduling-refresh-for-business-views.md): Schedule Business View refreshes in Tellius to keep analytics current and automatically sync BV data whenever the underlying dataset is updated for accuracy.
- [Setting up custom calendars](/tellius-documentation/data/preparing-your-business-views/setting-up-custom-calendars.md): Set up custom ISO or fiscal calendars to match your business timelines. Easily define weeks, months, and quarters and apply them to your Business Views.
- [Custom Calendars for Live Connections](/tellius-documentation/data/preparing-your-business-views/custom-calendars-for-live-connections.md): Configure custom calendars in Tellius for live connections—map fiscal calendars, enable accurate time-based filtering, and align analytics with business reporting.
- [Dynamic metric matching](/tellius-documentation/data/preparing-your-business-views/dynamic-metric-matching.md): Dynamic Metric Matching lets you replace complex CASE logic with a smart, context-aware metric that adapts to groupings and filters for faster, cleaner analysis.
- [Tellius Engine: In-Memory vs. Live Mode](/tellius-documentation/data/tellius-engine-in-memory-vs.-live-mode.md): Compare In-memory vs Live mode to understand differences in performance, real-time access, and machine learning support. Choose the best fit for your analytics.
- [Refresh pipeline](/tellius-documentation/data/refresh-pipeline.md): The new Refresh Pipeline offers a visual, intelligent orchestration layer to schedule, manage, and monitor Business View and dataset refreshes.