Open cjrace opened 5 months ago
Similar to #16 we should add a function that creates the initial set up for a config file for connecting to a SQL database.
This should come with a vignette on how to set this up and connect to a database through a R Shiny app in the DfE, similar to the generic one being work on in https://github.com/dfe-analytical-services/dfeR/pull/68.
Over time this function and vignette can then be expanded to include to include details on connecting to Pins and data stored in Databricks, which we're expecting DfE to move to over the coming years.
Similar to #16 we should add a function that creates the initial set up for a config file for connecting to a SQL database.
This should come with a vignette on how to set this up and connect to a database through a R Shiny app in the DfE, similar to the generic one being work on in https://github.com/dfe-analytical-services/dfeR/pull/68.
Over time this function and vignette can then be expanded to include to include details on connecting to Pins and data stored in Databricks, which we're expecting DfE to move to over the coming years.