When using dataframe's DataSchema, how can one use...

# datascience

[Richard Glen]

When using dataframe's DataSchema, how can one use ImportDataSchema and pass Jdbc param values from environment variable?

[Richard Glen]

I dont think this is supported yet. Will have to generate from template during compile I guess?

[Nikita Ermolenko]

Yeah, I don’t think it is supported yet. Generating from a template or creating a schema using Gradle should work. Folks from the team will correct me if I am wrong.

[Nikita Klimenko [JB]]

@Nikita Ermolenko is right. Here's our Gradle plugin reference https://kotlin.github.io/dataframe/gradlereference.html#schema-definitions-from-sql-databases
and some Gradle documentation for reading env variable
https://docs.gradle.org/current/userguide/build_environment.html#sec:gradle_environment_variables

Gradle provides a number of environment variables, which are listed below. You can access environment variables as properties in the build script using the System.getenv() method

Having this supported in ImportDataSchema is a great idea btw

[Nikita Klimenko [JB]]

https://github.com/Kotlin/dataframe/issues/642 ticket to follow

[Richard Glen]

Got this! Your fast reply is greatly appreciated!Thanks Nikitas 😉