Answers to the questions we hear most about Gudu SQLFlow — what it does, how it treats your data, the editions and 価格設定, how to get SQL in and lineage out, and how to manage your account.
New to SQLFlow? クエリを貼り付けて free online visualizer and watch its column-level lineage appear — no signup needed for public examples.
About SQLFlow
What is Gudu SQLFlow?
Gudu SQLFlow は自動化された SQLデータリネージツール. You give it SQL — queries, stored procedures, dbt projects, or a whole database — and it produces an interactive, 列レベルのデータリネージ diagram that shows exactly where every piece of data comes from and where it goes. It works by static analysis of your SQL code, so it never needs access to your data.
What is column-level data lineage?
Table-level lineage tells you that one table is built from another. 列レベルの系統 tells you, for every output column, the exact source columns that feed it and the functions, joins, and set operations along the way. That granularity is what makes impact analysis and audit answers precise instead of approximate.
間接的（影響）系譜とは何ですか？
A column used in a どこ clause, a 参加する condition, or a グループ分け never lands in the output, but it absolutely shapes the result. SQLFlow models this influence as a distinct, toggleable relationship type — indirect lineage — so you can see pure data flow or the full impact surface. Most lineage tools do not make this distinction, and it is exactly what impact analysis needs.
Which SQL dialects does SQLFlow support?
39 dialects, each with its own dedicated parser rather than a generic ANSI approximation: Snowflake, BigQuery, Redshift, Databricks, Azure SQL, Athena, Oracle, SQL Server, PostgreSQL, MySQL, IBM Db2, Teradata, Netezza, Greenplum, Vertica, SAP HANA, Hive, Impala, Spark SQL, Presto, Trino, ClickHouse, DuckDB, and more. You choose the dialect for each analysis.
Can SQLFlow analyze stored procedures and dynamic SQL?
Yes — this is one of its strongest capabilities. Oracle PL/SQL and SQL Server T-SQL have dedicated procedural parsers. SQLFlow traces lineage through procedure parameters and temp tables, resolves dynamic SQL assembled inside procedures, and draws an interactive call graph of which procedures invoke which.
SQLFlowはdbtをサポートしていますか？
はい。dbtマニフェストをインポートすると、SQLFlowがdbtモデル全体にわたる列レベルのデータリネージを生成し、モデルとそれらが構築するウェアハウスオブジェクトとの整合性を取ることができます。
How is SQLFlow different from open-source parsers like sqlglot or sqllineage?
オープンソースプロジェクト sqlglot と SQL Lineage are good tools for parsing individual queries, and for simple SELECT/INSERT statements they may be all you need. The gap appears on real production code: stored procedures and dynamic SQL, dialect-specific syntax across dozens of engines, star-expansion and view resolution that need schema context, indirect lineage through filter and join conditions, and visualizing lineage at the scale of thousands of scripts.
SQLFlowは、 汎用SQLパーサー, a commercial SQL compiler front-end developed since the mid-2000s and validated against roughly 13,000 per-dialect test fixtures. That depth on hard SQL is the difference. If you are evaluating, run your gnarliest stored procedure through both and compare.
Data, security & deployment
SQLFlowは私のデータを読み取りますか？
No. SQLFlow performs static analysis of SQL code and optionally reads schema metadata — table and column definitions. It never reads the rows in your tables. There is no code path that reads business data.
Can I run SQLFlow inside my own network or air-gapped?
はい。 SQLFlow オンプレミス deploys via Docker or Kubernetes inside your network and runs fully air-gapped, with no cloud dependency and no outbound connection. With the on-premise edition your SQL text never leaves your infrastructure — which is why banks, healthcare providers, and government teams use it.
Where does my SQL go with SQLFlow Cloud?
With SQLFlow クラウド, the SQL you submit is analyzed on Gudu-hosted servers and is never used to read your data. If your policy forbids SQL text leaving your network, use SQLFlow On-Premise, which runs the identical engine inside your own infrastructure.
Editions, pricing & access
無料版はありますか？
Yes. SQLFlow Cloud has a free tier — paste SQL and get column-level lineage diagrams in your browser, including indirect lineage, ER diagrams, call graphs, and the AI lineage query. Premium adds larger inputs, REST API access, and team features.
SQLFlowの料金はいくらですか？
SQLFlow Cloud starts free; premium accounts are $49.99/month. SQLFlow On-Premise is $500/month or $4,800 one-time per selected database type, installable on two servers. Full details are on the 価格ページ.
Does SQLFlow have a REST API?
Yes. The SQLFlow REST API exposes the full analysis surface as JSON over HTTP — submit SQL and receive the column-level lineage graph — so you can automate lineage in CI pipelines, catalogs, and internal tools. API access is included with premium and on-premise plans.
Can I embed SQLFlow in my own application?
Yes. An embeddable JavaScript widget with a 30+ method API drops the interactive lineage diagram into any web app, and a Java library exposes the same engine for backend JVM integration. The API, widget, and library all return consistent results because they share one parser.
Getting data in and out
How do I get my SQL into SQLFlow?
Three ways: paste SQL directly, upload SQL files or a dbt manifest, or connect a source — pull metadata from a live database over JDBC, or feed in Snowflake query history or Redshift query logs. In every case SQLFlow analyzes SQL code and schema metadata only.
What is SQLFlow Ingester (Grabit)?
SQLFlow Ingester (formerly Grabit) is a command-line tool that collects SQL — the DDL of tables, views, procedures, functions, and triggers — from databases over JDBC, from GitHub or Bitbucket, or from the file system, and feeds it to SQLFlow. It extracts metadata only and schedules cleanly as a cron job for automated, repeatable extraction.
利用可能なエクスポート形式は何ですか？
Lineage exports as JSON (structured, machine-readable), CSV (for spreadsheets and catalogs), and PNG (for documents and reviews). Enterprise deployments add export adapters for DataHub, Microsoft Purview, and OpenMetadata.
Can SQLFlow feed my data catalog?
Yes. SQLFlow slots in as the lineage engine behind a catalog you already run: analyze your SQL estate, then push the results into DataHub, Microsoft Purview, or OpenMetadata through the included export adapters, or into anything custom via JSON/CSV and the REST API.
Can I ask questions about the lineage in plain English?
Yes. Since version 8.2.3, SQLFlow includes an AI lineage query: ask questions like 「どのレポートが顧客のメールに依存しているのですか？」 against the analyzed graph. Answers are grounded — every table and column the AI references is validated against the lineage graph before it reaches you.
SQLの系統図を今すぐ確認しましょう
無料のビジュアライザーにクエリを貼り付けるか、所有地全体のスキャンについてご相談ください。
Account & sign-in
Where do I find my UserId and secret key?
Open https://sqlflow.gudusoft.com and click the avatar icon at the top-right corner of the page. You will see this:
Click the Account menu item, then use the 生成 button to create a new secret key.
With your UserId and secret key, follow the REST API instructions at github.com/sqlparser/sqlflow_public/tree/master/api.
Why am I unable to log in?
Two things commonly block sign-in:
1. Your account is not activated. When you sign up, you receive an email asking you to activate your account. If you try to log in before clicking that link, the login form shows:
code:unauthorized, description:ログイン前にメールアドレスを確認してください。
Click the link in your activation email, then return to https://sqlflow.gudusoft.com 再度ログインします。
2. Your browser is blocking third-party cookies. If so, you will see one of these errors:
不明または無効なログイン チケット
確認ページを構成できません
Disable “Block third-party cookies” in your browser to fix it:
Chrome
Firefox
Microsoft Edge
Still have a question?
Try SQLFlow free on your own SQL, or reach out and we’ll help you scope it.