# singleorigin.tech > AI-optimized mirror of singleorigin.tech containing 97 pages totalling 45,767 words of clean markdown content, structured data, and semantic HTML. Original source: https://singleorigin.tech. Last updated: 2026-07-18T07:35:53.642Z. Each page is available as HTML (with JSON-LD structured data) and Markdown (text-only, ideal for LLMs and RAG). ## Homepage - [public-sandbox/index.html](/content/public-sandbox/index.html) (2 words) - [What is Single Origin?](/content/docs/index.html): Single Origin: The Context Engine & AI Agents for Data Teams Single Origin provides the deep organizational context that generic LLMs lack, and delivers out-of-the-box, specialized AI agents: query optimization, query code review, query debugging, to automate your most critical data workflows. The C… (463 words) - [Single Origin Blog](/content/blog/index.html): Single Origin (150 words) - [Single Origin: Power AI Agents with Deep Context from Your Data Warehouse](/content/site-root.html): Turn raw query logs and operational data into a deep context graph to unlock the hidden insights your AI agents need to streamline workflows and optimize your data warehouse usage (416 words) ## Articles & Blog Posts - [Single Origin Blog (Page 8)](/content/blog/page/8/index.html) (30 words) - [public-sandbox/workbench/create/index.html](/content/public-sandbox/workbench/create/index.html) (2 words) - [public-sandbox/mission-control/query-audit/index.html](/content/public-sandbox/mission-control/query-audit/index.html) (2 words) - [public-sandbox/mission-control/connectors/metadata/index.html](/content/public-sandbox/mission-control/connectors/metadata/index.html) (2 words) - [Single Origin Blog (Page 7)](/content/blog/page/7/index.html) (117 words) - [public-sandbox/search/index.html](/content/public-sandbox/search/index.html) (2 words) - [public-sandbox/consumption/index.html](/content/public-sandbox/consumption/index.html) (2 words) - [public-sandbox/create/index.html](/content/public-sandbox/create/index.html) (2 words) - [public-sandbox/mission-control/index.html](/content/public-sandbox/mission-control/index.html) (2 words) - [Single Origin Blog (Page 6)](/content/blog/page/6/index.html) (169 words) - [Single Origin Blog (Page 5)](/content/blog/page/5/index.html) (140 words) - [Single Origin Blog (Page 4)](/content/blog/page/4/index.html) (139 words) - [Release 2.0.96](/content/docs/changelog/release-2096/index.html): Enable users to highlight high cost tables in the sql editor of query history detail page: High cost table would be marked in orange color. The editor would auto scroll so the high cost table is at the middle of the view port. Enable users to view query history detail of queries that have not been i… (92 words) - [Release 2.0.97](/content/docs/changelog/release-2098/index.html): Enable users to highlight views in the sql editor of query history detail page. Implement action center in table detail page: Use a table to show most commonly used filter conditions so users could generate materialized views for them to speed up queries and reduce the cost. Use a table to show most… (142 words) - [Release 2.0.90](/content/docs/changelog/release-2090/index.html): Turn on json mode by default Add column level to the column usage modal Do not do dedup in leaf node levels Enable the user to go directly to query detail page by clicking the leaf node Refine the table headers in schema tab of table detail page (50 words) - [Release 2.0.93](/content/docs/changelog/release-2093/index.html): Allow users to specify a name for an import. Allow users to add a description to an import. Enable users to write SQL directly to filter queries for an import. Enhance the logic for generating similar filter groups. Optimize the performance of the query list component. (47 words) - [Release 2.0.91](/content/docs/changelog/release-2091/index.html): Add JSON mode to the "Where" column usages in the Schema tab of the Table Detail page. Enable sorting by column and unused column in the Insight page. (29 words) - [Release 2.0.94](/content/docs/changelog/release-2094/index.html): Add unit to bytes. Display row count in a more friendly way. Add scan cost to insight page. Add an explanation section about fields that can be used to filter queries before import. Add a checkebox in simple mode of import modal to enable users to exclude queries whose signatures have been imported … (70 words) - [Release 2.0.95](/content/docs/changelog/release-v2095/index.html): Show scan cost in query detail page. Add action center to query detail page, which can show some useful suggestion to optimize query, like creating mv for high scan cost table, remove duplicates for explosion join and so on. Revamp the import flow to make it more intuitive. (49 words) - [Release 2.0.100](/content/docs/changelog/release-20100/index.html): Add a new tab in table action center to show most commonly used filter conditions that are not included in the query stats but can be deduced from queries. Show table related views in table insight page. Show table related views in the source table section of query history page. Show progress of ong… (60 words) - [Release 2.0.98](/content/docs/changelog/release-2098-1/index.html): Add 'Suggestion' column to query/table insight page linking to action center of query/table detail page. Allow to use special characters to do keyword search. Render time related data such as 'CPU Time', 'Total Execution Time' in a more user friendly way. (42 words) - [Single Origin Blog (Page 3)](/content/blog/page/3/index.html) (142 words) - [Query Inspections](/content/docs/docs/query-inspections/index.html): Query inspection tools Seven tools for investigating any single query or job/run: raw SQL plus warehouse and concurrency context, a compact execution profile, parsed query fragments, the tables a query reads and writes, and per-job aggregates. Your agent typically chains them: fetch the query → look… (726 words) - [MSA](/content/docs/docs/msa/index.html) (3,907 words) - [Tables & References](/content/docs/docs/tables-references/index.html): Table & reference tools Tools for warehouse metadata and the queries hitting a table: look up a table or view by fully-qualified name, resolve a partial or ambiguous reference into a canonical FQN, list the queries that read or produce a table, trace a table's upstream/downstream neighbor tables, i… (1,095 words) - [Recommendations](/content/docs/docs/recommendations/index.html): Recommendation tools Single Origin continuously analyzes your query history and surfaces optimization recommendations — query rewrites, materialized views, cluster keys, query consolidation. These four tools let your agent browse the active recommendation list, drill into any one, see its per-query … (498 words) - [Release 2.0.92](/content/docs/changelog/release-2092/index.html): Refined the algorithm for forming Similar Filter Groups. Added JSON mode support to Similar Filter Groups. Added JSON mode support for "JOIN" column usage in the table detail page. Added JSON mode support for "GROUP BY" column usage in the table detail page. Added JSON mode support for "ORDER BY" co… (58 words) - [Connect Single Origin to OSS Spark](/content/docs/docs/for-spark/index.html): Generate Spark metadata, event-log, and query-history input files for Single Origin. (640 words) - [Privacy Policy](/content/docs/docs/privacy-policy/index.html) (1,492 words) - [Similar Query Clusters](/content/docs/docs/similar-query-clusters/index.html): Similar-query cluster tools Single Origin groups query fragments by structural similarity. A group holds fragments that come from queries sharing the same shape (same tables, joins, aggregates). Fixing the shape of a group's anchor query usually improves every member. These four tools let your agent… (431 words) - [Connect Single Origin to Snowflake](/content/docs/docs/for-snowflake/index.html): Single Origin reads metadata only from your Snowflake account — database, schema, table, view, and column information plus query and usage history. It never reads the contents of your tables. You now connect Single Origin by creating a dedicated read-only role and service user in your own account an… (703 words) - [Built-in Prompts](/content/docs/docs/built-in-prompts/index.html): Built-in prompts In addition to the 30 tools, the Single Origin MCP server ships with five pre-written prompts. They're invoked from your client's prompt palette (in Claude Code, as /singleorigin: ) and orchestrate the right sequence of tool calls for the most common workflows — so your… (675 words) - [SQL Review Rules](/content/docs/docs/sql-review-rule-tools/index.html): SQL review rule tools Single Origin's SQL-review agent checks queries and proposed changes against a set of review rules — free-text instructions injected verbatim into the agent's prompt under a REVIEW RULE OVERRIDES section. These three tools let your agent (or you) list the active rules, add new … (450 words) - [Connect Single Origin to OSS Trino](/content/docs/docs/for-trino-and-presto/index.html) (507 words) - [Connect Single Origin to BigQuery](/content/docs/docs/for-gcp/index.html): Single Origin reads metadata only from your BigQuery environment — dataset, table, view, model, and routine schemas plus job and reservation information. It never reads your actual table data. You now connect Single Origin by granting our service account read-only access to your project's metadata. … (421 words) - [Release Notes](/content/docs/changelog/index.html) (703 words) - [Connect Single Origin to Redshift](/content/docs/docs/for-redshift/index.html): Single Origin reads metadata only from your Amazon Redshift data warehouse — database, schema, table, view, and column definitions plus system catalog and usage information. It never reads the contents of your tables. You now connect Single Origin by creating a dedicated read-only user and role in y… (752 words) - [Table & Column Usage](/content/docs/docs/table-column-usage/index.html): Table & column-usage tools Three tools for understanding how tables and columns are used over a time window: per-column usage (the primary signal for choosing cluster keys and finding dead columns), table-level storage/usage metrics, SQL-parsing health per table, and per-signature scan cost with pru… (515 words) - [Connect Single Origin to Databricks](/content/docs/docs/connect-single-origin-to-databricks/index.html) (665 words) - [User Management](/content/docs/docs/user-management/index.html): User management tools Two tools for listing and creating workspace users. They only appear when the deployment's gRPC backend is configured ( CORE_SERVICE_GRPC_URL ); on a deployment without it, they aren't registered. Access control: the MCP server doesn't apply its own role check — every valid Per… (211 words) - [Overview](/content/docs/docs/mcp-connection/index.html): Single Origin MCP Server New — The Single Origin MCP server is now available. Connect Claude Code, Cursor, or any MCP client. The Single Origin MCP server exposes our query optimization data — query history, execution profiles, table metadata, similar-query clusters, and recommendations — as tools t… (572 words) - [Single Origin Blog (Page 2)](/content/blog/page/2/index.html) (164 words) - [Security](/content/docs/docs/security/index.html): Security and Privacy at Single Origin Single Origin's Security and Privacy teams establish policies and controls, monitor compliance with those controls, and prove our security and compliance to third-party auditors. Data Protection Data at rest All datastores with customer data, in addition to S3 b… (183 words) - [docs/docs/index-2.html](/content/docs/docs/index-2.html) (463 words) - [Scaling Agentic Query Optimization: Uncovering Deep Insights at a Fraction of the Token Cost](/content/blog/scaling-agentic-query-optimization-uncovering-deep-insights-at-a-fraction-of-the-token-cost.html): This post describes how we built a query optimization agent that scales to analyze large query workloads to uncover deep insights that go beyond just the top expensive queries.  The workhorse of our architecture is unique context graph built from raw metadata like query history, query profiles, schemas, table metadata, (899 words, May 22, 2026) - [Understand and Simplify Data Complexity II: Drive Compute Efficiency By Optimizing Query Redundancies](/content/blog/understand-and-simplify-data-complexity-ii-drive-compute-efficiency-by-optimizing-query-redundancies.html): For data engineering teams at large enterprises, cost-efficiency is top of mind.  These organizations are laser focused on paying less to deliver the same insights, or on flattening the cost curve even as data grows exponentially.  One significant hurdle to efficiency is that users tend to write jobs and (1,062 words, Sep 24, 2025) - [Understand and Simplify Data Complexity I: How Column Usage Unlocks Unique Insights](/content/blog/understand-and-simplify-data-complexity/index.html): Today, data volume is exploding — along with redundancies, inefficiencies, and rising costs. The shift to multi- and hybrid-cloud environments adds even more friction for critical operations like data quality, governance, and compliance. At the table level, information is too coarse to address this complexity. Knowing which tables exist or (799 words, Aug 25, 2025) - [Coinbase Optimizes Complex Snowflake Queries at Scale with Single Origin](/content/blog/coinbase-optimizes-complex-snowflake-queries-at-scale-with-single-origin.html): Coinbase used Single Origin to transform their Snowflake query deduplication/rewrite process from manual efforts to efficient, automated intelligence.  At a glance Coinbase is a secure platform for buying, selling, and storing cryptocurrencies.  Challenge Managing complex query deduplication optimization at scale with limited engineering resources. Results Automated query analysis and (781 words, Mar 6, 2025) - [Analyzing and Optimizing SQL at Scale: Single Origin and GPT-4](/content/blog/analyzing-and-optimizing-sql-at-scale-single-origin-and-gpt-4.html): Single Origin's innovative approach offers a more automated, practical, and affordable solution for analyzing and optimizing SQL queries at scale. (552 words, Nov 24, 2023) - [Scale your data and grow efficiently with Single Origin insights](/content/blog/scale-your-data-and-grow-efficiently-with-single-origin-insights.html): The first step towards effective optimization is understanding the costs and determining how the data team can optimize the underlying queries. This is where Single Origin's Insights page comes in handy. (591 words, Nov 1, 2023) - [Decoding Instacart's Data Strategy and Achieving Automated Data Efficiency with Single Origin](/content/blog/instacart-optimizing-queries-and-a-better-way-forward.html): In this article, we'll look at Instacart's approach to optimizing queries. Then, we'll examine how you can achieve the same results in your data cloud for a fraction of the time and effort using the semantic management platform Single Origin (1,033 words, Sep 14, 2023) - [Strategies for Creating Query Collections](/content/blog/strategies-for-creating-query-collections/index.html): Creating a collection in Single Origin is the first step to taming your data asset sprawl. In this post, we will discuss some tips for curating your collections. These strategies will help you create meaningful collections that reveal valuable insights when audited in Single Origin. (631 words, Aug 8, 2023) - [Tame Your Data Asset Sprawl Part III: Simplify Data Observability and Governance at Scale](/content/blog/simplifying-data-flow-and-access/index.html): Intro In the second post of this series, we discussed how semantic management on Single Origin helps companies streamline their data pipelines and save on storage costs. Today, we’re looking at how automated semantic management in Single Origin can simplify data observability and governance at scale. Simplify your data (441 words, Aug 2, 2023) - [Single Origin is now SOC 2 (Type II) compliant](/content/blog/single-origin-is-now-soc-2-compliant/index.html): We proudly announce that Single Origin is SOC 2 compliant, having completed a Phase I audit. (211 words, Jul 19, 2023) - [Tame Your Data Asset Sprawl Part II: Increasing Efficiency with Single Origin](/content/blog/increasing-efficiency-with-single-origin/index.html): Single Origin uses Common Computation Logic to realize cost savings on the scale of 70-90%. Use our platform to save on storage and compute while maximizing the efficiency of your data organization. (457 words, Jul 12, 2023) - [Monthly Product Recap: May 2023](/content/blog/monthly-product-recap-may-2023/index.html): Many exciting things are happening at Single Origin, so let’s grab a ☕ and look at what we worked on in May. (316 words, Jun 20, 2023) - [Tame Your Data Asset Sprawl Part I: Minimizing Costs with Single Origin](/content/blog/cost-savings-in-single-origin/index.html): The Current State of Affairs The one word that might best describe the current state of data assets at companies big and small is sprawl. Companies now understand that the status quo is untenable. Every day, operators are building new pipelines and running new queries. Every dashboard or pipeline added (687 words, Jun 5, 2023) - [Semantic management & data operator efficiency](/content/blog/semantic-management-data-operator-efficiency/index.html): What are the core problems facing data teams today? What features should you look for in a semantic management platform? And how can semantic management optimize and streamline your data assets? (540 words, May 18, 2023) - [Monthly Product Recap: March/April 2023](/content/blog/monthly-product-recap-march-2023/index.html): Many exciting things are happening at Single Origin, so let’s grab a ☕ and look at what we worked on in March and April. (488 words, May 2, 2023) - [The Limits of LLMs: GPT-4 and SQL](/content/blog/the-limits-of-llms-for-now-gpt-4-and-sql/index.html): In today’s article, we’ll put GPT-4 through the paces to examine if LLMs are poised to make Single Origin obsolete. If you’ve been trapped on Everest or stranded on a desert island,  you may not have heard about ChatGPT (but congrats on getting out of there (770 words, Mar 28, 2023) - [Monthly Product Recap: February 2023](/content/blog/monthly-product-recap-february-2023/index.html): At Single Origin, many exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in February. (239 words, Mar 17, 2023) - [How Semantic Management can reduce your overhead and cut query costs by 50-90%](/content/blog/reduce-overhead-and-improve-performance-with-semantic-management.html): This blog explores a common pattern that occurs in ad-hoc SQL queries, and how Single Origin’s semantic management platform can exploit this pattern to save users time and money. If you’d like to learn more about Single Origin, you can visit our website. TL;DR We conducted (1,834 words, Mar 1, 2023) - [Monthly Product Recap: January 2023](/content/blog/monthly-product-recap-january-2023/index.html): At Single Origin, many exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in January. (293 words, Feb 17, 2023) - [Announcing BYOC - Bring Your Own Cloud](/content/blog/announcing-byoc-bring-your-own-cloud/index.html): Satisfy your compliance needs. Deploy Single Origin to your private cloud. One place to simplify, trace, and govern your queries. That has always been the central thesis of Single Origin. Data organizations grow in complexity as they scale. In our day jobs, we saw the wasted time and resources of (535 words, Feb 8, 2023) - [Race to the finish line(age): 3 Field-Level Lineage Solutions](/content/blog/race-to-the-finish-line-age/index.html): Field-level lineage is no longer a nice-to-have feature for organizations with data-intensive workloads. It’s a must have. In this post, we will compare solutions from Google Cloud, OpenLineage, and Single Origin across five categories to see how they compare. (1,669 words, Jan 31, 2023) - [SQL Patterns (and how to exploit them) Part I](/content/blog/sql-patterns-part-1/index.html): Explore SQL patterns and learn how to exploit them to save time and money with Single Origin. (1,201 words, Jan 26, 2023) - [Monthly Product Recap: Welcome 2023!](/content/blog/monthly-recap-welcome-2023/index.html): At Single Origin, many exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in December. (300 words, Jan 13, 2023) - [Monthly Recap: November 2022](/content/blog/monthly-recap-november-2022/index.html): At Single Origin, a lot of exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in November. (322 words, Dec 13, 2022) - [5 Reasons to adopt Single Origin Semantic Management over DBT](/content/blog/dbt-vs-single-origin/index.html): Managing the quality and consistency of your data pipelines and analytics has never been more challenging - or more critical. Data organizations grow in complexity every day. This complexity makes collaborating across your organization or scaling your operations difficult. The dream of simplifying and refining your data platform may feel like (1,239 words, Dec 1, 2022) - [Monthly Recap: October 2022](/content/blog/monthly-recap-october-2022/index.html): At Single Origin, a lot of exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in October. (240 words, Nov 16, 2022) - [Single Origin: ready to serve enterprises!](/content/blog/ready-to-serve/index.html): At Single Origin, we aim to empower companies to organize their data, scale effortlessly, and collaborate efficiently. If you have ever struggled with these for your data stack, then we can help!, Use Loom to record quick videos of your screen and cam. Explain anything clearly and easily – and skip the meeting. An essential tool for hybrid workplaces. (463 words, Oct 20, 2022) - [Single Origin Platform, Part 3: Semantic Management Powers Novel Applications](/content/blog/single-origin-platform-part-3-semantic-management-powers-novel-applications.html): In this series on the Single Origin platform, we will do a deep dive into how Single Origin helps data operators. This is part 3 of the series, looking at how Single Origin defines and implements a semantic management system. (2,151 words, Oct 19, 2022) - [Single Origin Platform, Part 2: Deconstructing SQL queries into Reusable Components](/content/blog/single-origin-platform-part-2-deconstructing-sql-queries-into-reusable-components.html): In this series on the Single Origin platform, we will do a deep dive into how Single Origin helps data operators. This is part 2 of the series, breaking down how we deconstruct a SQL query into reusable components with Single Origin's common definition model. (1,273 words, Oct 14, 2022) - [Monthly Recap: September 2022](/content/blog/monthly-recap-september-2022/index.html): At Single Origin, a lot of exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in September. (285 words, Oct 12, 2022) - [Throughlines: Tracing Data With Field-level Lineage, Part 2](/content/blog/field-level-lineage-part-2/index.html): Field-level lineage demonstrates the SQL transformation between the granular relationships across fields (properties of views, data entities, and dimensions) and columns (properties of datasets). (2,010 words, Oct 11, 2022) - [Monthly Recap: August 2022](/content/blog/monthly-recap-august-2022/index.html): At Single Origin, a lot of exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in August. (277 words, Sep 12, 2022) - [Single Origin Platform, Part 1: Development Principles](/content/blog/so-part-1-principles/index.html): In this series on the Single Origin platform, we will do a deep dive into how Single Origin helps data operators. This is part 1 of the series, focused on explaining some of the principles that guide development of the platform. (705 words, Sep 2, 2022) - [Monthly Recap: July 2022](/content/blog/monthly-recap-july-2022/index.html): At Single Origin, a lot of exciting things are happening, so let’s grab a ☕ and take a look at what we worked on in July. (397 words, Aug 3, 2022) - [Introducing the Single Origin blog!](/content/blog/introducing-the-single-origin-blog/index.html): Welcome! At Single Origin, we are building a data platform with semantic management, quality, and governance tools to help you simplify your data stack, improve collaboration, and generate insights faster. (78 words, Aug 1, 2022) ## Listings & Categories - [Engineering - Single Origin Blog (Page 5)](/content/blog/author/engineering-2/page/5/index.html) (35 words) - [Engineering - Single Origin Blog (Page 4)](/content/blog/author/engineering-2/page/4/index.html) (156 words) - [Engineering - Single Origin Blog (Page 3)](/content/blog/author/engineering/page/3/index.html) (148 words) - [Engineering - Single Origin Blog (Page 3)](/content/blog/author/engineering-2/page/3/index.html) (129 words) - [Engineering - Single Origin Blog (Page 2)](/content/blog/author/engineering/page/2/index.html) (121 words) - [Recap - Single Origin Blog (Page 2)](/content/blog/tag/recap/page/2/index.html) (131 words) - [Recap - Single Origin Blog](/content/blog/tag/recap/index.html) (119 words) - [Engineering - Single Origin Blog](/content/blog/author/engineering/index.html): Engineering @ Single Origin (175 words) - [Engineering - Single Origin Blog (Page 2)](/content/blog/author/engineering-2/page/2/index.html) (147 words) - [News - Single Origin Blog](/content/blog/tag/news/index.html) (73 words) - [Engineering - Single Origin Blog](/content/blog/author/engineering-2/index.html): Engineering @ Single Origin (149 words) - [Platform - Single Origin Blog (Page 2)](/content/blog/tag/platform/page/2/index.html) (42 words) - [Platform - Single Origin Blog](/content/blog/tag/platform/index.html) (143 words) ## About Pages - [Single Origin: Power AI Agents with Deep Context from Your Data Warehouse](/content/about/index.html): Turn raw query logs and operational data into a deep context graph to unlock the hidden insights your AI agents need to streamline workflows and optimize your data warehouse usage (236 words) ## Resources - [Full Page Index](/index.html): Browse all cached pages with rich metadata - [About This Cache](/content/about.html): Methodology, technical details, and usage guidelines - [XML Sitemap](/sitemap.xml): Machine-readable sitemap for crawler discovery - [Robots.txt](/robots.txt): Crawler directives