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')
# }