# Data - [Get familiar with our Data module](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/data/data-architect-agent/getting-started-with-data-architect.md) - [What the data architect agent can do?](https://help.tellius.com/data/data-architect-agent/what-the-data-architect-agent-can-do.md) - [Creating a new Business View workflow](https://help.tellius.com/data/data-architect-agent/creating-a-new-business-view-workflow.md) - [Detection and resolving issues](https://help.tellius.com/data/data-architect-agent/detection-and-resolving-issues.md) - [Connect](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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. - [Soft linking a Business View](https://help.tellius.com/data/preparing-your-business-views/soft-linking-a-business-view.md) - [Setting up custom calendars](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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. - [Page](https://help.tellius.com/data/page.md) - [Refresh pipeline](https://help.tellius.com/data/refresh-pipeline.md): The new Refresh Pipeline offers a a smart orchestration layer to schedule, manage, and monitor Business View and dataset refreshes. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.tellius.com/data.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.