{
  "_id": "6af595c4f58eaab79920b1cc",
  "Package": "sparkbq",
  "Type": "Package",
  "Title": "Google 'BigQuery' Support for 'sparklyr'",
  "Version": "0.1.1",
  "Authors@R": "c(person(family = \"Mirai Solutions GmbH\", role = \"aut\",\nemail = \"info@mirai-solutions.com\"),\nperson(\"Martin\", \"Studer\", role = \"cre\",\nemail = \"martin.studer@mirai-solutions.com\"),\nperson(\"Nicola\", \"Lambiase\", role = \"ctb\"),\nperson(\"Omer\", \"Demirel\", role = \"ctb\"))",
  "URL": "http://www.mirai-solutions.com,\nhttps://github.com/miraisolutions/sparkbq",
  "BugReports": "https://github.com/miraisolutions/sparkbq/issues",
  "Description": "A 'sparklyr' extension package providing an integration\nwith Google 'BigQuery'. It supports direct import/export where\nrecords are directly streamed from/to 'BigQuery'. In addition,\ndata may be imported/exported via intermediate data extracts on\nGoogle 'Cloud Storage'.",
  "License": "GPL-3 | file LICENSE",
  "SystemRequirements": "Spark (>= 2.2.x)",
  "Encoding": "UTF-8",
  "RoxygenNote": "6.1.1",
  "Config/pak/sysreqs": "libicu-dev libxml2-dev libssl-dev",
  "Repository": "https://miraisolutions.r-universe.dev",
  "Date/Publication": "2022-01-25 10:34:03 UTC",
  "RemoteUrl": "https://github.com/miraisolutions/sparkbq",
  "RemoteRef": "HEAD",
  "RemoteSha": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-12 10:15:20 UTC",
    "User": "root"
  },
  "Author": "Mirai Solutions GmbH [aut],\nMartin Studer [cre],\nNicola Lambiase [ctb],\nOmer Demirel [ctb]",
  "Maintainer": "Martin Studer <martin.studer@mirai-solutions.com>",
  "_user": "miraisolutions",
  "_type": "src",
  "_file": "sparkbq_0.1.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/8ef4b24439095a47baa0c1ed25632037644d0c7f94828081da7fe27aa728f0ca",
  "_filesize": 152788,
  "_sha256": "8ef4b24439095a47baa0c1ed25632037644d0c7f94828081da7fe27aa728f0ca",
  "_expires": "2027-02-20T10:32:34.000Z",
  "_created": "2026-11-12T10:15:20.000Z",
  "_published": "2026-11-12T10:32:36.141Z",
  "_upstream": "https://github.com/miraisolutions/sparkbq",
  "_status": "success",
  "_maintainer": {
    "name": "Martin Studer",
    "email": "martin.studer@mirai-solutions.com",
    "login": "martinstuder",
    "linkedin": "in/mastuder",
    "description": "",
    "uuid": 1091843
  },
  "_jobs": [
    {
      "job": 131116400830,
      "time": 138,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13934466518"
    },
    {
      "job": 131116400926,
      "time": 121,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13933753575"
    },
    {
      "job": 131116400955,
      "time": 179,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13934658617"
    },
    {
      "job": 131116400911,
      "time": 202,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13934928015"
    },
    {
      "job": 131114744345,
      "time": 191,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13933239128"
    },
    {
      "job": 131116400843,
      "time": 98,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13933279337"
    },
    {
      "job": 131116401075,
      "time": 194,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13935050457"
    },
    {
      "job": 131116400984,
      "time": 209,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13934561531"
    },
    {
      "job": 131116401050,
      "time": 222,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13933704102"
    }
  ],
  "_buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403",
  "_commit": {
    "id": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
    "author": "Peter Schmid <peter.schmid@mirai-solutions.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #18 from miraisolutions/feature/update-DESCRIPTION-emails\n\nremove emails of people that left Mirai",
    "time": 1643106843
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.3.2",
      "role": "Depends"
    },
    {
      "package": "sparklyr",
      "version": ">= 0.7.0",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    }
  ],
  "_owner": "miraisolutions",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "bigquery",
    "spark",
    "sparklyr"
  ],
  "_stars": 19,
  "_contributors": [
    {
      "user": "martinstuder",
      "count": 37,
      "uuid": 1091843
    },
    {
      "user": "lambiase",
      "count": 28,
      "uuid": 3520786
    },
    {
      "user": "spoltier",
      "count": 7,
      "uuid": 19765083
    },
    {
      "user": "demirelo",
      "count": 5,
      "uuid": 7556489
    }
  ],
  "_userbio": {
    "uuid": 3518285,
    "type": "organization",
    "name": "Mirai Solutions GmbH",
    "followers": 23,
    "description": "open-source software, utilities, guides, best practices"
  },
  "_downloads": {
    "count": 417,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sparkbq"
  },
  "_devurl": "https://github.com/miraisolutions/sparkbq",
  "_searchresults": 4,
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/sparkbq.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/miraisolutions/sparkbq",
  "_realowner": "miraisolutions",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2018-08-02"
    },
    {
      "version": "0.1.1",
      "date": "2019-12-18"
    }
  ],
  "_exports": [
    "bigquery_defaults",
    "default_bigquery_type",
    "default_billing_project_id",
    "default_dataset_location",
    "default_gcs_bucket",
    "default_service_account_key_file",
    "spark_read_bigquery",
    "spark_write_bigquery"
  ],
  "_help": [
    {
      "page": "bigquery_defaults",
      "title": "Google BigQuery Default Settings",
      "topics": [
        "bigquery_defaults"
      ]
    },
    {
      "page": "default_bigquery_type",
      "title": "Default BigQuery import/export type",
      "topics": [
        "default_bigquery_type"
      ]
    },
    {
      "page": "default_billing_project_id",
      "title": "Default Google BigQuery Billing Project ID",
      "topics": [
        "default_billing_project_id"
      ]
    },
    {
      "page": "default_dataset_location",
      "title": "Default Google BigQuery Dataset Location",
      "topics": [
        "default_dataset_location"
      ]
    },
    {
      "page": "default_gcs_bucket",
      "title": "Default Google BigQuery GCS Bucket",
      "topics": [
        "default_gcs_bucket"
      ]
    },
    {
      "page": "default_service_account_key_file",
      "title": "Default Google BigQuery Service Account Key File",
      "topics": [
        "default_service_account_key_file"
      ]
    },
    {
      "page": "spark_read_bigquery",
      "title": "Reading data from Google BigQuery",
      "concept": [
        "Spark serialization routines"
      ],
      "topics": [
        "spark_read_bigquery"
      ]
    },
    {
      "page": "spark_write_bigquery",
      "title": "Writing data to Google BigQuery",
      "concept": [
        "Spark serialization routines"
      ],
      "topics": [
        "spark_write_bigquery"
      ]
    }
  ],
  "_pkglogo": "https://github.com/miraisolutions/sparkbq/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/miraisolutions/sparkbq/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "blob",
    "cli",
    "codetools",
    "config",
    "cpp11",
    "curl",
    "DBI",
    "dbplyr",
    "dplyr",
    "generics",
    "globals",
    "glue",
    "httr",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "mime",
    "openssl",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "rlang",
    "rstudioapi",
    "sparklyr",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "uuid",
    "vctrs",
    "withr",
    "xml2",
    "yaml"
  ],
  "_score": 4.45484486000851,
  "_indexed": true,
  "_nocasepkg": "sparkbq",
  "_universes": [
    "miraisolutions",
    "martinstuder"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-11-12T10:17:36.000Z",
      "distro": "resolute",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/c339959ebbc4b990caf01131f8b6d13299265e05cb8a8a24f7adaf747729742a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-11-12T10:17:16.000Z",
      "distro": "resolute",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/e8bb1f2f4aefa293c6f796da86b30c55992a4ba0231e6f5ffb2167d27e8d9aaf",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.1",
      "date": "2026-11-12T10:31:30.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/a3567bac23f5be4e091b52e85d45a9622fcb48a3444612a078dd7cb20221bcda",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.1.1",
      "date": "2026-11-12T10:30:52.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/db57a20c27fdaffd2a34ad248667a0a5c7303dbcd76dcb8ab47d59942600e6ff",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.1",
      "date": "2026-11-12T10:17:15.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/801e7802babcc6a82d8e3b4d5b2ab73780c49700e61c538d1f510193963466d0",
      "status": "success",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.1",
      "date": "2026-11-12T10:17:34.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/5058d5fdbaaf3994a85d2769ee2a92314d453fac70b49e6420eee49d169e8e4b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.1",
      "date": "2026-11-12T10:17:48.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/cc05f76ffee06518669cb659f8238aea429bb33235820b6fc3fb958c441f8297",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.1.1",
      "date": "2026-11-12T10:18:12.000Z",
      "commit": "b3e465589c2fb6d82f115c0f5cf487717f10e7f0",
      "fileid": "https://r2.ropensci.org/e0d6271c682b6f339d34dec3aa036ae1d15a6baa3dde1c18a1435ade6c450fdd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/miraisolutions/actions/runs/43198126403"
    }
  ]
}