Generate lineage
Enable query logging and configure your ClickHouse instance so the ClickHouse Miner workflow can extract query history and generate lineage.
Enable query logging and configure your ClickHouse instance so the ClickHouse Miner workflow can extract query history and generate lineage.
Enable pg_stat_statements and configure your PostgreSQL instance so the PostgreSQL Miner workflow can extract query history and generate lineage.
Learn how to use the Generic Miner app to turn SQL query history stored in Amazon S3 into lineage for an existing connection.
Once you have [crawled assets from ClickHouse](/apps/connectors/database/clickhouse/how-tos/crawl-clickhouse), you can mine its query history to construct lineage.
Once you have [crawled assets from PostgreSQL](/apps/connectors/database/postgresql/how-tos/crawl-postgresql), you can mine its query history to construct lineage.