-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
library(DatabaseConnector)
connectionDetails <- createConnectionDetails(dbms="bigquery",
connectionString=Sys.getenv("BIGQUERY_CONNECTION_STRING"),
user="",
password='')
con <- connect(connectionDetails)
#> Connecting using BigQuery driver
df <- querySql(con, "select * from synpuf_110k.visit_detail limit 1")
df
#> [1] VISIT_DETAIL_ID PERSON_ID
#> [3] VISIT_DETAIL_CONCEPT_ID VISIT_DETAIL_START_DATE
#> [5] VISIT_DETAIL_START_DATETIME VISIT_DETAIL_END_DATE
#> [7] VISIT_DETAIL_END_DATETIME VISIT_DEATIL_TYPE_CONCEPT_ID
#> [9] PROVIDER_ID CARE_SITE_ID
#> [11] ADMITTING_SOURCE_CONCEPT_ID DISCHARGE_TO_CONCEPT_ID
#> [13] PRECEDING_VISIT_DETAIL_ID VISIT_DETAIL_SOURCE_VALUE
#> [15] VISIT_DEATIL_SOURCE_CONCEPT_ID ADMITTING_SOURCE_VALUE
#> [17] DISCHARGE_TO_SOURCE_VALUE VISIT_DETAIL_PARENT_ID
#> [19] VISIT_OCCURRENCE_ID
#> <0 rows> (or 0-length row.names)
"VISIT_DEATIL_SOURCE_CONCEPT_ID" %in% names(df)
#> [1] TRUE
disconnect(con)@konstjar Can you fix this? DETAIL is mispelled in the visit_detail.visit_detail_type_concept_id column in both the synpuf_110k schema and synpuf_2m schemas.
Metadata
Metadata
Assignees
Labels
No labels