Showing 13 of total 13 results (show query)
r-dbi
bigrquery:An Interface to Google's 'BigQuery' 'API'
Easily talk to Google's 'BigQuery' database from R.
Maintained by Hadley Wickham. Last updated 20 days ago.
36.6 match 520 stars 12.55 score 1.8k scripts 4 dependents
miraisolutions
sparkbq:Google 'BigQuery' Support for 'sparklyr'
A 'sparklyr' extension package providing an integration with Google 'BigQuery'. It supports direct import/export where records are directly streamed from/to 'BigQuery'. In addition, data may be imported/exported via intermediate data extracts on Google 'Cloud Storage'.
Maintained by Martin Studer. Last updated 3 years ago.
28.4 match 19 stars 4.58 score 4 scripts
mlr-org
mlr3db:Data Base Backend for 'mlr3'
Extends the 'mlr3' package with a backend to transparently work with databases such as 'SQLite', 'DuckDB', 'MySQL', 'MariaDB', or 'PostgreSQL'. The package provides two additional backends: 'DataBackendDplyr' relies on the abstraction of package 'dbplyr' to interact with most DBMS. 'DataBackendDuckDB' operates on 'DuckDB' data bases and also on Apache Parquet files.
Maintained by Michel Lang. Last updated 1 years ago.
bigquerydata-backenddatabaseduckdbmachine-learningmariadbmlr3mysqlodbcpostgresqlsparksqlite
10.0 match 21 stars 4.77 score 17 scripts
apache
adbcbigquery:'Arrow' Database Connectivity ('ADBC') 'BigQuery' Driver
Provides a developer-facing interface to the 'Arrow' Database Connectivity ('ADBC') 'BigQuery' driver for the purposes of building high-level database interfaces for users. 'ADBC' <https://arrow.apache.org/adbc/> is an API standard for database access libraries that uses 'Arrow' for result sets and query parameters.
Maintained by Dewey Dunnington. Last updated 2 days ago.
5.4 match 417 stars 7.83 score 1 scripts
tidyverse
dbplyr:A 'dplyr' Back End for Databases
A 'dplyr' back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.
Maintained by Hadley Wickham. Last updated 3 months ago.
2.0 match 481 stars 19.72 score 5.2k scripts 736 dependents
meztez
bigrquerystorage:An Interface to Google's 'BigQuery Storage' API
Easily talk to Google's 'BigQuery Storage' API from R (<https://cloud.google.com/bigquery/docs/reference/storage/rpc>).
Maintained by Bruno Tremblay. Last updated 2 months ago.
5.6 match 20 stars 5.52 score 8 scripts
thewileylab
ReviewR:A Light-Weight, Portable Tool for Reviewing Individual Patient Records
A portable Shiny tool to explore patient-level electronic health record data and perform chart review in a single integrated framework. This tool supports browsing clinical data in many different formats including multiple versions of the 'OMOP' common data model as well as the 'MIMIC-III' data model. In addition, chart review information is captured and stored securely via the Shiny interface in a 'REDCap' (Research Electronic Data Capture) project using the 'REDCap' API. See the 'ReviewR' website for additional information, documentation, and examples.
Maintained by David Mayer. Last updated 2 years ago.
4.8 match 24 stars 6.33 score 6 scripts
ohdsi
SqlRender:Rendering Parameterized SQL and Translation to Dialects
A rendering tool for parameterized SQL that also translates into different SQL dialects. These dialects include 'Microsoft SQL Server', 'Oracle', 'PostgreSql', 'Amazon RedShift', 'Apache Impala', 'IBM Netezza', 'Google BigQuery', 'Microsoft PDW', 'Snowflake', 'Azure Synapse Analytics Dedicated', 'Apache Spark', 'SQLite', and 'InterSystems IRIS'.
Maintained by Martijn Schuemie. Last updated 3 days ago.
2.1 match 82 stars 12.52 score 488 scripts 13 dependentsohdsi
DatabaseConnector:Connecting to Various Database Platforms
An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', 'SQLite', and 'InterSystems IRIS'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.
Maintained by Martijn Schuemie. Last updated 2 months ago.
1.6 match 56 stars 12.63 score 772 scripts 11 dependents
8-bit-sheep
googleAnalyticsR:Google Analytics API into R
Interact with the Google Analytics APIs <https://developers.google.com/analytics/>, including the Core Reporting API (v3 and v4), Management API, User Activity API GA4's Data API and Admin API and Multi-Channel Funnel API.
Maintained by Erik Grönroos. Last updated 6 months ago.
analyticsapigooglegoogleanalyticsrgoogleauthr
1.6 match 262 stars 10.11 score 680 scripts 1 dependents
pedrocava
basedosdados:'Base Dos Dados' R Client
An R interface to the 'Base dos Dados' API <https:basedosdados.github.io/mais/py_reference_api/>). Authenticate your project, query our tables, save data to disk and memory, all from R.
Maintained by Pedro Cavalcante. Last updated 2 years ago.
1.8 match 2.70 score 101 scripts
bioc
AnVILBilling:Provide functions to retrieve and report on usage expenses in NHGRI AnVIL (anvilproject.org).
AnVILBilling helps monitor AnVIL-related costs in R, using queries to a BigQuery table to which costs are exported daily. Functions are defined to help categorize tasks and associated expenditures, and to visualize and explore expense profiles over time. This package will be expanded to help users estimate costs for specific task sets.
Maintained by Vince Carey. Last updated 5 months ago.
0.5 match 4.30 score 5 scripts
eddelbuettel
RcppFarmHash:Interface to the Google 'FarmHash' Family of Hash Functions
The Google 'FarmHash' family of hash functions is used by the Google 'BigQuery' data warehouse via the 'FARM_FINGERPRINT' function. This package permits to calculate these hash digest fingerprints directly from R, and uses the included 'FarmHash' files written by G. Pike and copyrighted by Google, Inc.
Maintained by Dirk Eddelbuettel. Last updated 6 months ago.
0.5 match 2 stars 3.48 score 2 scripts