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