DatabaseConnector Connection Strings to some databases that need for than the driver

[jposada (Jose Posada)]

Hi @schuemie and all DatabaseConnector developers,

Seeing this post

HADES development announcements

SqlRender 1.9.0 has been released. Most important change is further support for Spark.

I saw some great info there for setting up a connection to the different databases. I am aware that several databases (BigQuery included) may need a connection string that is not typical. I created a small R package to create that for Bigquery but wonder if we need to add that to the DatabaseConnector repo or keep those auxiliary functions separated.

GitHub - jdposada/BQJdbcConnectionStringR: Helper function to build a connection...

Thanks,

Jose

[jpegilbert (Jamie Gilbert)]

I agree that keeping required connection parameters inside the DatabaseConnector package should absolutely be a requirement. Looking at your package, it builds the BigQuery specific parameters into a connection string, do you think this can be completed using the extra settings functionality?

I have added an issue on the DatabaseConnector github here that is probably a better place to discuss the changes/additions that need to be made.

[jposada (Jose Posada)]

I think the answer to this

@jpegilbert

do you think this can be completed using the extra settings functionality?

is yes, but I may need some handholding for the integration. happy to learn

[jpegilbert (Jamie Gilbert)]

@jposada happy to help if I can, the only problem on my end is that I don’t have a bigQuery database to connect to!