How to use SqlQueriesSource about datahub

[wu-johnson]

follow this doc, https://datahubproject.io/docs/next/generated/ingestion/sources/sql-queries/#cli-based-ingestion. datahub ingest successed, but no table lineage or column lineage in the web ui.
eg:

and sql file like this
{"query": "insert into datahub.t_customer_country_city_rank ( ca_country ,ca_city ,cnt ,rid ) select ca_country ,ca_city ,count(1) as cnt ,1 as rid from datahub.t_customer_address group by ca_country,ca_city", "user": "test", "upstream_ tables": ["datahub.t_customer_address"]}

config file like this
datahub_api: # Only necessary if using a non-DataHub sink, e.g. the file sink
server: http://localhost:8080
timeout_sec: 60
source:
type: sql-queries
config:
platform: "mysql"
default_db: "datahub"
query_file: "/tmp/sql-ingest-sample.json"
reporting:

• type: datahub
  config:
  report_recipe: false

after success run with cmd: datahub ingest -c sql-ingest-recipe.yaml. in the webui do not have the table lineage or column lineage

[sunrutcon]

So you need running web app to use this feature?
Is it possible to generate sql column level lineage with just importing SqlQueriesSource from the module and do it offilne?

[hsheth2]

The docs are more up to date if you select "next" in the version selector

This source needs access to datahub's backend in order to fetch schema information for tables - otherwise the accuracy will be lower.

There was a bug with our processing of certain insert into statements, so that query should generate lineage with the latest rc (0.12.1.6rc5) release of acryl-datahub

I'm going to close this issue for now, but feel free to ask any additional questions.