{
  "_id": "6a17abe9acfb0bcc41d9a4c0",
  "Package": "qiverse.snowflake",
  "Title": "Snowflake Connectivity",
  "Version": "0.0.2.2",
  "Authors@R": "person(given = \"Healthcare Quality Intelligence Unit (Western Australia Health)\",\nfamily = \"\",\nrole = c(\"aut\", \"cre\"),\nemail = \"safetyandquality@health.wa.gov.au\")",
  "Description": "Defines functions needed to connect to Snowflake within an\nactive R session.",
  "License": "GPL (>= 3) + file LICENSE",
  "Config/testthat/edition": "3",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "URL": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/qiverse.snowflake",
  "BugReports": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/issues",
  "Remotes": [
    "AUS-DOH-Safety-and-Quality/qiverse/qiverse.azure",
    "AUS-DOH-Safety-and-Quality/qiverse/qiverse.powerbi"
  ],
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "cmake make unixodbc-dev libssl-dev",
  "Repository": "https://aus-doh-safety-and-quality.r-universe.dev",
  "Date/Publication": "2026-05-28 00:42:52 UTC",
  "RemoteUrl": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse",
  "RemoteRef": "main",
  "RemoteSha": "b41f1237dad4226587a312b232828bcfbeeacb52",
  "RemoteSubdir": "qiverse.snowflake",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-28 02:41:04 UTC",
    "User": "root"
  },
  "Author": "Healthcare Quality Intelligence Unit (Western Australia Health) [aut,\ncre]",
  "Maintainer": "Healthcare Quality Intelligence Unit (Western Australia Health) <safetyandquality@health.wa.gov.au>",
  "MD5sum": "56c308fa801db27c4ce9536842324379",
  "_user": "aus-doh-safety-and-quality",
  "_type": "src",
  "_file": "qiverse.snowflake_0.0.2.2.tar.gz",
  "_fileid": "3493d4562651097f3d640bb6bdba102df09a69dcee28333d8ca6cbfd7c1e1f49",
  "_filesize": 102617,
  "_sha256": "3493d4562651097f3d640bb6bdba102df09a69dcee28333d8ca6cbfd7c1e1f49",
  "_created": "2026-05-28T02:41:04.000Z",
  "_published": "2026-05-28T02:43:53.590Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78213879331,
      "time": 130,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7256593922"
    },
    {
      "job": 78213879329,
      "time": 138,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7256594998"
    },
    {
      "job": 78213879322,
      "time": 81,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7256585591"
    },
    {
      "job": 78213879317,
      "time": 89,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7256587112"
    },
    {
      "job": 78213586364,
      "time": 190,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7256571742"
    },
    {
      "job": 78213879312,
      "time": 129,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7256593841"
    },
    {
      "job": 78213879363,
      "time": 75,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7256584876"
    },
    {
      "job": 78213879344,
      "time": 96,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7256588307"
    },
    {
      "job": 78213879332,
      "time": 73,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7256584552"
    }
  ],
  "_buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse",
  "_commit": {
    "id": "b41f1237dad4226587a312b232828bcfbeeacb52",
    "author": "Peter Li <43059710+pli9@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #51 from AUS-DOH-Safety-and-Quality/add-refresh-dataflow\n\nAdd refresh dataflow",
    "time": 1779928972
  },
  "_maintainer": {
    "name": "Healthcare Quality Intelligence Unit (Western Australia Health)",
    "email": "safetyandquality@health.wa.gov.au",
    "login": "dohwahqiu",
    "description": "",
    "uuid": 95904605
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Imports"
    },
    {
      "package": "data.table",
      "role": "Imports"
    },
    {
      "package": "qiverse.azure",
      "role": "Suggests"
    },
    {
      "package": "qiverse.powerbi",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "glue",
      "role": "Suggests"
    }
  ],
  "_owner": "aus-doh-safety-and-quality",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-24",
      "n": 1
    },
    {
      "week": "2025-29",
      "n": 2
    },
    {
      "week": "2025-32",
      "n": 6
    },
    {
      "week": "2025-35",
      "n": 1
    },
    {
      "week": "2025-40",
      "n": 1
    },
    {
      "week": "2025-44",
      "n": 4
    },
    {
      "week": "2025-45",
      "n": 3
    },
    {
      "week": "2025-47",
      "n": 3
    },
    {
      "week": "2025-50",
      "n": 1
    },
    {
      "week": "2026-02",
      "n": 1
    },
    {
      "week": "2026-03",
      "n": 4
    },
    {
      "week": "2026-04",
      "n": 4
    },
    {
      "week": "2026-14",
      "n": 1
    },
    {
      "week": "2026-20",
      "n": 3
    },
    {
      "week": "2026-22",
      "n": 3
    }
  ],
  "_tags": [],
  "_stars": 5,
  "_contributors": [
    {
      "user": "andrjohns",
      "count": 99,
      "uuid": 27717896
    },
    {
      "user": "pli9",
      "count": 19,
      "uuid": 43059710
    },
    {
      "user": "nmhs-mikikochono-schaa",
      "count": 12,
      "uuid": 172719753
    },
    {
      "user": "kyrantgs",
      "count": 4,
      "uuid": 43620527
    },
    {
      "user": "fraser-clarke",
      "count": 2,
      "uuid": 99302738
    }
  ],
  "_userbio": {
    "uuid": 65321745,
    "type": "organization",
    "name": "WA Health - Safety & Quality",
    "description": "Western Australia, Department of Health"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/qiverse.snowflake"
  },
  "_devurl": "https://github.com/aus-doh-safety-and-quality/qiverse",
  "_searchresults": 2,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/qiverse.snowflake.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "create_view_from_definition",
    "ingest_dataflow_table",
    "ingest_to_snowflake",
    "snowflake_con"
  ],
  "_help": [
    {
      "page": "create_view_from_definition",
      "title": "Create a View in Snowflake based on an existing table or view",
      "topics": [
        "create_view_from_definition"
      ]
    },
    {
      "page": "ingest_dataflow_table",
      "title": "Ingest a PowerBI Dataflow table into Snowflake",
      "topics": [
        "ingest_dataflow_table"
      ]
    },
    {
      "page": "ingest_to_snowflake",
      "title": "Ingest table into Snowflake",
      "topics": [
        "ingest_to_snowflake"
      ]
    },
    {
      "page": "snowflake_con",
      "title": "Create Connection to Snowflake",
      "topics": [
        "snowflake_con"
      ]
    }
  ],
  "_readme": "https://github.com/AUS-DOH-Safety-and-Quality/qiverse/raw/main/qiverse.snowflake/README.md",
  "_rundeps": [
    "arrow",
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "data.table",
    "DBI",
    "glue",
    "hms",
    "lifecycle",
    "magrittr",
    "odbc",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "tidyselect",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "snowflake.Rmd",
      "filename": "snowflake.html",
      "title": "Snowflake",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Setup for Snowflake connection",
        "Connecting to Snowflake",
        "R example",
        "Ingesting an R table held in-memory into Snowflake"
      ],
      "created": "2025-03-25 02:00:44",
      "modified": "2025-03-25 02:00:44",
      "commits": 1
    }
  ],
  "_score": 5.176091259055681,
  "_indexed": true,
  "_nocasepkg": "qiverse.snowflake",
  "_universes": [
    "aus-doh-safety-and-quality",
    "dohwahqiu"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:43:13.000Z",
      "distro": "noble",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "dccb53063cee89c943caa19cfc0b78a51e4c489104bda8193c542e95250f9052",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:43:21.000Z",
      "distro": "noble",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "4b1d87fb4005ba0de0d997700227ef140f6295d7a6cdcda2ea000d2df86e4dbf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:42:27.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "7f41eb053326f687351443fcf8245d263431d7e4e29dcb0ae18b82991e4db3bc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:42:35.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "6adf9bb51bd630eb2de9aa18760f93a6ac9ff15fef74d25d021bf4e89dc1a17a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:43:25.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "5a3104cb0dbc7807943da7be9ebcc81d9a13048b502a850f13d375f7a3a5de0d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:42:15.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "793ac25face12c45fe037e5da4a207565c159052ec191d6e1db44b4f955c75f8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:42:36.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "01989192a47027fd269d935d68fce941031069852a32263ba2dedb1b78f2f325",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.0.2.2",
      "date": "2026-05-28T02:42:10.000Z",
      "commit": "b41f1237dad4226587a312b232828bcfbeeacb52",
      "fileid": "71126720382d9107fdc6e3655ade13827353cd14156c5ce1ad2398b5429fded4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/aus-doh-safety-and-quality/actions/runs/26551220782"
    }
  ]
}