{
  "_id": "6ad4ac0d7774b2311ffeae0d",
  "Package": "dplyneage",
  "Type": "Package",
  "Title": "Column Lineage Visualization for 'dplyr' Pipelines",
  "Version": "0.3.1.9000",
  "Authors@R": "c(\nperson(\n\"Travis\", \"Gerke\",\nemail = \"travisgerke@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\")\n),\nperson(\nfamily = \"Meta Platforms, Inc. and affiliates\",\nrole = \"cph\",\ncomment = \"React and scheduler libraries bundled in inst/htmlwidgets/lib/reactflow\"\n),\nperson(\nfamily = \"xyflow GmbH\",\nrole = \"cph\",\ncomment = \"React Flow library bundled in inst/htmlwidgets/lib/reactflow\"\n)\n)",
  "Description": "Extracts column-level lineage from 'dplyr' and 'dbplyr'\npipelines and from SQL queries, and renders it as an\ninteractive 'React Flow' diagram. The same lineage is available\nas plain data for impact analysis, for comparing pipeline\nversions (including a continuous-integration check that fails\non breaking provenance changes), and for export to JSON,\n'GraphML', 'Mermaid', and 'OpenLineage' interchange formats.",
  "License": "MIT + file LICENSE",
  "URL": "https://tgerke.github.io/dplyneage/,\nhttps://github.com/tgerke/dplyneage",
  "BugReports": "https://github.com/tgerke/dplyneage/issues",
  "Encoding": "UTF-8",
  "VignetteBuilder": "knitr",
  "Roxygen": "list(markdown = TRUE)",
  "Config/testthat/edition": "3",
  "Config/roxygen2/version": "8.1.0",
  "Config/Needs/website": "ducklake=github::tgerke/ducklake-r,\npharmaversesdtm, targets",
  "Config/pak/sysreqs": "cmake make libuv1-dev",
  "Repository": "https://tgerke.r-universe.dev",
  "Date/Publication": "2026-09-18 16:44:29 UTC",
  "RemoteUrl": "https://github.com/tgerke/dplyneage",
  "RemoteRef": "HEAD",
  "RemoteSha": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-18 11:19:15 UTC",
    "User": "root"
  },
  "Author": "Travis Gerke [aut, cre, cph],\nMeta Platforms, Inc. and affiliates [cph] (React and scheduler\nlibraries bundled in inst/htmlwidgets/lib/reactflow),\nxyflow GmbH [cph] (React Flow library bundled in\ninst/htmlwidgets/lib/reactflow)",
  "Maintainer": "Travis Gerke <travisgerke@gmail.com>",
  "_user": "tgerke",
  "_type": "src",
  "_file": "dplyneage_0.3.1.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/660d1114d15f2e582c41228e97191ba8178b4118b2ac3fce9e9847543e345a16",
  "_filesize": 810689,
  "_sha256": "660d1114d15f2e582c41228e97191ba8178b4118b2ac3fce9e9847543e345a16",
  "_expires": "2027-01-26T11:22:51.000Z",
  "_created": "2026-10-18T11:19:15.000Z",
  "_published": "2026-10-18T11:22:53.128Z",
  "_buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 117661607207,
      "time": 170,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12133999655"
    },
    {
      "job": 117661607345,
      "time": 160,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12134379642"
    },
    {
      "job": 117661607221,
      "time": 139,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12134359683"
    },
    {
      "job": 117661607152,
      "time": 142,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12135107181"
    },
    {
      "job": 117660826358,
      "time": 234,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12134528828"
    },
    {
      "job": 117661607176,
      "time": 118,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12134084382"
    },
    {
      "job": 117661607234,
      "time": 113,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12134454241"
    },
    {
      "job": 117661607220,
      "time": 126,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12134469234"
    },
    {
      "job": 117661607206,
      "time": 130,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12133939773"
    }
  ],
  "_upstream": "https://github.com/tgerke/dplyneage",
  "_commit": {
    "id": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
    "author": "Travis Gerke <travisgerke@gmail.com>",
    "committer": "Travis Gerke <travisgerke@gmail.com>",
    "message": "Regenerate the package help page with the logo\n\nroxygen2 adds the logo figure once man/figures/logo.png exists, and\ndocument() had not been run since the logo was added.\n",
    "time": 1789749869
  },
  "_maintainer": {
    "name": "Travis Gerke",
    "email": "travisgerke@gmail.com",
    "login": "tgerke",
    "linkedin": "in/travisgerke",
    "description": "Head of Applied Intelligence @ PCCTC | AI strategy & cloud research platforms for clinical trials | biostatistician & R developer",
    "uuid": 3831928
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "htmlwidgets",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "data.table",
      "role": "Suggests"
    },
    {
      "package": "DBI",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "dtplyr",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "duckplyr",
      "role": "Suggests"
    },
    {
      "package": "httr2",
      "role": "Suggests"
    },
    {
      "package": "igraph",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "reticulate",
      "role": "Suggests"
    },
    {
      "package": "rlang",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "RSQLite",
      "role": "Suggests"
    },
    {
      "package": "shiny",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.2.0",
      "role": "Suggests"
    },
    {
      "package": "webfakes",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    }
  ],
  "_owner": "tgerke",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-08",
      "n": 4
    },
    {
      "week": "2026-22",
      "n": 1
    },
    {
      "week": "2026-28",
      "n": 23
    },
    {
      "week": "2026-30",
      "n": 1
    },
    {
      "week": "2026-33",
      "n": 5
    },
    {
      "week": "2026-35",
      "n": 33
    },
    {
      "week": "2026-36",
      "n": 18
    },
    {
      "week": "2026-37",
      "n": 3
    },
    {
      "week": "2026-38",
      "n": 13
    }
  ],
  "_tags": [
    {
      "name": "v0.1.0",
      "date": "2026-07-08"
    },
    {
      "name": "v0.2.0",
      "date": "2026-07-20"
    },
    {
      "name": "v0.2.1",
      "date": "2026-08-11"
    },
    {
      "name": "v0.3.1",
      "date": "2026-09-08"
    }
  ],
  "_topics": [
    "data-lineage",
    "dbplyr",
    "dplyr",
    "htmlwidgets",
    "sqlglot"
  ],
  "_stars": 8,
  "_contributors": [
    {
      "user": "tgerke",
      "count": 101,
      "uuid": 3831928
    }
  ],
  "_userbio": {
    "uuid": 3831928,
    "type": "user",
    "name": "Travis Gerke",
    "followers": 144,
    "description": "Head of Applied Intelligence @ PCCTC | AI strategy & cloud research platforms for clinical trials | biostatistician & R developer"
  },
  "_downloads": {
    "count": 448,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dplyneage"
  },
  "_devurl": "https://github.com/tgerke/dplyneage",
  "_pkgdown": "https://tgerke.github.io/dplyneage/",
  "_searchresults": 3,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/dplyneage.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/tgerke/dplyneage",
  "_realowner": "tgerke",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.3.1",
      "date": "2026-09-16"
    }
  ],
  "_exports": [
    "create_column_edge",
    "create_table_node",
    "extract_lineage",
    "has_bundle",
    "has_sqlglot",
    "lineage_check",
    "lineage_diff",
    "lineage_downstream",
    "lineage_edges",
    "lineage_emit",
    "lineage_example",
    "lineage_flow",
    "lineage_flowOutput",
    "lineage_from_json",
    "lineage_graphml",
    "lineage_has_changes",
    "lineage_json",
    "lineage_mermaid",
    "lineage_openlineage",
    "lineage_tables",
    "lineage_unused",
    "lineage_upstream",
    "renderLineageFlow"
  ],
  "_help": [
    {
      "page": "create_column_edge",
      "title": "Connect two columns in a lineage diagram",
      "concept": [
        "manual lineage builders"
      ],
      "topics": [
        "create_column_edge"
      ]
    },
    {
      "page": "create_table_node",
      "title": "Create a table node for a lineage diagram",
      "concept": [
        "manual lineage builders"
      ],
      "topics": [
        "create_table_node"
      ]
    },
    {
      "page": "extract_lineage",
      "title": "Extract column lineage from a dplyr pipeline or SQL query",
      "topics": [
        "extract_lineage"
      ]
    },
    {
      "page": "has_bundle",
      "title": "Is the React Flow bundle available?",
      "topics": [
        "has_bundle"
      ]
    },
    {
      "page": "has_sqlglot",
      "title": "Is the Python sqlglot dependency available?",
      "topics": [
        "has_sqlglot"
      ]
    },
    {
      "page": "lineage_check",
      "title": "Gate a CI run on lineage changes",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_check"
      ]
    },
    {
      "page": "lineage_diff",
      "title": "Compare two lineage extractions",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_diff",
        "lineage_has_changes"
      ]
    },
    {
      "page": "lineage_edges",
      "title": "Lineage edges as a data frame",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_edges"
      ]
    },
    {
      "page": "lineage_emit",
      "title": "Send OpenLineage events to a backend over HTTP",
      "concept": [
        "lineage exporters"
      ],
      "topics": [
        "lineage_emit"
      ]
    },
    {
      "page": "lineage_example",
      "title": "A built-in example lineage diagram",
      "concept": [
        "manual lineage builders"
      ],
      "topics": [
        "lineage_example"
      ]
    },
    {
      "page": "lineage_flow",
      "title": "Render an interactive column lineage diagram",
      "topics": [
        "lineage_flow"
      ]
    },
    {
      "page": "lineage_flow-shiny",
      "title": "Shiny bindings for lineage_flow",
      "topics": [
        "lineage_flow-shiny",
        "lineage_flowOutput",
        "renderLineageFlow"
      ]
    },
    {
      "page": "lineage_graphml",
      "title": "Export lineage as GraphML",
      "concept": [
        "lineage exporters"
      ],
      "topics": [
        "lineage_graphml"
      ]
    },
    {
      "page": "lineage_json",
      "title": "Export lineage as JSON, and read it back",
      "concept": [
        "lineage exporters"
      ],
      "topics": [
        "lineage_from_json",
        "lineage_json"
      ]
    },
    {
      "page": "lineage_mermaid",
      "title": "Export lineage as a Mermaid flowchart",
      "concept": [
        "lineage exporters"
      ],
      "topics": [
        "lineage_mermaid"
      ]
    },
    {
      "page": "lineage_openlineage",
      "title": "Export lineage as OpenLineage events",
      "concept": [
        "lineage exporters"
      ],
      "topics": [
        "lineage_openlineage"
      ]
    },
    {
      "page": "lineage_tables",
      "title": "Lineage tables as a data frame",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_tables"
      ]
    },
    {
      "page": "lineage_unused",
      "title": "Report columns with no path to any target",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_unused"
      ]
    },
    {
      "page": "lineage_upstream",
      "title": "Trace a column's ancestry or descendants",
      "concept": [
        "lineage accessors"
      ],
      "topics": [
        "lineage_downstream",
        "lineage_upstream"
      ]
    }
  ],
  "_pkglogo": "https://github.com/tgerke/dplyneage/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/tgerke/dplyneage/raw/HEAD/README.md",
  "_rundeps": [
    "base64enc",
    "bslib",
    "cachem",
    "cli",
    "digest",
    "evaluate",
    "fastmap",
    "fontawesome",
    "fs",
    "highr",
    "htmltools",
    "htmlwidgets",
    "jquerylib",
    "jsonlite",
    "knitr",
    "lifecycle",
    "memoise",
    "mime",
    "R6",
    "rappdirs",
    "rlang",
    "rmarkdown",
    "sass",
    "tinytex",
    "xfun",
    "yaml"
  ],
  "_vignettes": [
    {
      "source": "building-reactflow.Rmd",
      "filename": "building-reactflow.html",
      "title": "Building the React Flow Bundle",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Prerequisites",
        "Build steps",
        "Option 1: Using R (from a source checkout)",
        "Option 2: Using the build script",
        "Option 3: Manual build",
        "What gets built",
        "Local patch to @xyflow/system",
        "Development mode",
        "Testing after build",
        "Troubleshooting",
        "Development workflow",
        "Bundle contents"
      ],
      "created": "2026-02-18 22:31:16",
      "modified": "2026-09-15 21:51:19",
      "commits": 6
    },
    {
      "source": "getting-started.Rmd",
      "filename": "getting-started.html",
      "title": "Getting Started with dplyneage",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Installation",
        "Your first lineage diagram",
        "A realistic pipeline",
        "Computed columns",
        "Where lineage gets hard",
        "Tracing through CTEs",
        "Columns with multiple sources",
        "Expanding SELECT *",
        "Raw SQL and schemas",
        "Local data frames",
        "Other lazy backends",
        "Column labels",
        "Building diagrams by hand",
        "Exporting lineage",
        "Next steps"
      ],
      "created": "2026-02-18 22:31:16",
      "modified": "2026-09-18 16:44:29",
      "commits": 20
    },
    {
      "source": "python-integration.Rmd",
      "filename": "python-integration.html",
      "title": "Python Integration",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Installation: there is no step two",
        "Using your own Python environment",
        "How it works",
        "Architecture",
        "Key components",
        "Schemas and attribution accuracy",
        "SQL dialects",
        "Performance",
        "Troubleshooting",
        "Check Python configuration",
        "sqlglot not found in a custom environment",
        "References"
      ],
      "created": "2026-02-18 22:31:16",
      "modified": "2026-09-18 16:44:29",
      "commits": 9
    }
  ],
  "_score": 6.033423755486949,
  "_indexed": true,
  "_nocasepkg": "dplyneage",
  "_universes": [
    "tgerke"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:21:35.000Z",
      "distro": "resolute",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/4fa5e6965744cd8ff800e4a9c6b3b57b3e392011f42731b54f20aa612364b365",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:21:29.000Z",
      "distro": "resolute",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/16ec260d619a4b43e5a83586c432d76a5b3ef2fba77d6edb6aeaa8c92ff4bca7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:21:13.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/50e5e2dbc4528310e6c62d06dc95b95b19edb0baddbb7e73f2730bfbf994d7e5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:21:13.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/f6f61e617502a8837706f72614378bc5a9bdaec337c20105d57e649f4e9f4505",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:21:36.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/d42ca1468d592a522354936dafad155c3a5ce9ac832742ab2cf926daa8d8f886",
      "status": "success",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:20:37.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/58a40600fc76033860df140daac7b7c2d096fa9457027d3d19b37451e6508e22",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:20:37.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/2db8a9ea7e4c2f527e62d05cb1f19010cc161bc4d208d91121fc744862e87071",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.3.1.9000",
      "date": "2026-10-18T11:20:38.000Z",
      "commit": "ef3d30d9f8a055c55065fb804256ad8b2e299da0",
      "fileid": "https://r2.ropensci.org/a3f3539e24ac905962e7370590db4e60115f24bbd8f5fc62c51230d3a23b827a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/tgerke/actions/runs/39122500538"
    }
  ]
}