Class

net.snowflake.spark.snowflake.Parameters

MergedParameters

Related Doc: package Parameters

Permalink

case class MergedParameters(parameters: Map[String, String]) extends Product with Serializable

Adds validators and accessors to string map

Linear Supertypes
Serializable, Serializable, Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. MergedParameters
  2. Serializable
  3. Serializable
  4. Product
  5. Equals
  6. AnyRef
  7. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new MergedParameters(parameters: Map[String, String])

    Permalink

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  4. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  5. def autoPushdown: Boolean

    Permalink

    Snowflake automatically enable/disable pushdown function

  6. def awsAccessKey: Option[String]

    Permalink
  7. def awsSecretKey: Option[String]

    Permalink
  8. def azureSAS: Option[String]

    Permalink
  9. def bindVariableEnabled: Boolean

    Permalink
  10. def checkBucketConfiguration: Boolean

    Permalink

    Returns true if bucket lifecycle configuration should be checked

  11. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  12. def columnMap: Option[Map[String, String]]

    Permalink

    Retrieve Column mapping data.

    Retrieve Column mapping data. None if empty

  13. def continueOnError: Boolean

    Permalink

    Set on_error parameter to continue in COPY command todo: create data validation function in spark side instead of using COPY COMMAND

  14. def createPerQueryTempDir(): String

    Permalink

    Creates a per-query subdirectory in the rootTempDir, with a random UUID.

  15. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  16. def extraCopyOptions: String

    Permalink

    Extra options to append to the Snowflake COPY command (e.g.

    Extra options to append to the Snowflake COPY command (e.g. "MAXERROR 100").

  17. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  18. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  19. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  20. def isSslON: Boolean

    Permalink
  21. def isTimezoneSnowflake: Boolean

    Permalink
  22. def isTimezoneSnowflakeDefault: Boolean

    Permalink
  23. def isTimezoneSpark: Boolean

    Permalink
  24. def keepOriginalColumnNameCase: Boolean

    Permalink
  25. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  26. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  27. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  28. lazy val parallelism: Option[Int]

    Permalink

    Number of threads used for PUT/GET.

  29. val parameters: Map[String, String]

    Permalink
  30. def postActions: Array[String]

    Permalink

    List of semi-colon separated SQL statements to run after successful write operations.

    List of semi-colon separated SQL statements to run after successful write operations. This can be useful for running GRANT operations to make your new tables readable to other users and groups.

    If the action string contains %s, the table name will be substituted in, in case a staging table is being used.

    Defaults to empty.

  31. def preActions: Array[String]

    Permalink

    List of semi-colon separated SQL statements to run before write operations.

    List of semi-colon separated SQL statements to run before write operations. This can be useful for running DELETE operations to clean up data

    If the action string contains %s, the table name will be substituted in, in case a staging table is being used.

    Defaults to empty.

  32. def privateKey: Option[PrivateKey]

    Permalink

    Generate private key form pem key value

    Generate private key form pem key value

    returns

    private key object

  33. def purge(): Boolean

    Permalink

    Whether or not to have PURGE in the COPY statement generated by the Spark connector

  34. def query: Option[String]

    Permalink

    The Snowflake query to be used as the target when loading data.

  35. lazy val rootTempDir: String

    Permalink

    A root directory to be used for intermediate data exchange, expected to be on cloud storage (S3 or Azure storage), or somewhere that can be written to and read from by Snowflake.

    A root directory to be used for intermediate data exchange, expected to be on cloud storage (S3 or Azure storage), or somewhere that can be written to and read from by Snowflake. Make sure that credentials are available for this cloud provider.

  36. lazy val rootTempDirStorageType: FSType

    Permalink
  37. def s3maxfilesize: String

    Permalink

    Max file size used to move data out from Snowflake

  38. def sfAccount: Option[String]

    Permalink

    Snowflake account - optional

  39. def sfCompress: Boolean

    Permalink

    Snowflake use compression on/off - "on" by default

  40. def sfDatabase: String

    Permalink

    Snowflake database name

  41. def sfExtraOptions: Map[String, AnyRef]

    Permalink

    Returns a map of options that are not known to the connector, and are passed verbosely to the JDBC driver

  42. def sfPassword: String

    Permalink

    Snowflake password

  43. def sfRole: Option[String]

    Permalink

    Snowflake role - optional

  44. def sfSSL: String

    Permalink

    Snowflake SSL on/off - "on" by default

  45. def sfSchema: String

    Permalink

    Snowflake schema

  46. def sfTimezone: Option[String]

    Permalink

    Snowflake timezone- optional

  47. def sfURL: String

    Permalink

    URL pointing to the snowflake database, simply host:port

  48. def sfUser: String

    Permalink

    Snowflake user

  49. def sfWarehouse: Option[String]

    Permalink

    Snowflake warehouse

  50. def storagePath: Option[String]

    Permalink
  51. def streamingStage: Option[String]

    Permalink
  52. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  53. def table: Option[TableName]

    Permalink

    The Snowflake table to be used as the target when loading or writing data.

  54. def temporaryAWSCredentials: Option[AWSCredentials]

    Permalink

    Temporary AWS credentials which are passed to Snowflake.

    Temporary AWS credentials which are passed to Snowflake. These only need to be supplied by the user when Hadoop is configured to authenticate to S3 via IAM roles assigned to EC2 instances.

  55. def temporaryAzureStorageCredentials: Option[StorageCredentialsSharedAccessSignature]

    Permalink

    SAS Token to be passed to Snowflake to access data in Azure storage.

    SAS Token to be passed to Snowflake to access data in Azure storage. We currently don't support full storage account key so this has to be provided if customer would like to load data through their storage account directly.

  56. def toString(): String

    Permalink
    Definition Classes
    MergedParameters → AnyRef → Any
  57. def truncateColumns(): Boolean

    Permalink

    Whether or not to have TRUNCATE_COLUMNS in the COPY statement generated by the Spark connector.

  58. def truncateTable: Boolean

    Permalink

    Truncate table when overwriting.

    Truncate table when overwriting. Keep the table schema

  59. def useStagingTable: Boolean

    Permalink

    When true, data is always loaded into a new temporary table when performing an overwrite.

    When true, data is always loaded into a new temporary table when performing an overwrite. This is to ensure that the whole load process succeeds before dropping any data from Snowflake, which can be useful if, in the event of failures, stale data is better than no data for your systems.

    Defaults to true.

  60. lazy val usingExternalStage: Boolean

    Permalink
  61. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  62. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  63. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped