Creates Snowflake Dataset — dai.create_dataset_from

Import a dataset using Snowflake Query.

dai.create_dataset_from_snowflake(
  region,
  database,
  warehouse,
  schema,
  role,
  optional_file_formatting,
  destination,
  query,
  sf_user,
  password,
  account,
  progress = getOption("dai.progress", TRUE)
)

Arguments

region	(Optional) Region where Snowflake warehouse exists
database	Name of Snowflake database to query
warehouse	Name of Snowflake warehouse to query
schema	Schema to use during query
role	(Optional) Snowflake role to be used for query
optional_file_formatting	(Optional) Additional arguments for formatting the output SQL query to csv file. See snowflake documentation for "Create File Format"
destination	Destination within local file system for resulting dataset
query	SQL query to pass to Snowflake
sf_user	Snowflake user
password	Snowflake user password
account	Snowflake user account
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{
ccard <- dai.create_dataset_from_snowflake("", "UTIL_DB", "H2OAI_ETL",
                                           "CC_TRAIN_SCHEMA_NEW", "", "",
                                           "test_snowflake.csv", "SELECT * FROM CC_TRAIN_NEW")
# }