# Data - [Get familiar with our Data module](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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](https://help.tellius.com/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. - [Page](https://help.tellius.com/tellius-documentation/data/page.md) - [Refresh pipeline](https://help.tellius.com/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. --- # 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/tellius-documentation/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.