Creates JDBC Dataset — dai.create_dataset_from

Creates a dataset from a JDBC query.

dai.create_dataset_from_jdbc(
  connection,
  destination,
  query,
  user,
  password,
  id_column = NULL,
  progress = getOption("dai.progress", TRUE)
)

Arguments

connection	Name of the JDBC connection.
destination	Name of the Driverless dataset.
query	An SQL query.
user	The database username.
password	The password of the database `user`.
id_column	The name of the ID column in the dataset (optional).
progress	Whether to display a progress bar.

Value

DAIFrame representing the dataset.

Details

Find more details about how to enable data connectors in the documentation.

Examples

# \donttest{
data <- dai.create_dataset_from_jdbc('postgres', 'creditcard', 'select * from creditcard', 
                                     'psql_user', 'secret_password')
# }