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 checkTableExistenceInCurrentSchemaOnly: Boolean

    Permalink
  12. def clone(): AnyRef

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

    Permalink

    Retrieve Column mapping data.

    Retrieve Column mapping data. None if empty

  14. def columnMapping: String

    Permalink
  15. def columnMismatchBehavior: String

    Permalink
  16. 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

  17. def createPerQueryTempDir(): String

    Permalink

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

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

    Permalink
    Definition Classes
    AnyRef
  19. def expectedPartitionCount: Int

    Permalink
  20. def expectedPartitionSize: Long

    Permalink
  21. 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").

  22. def finalize(): Unit

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

    Permalink
    Definition Classes
    AnyRef → Any
  24. def getQueryResultFormat: Option[String]

    Permalink

    Snowflake query result format

  25. def getTimeOutputFormat: Option[String]

    Permalink

    Snowflake time output format

  26. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  27. def isSslON: Boolean

    Permalink
  28. def isTimezoneSnowflake: Boolean

    Permalink
  29. def isTimezoneSnowflakeDefault: Boolean

    Permalink
  30. def isTimezoneSpark: Boolean

    Permalink
  31. def keepOriginalColumnNameCase: Boolean

    Permalink
  32. def maxRetryCount: Int

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

    Permalink
    Definition Classes
    AnyRef
  34. def nonProxyHosts: Option[String]

    Permalink
  35. final def notify(): Unit

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

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

    Permalink

    Number of threads used for PUT/GET.

  38. val parameters: Map[String, String]

    Permalink
  39. 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.

  40. 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.

  41. def privateKey: Option[PrivateKey]

    Permalink

    Generate private key form pem key value

    Generate private key form pem key value

    returns

    private key object

  42. def proxyHost: Option[String]

    Permalink
  43. lazy val proxyInfo: Option[ProxyInfo]

    Permalink
  44. def proxyPassword: Option[String]

    Permalink
  45. def proxyPort: Option[String]

    Permalink
  46. def proxyUser: Option[String]

    Permalink
  47. def purge(): Boolean

    Permalink

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

  48. def query: Option[String]

    Permalink

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

  49. def quoteJsonFieldName: Boolean

    Permalink
  50. 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.

  51. lazy val rootTempDirStorageType: FSType

    Permalink
  52. def s3maxfilesize: String

    Permalink

    Max file size used to move data out from Snowflake

  53. def setColumnMap(fromSchema: Option[StructType], toSchema: Option[StructType]): Unit

    Permalink

    set column map

  54. def sfAccount: Option[String]

    Permalink

    Snowflake account - optional

  55. def sfAuthenticator: Option[String]

    Permalink

    Mapping OAuth and authenticator values

  56. def sfCompress: Boolean

    Permalink

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

  57. def sfDatabase: String

    Permalink

    Snowflake database name

  58. 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

  59. def sfFullURL: String

    Permalink

    URL pointing to the snowflake database including protocol.

    URL pointing to the snowflake database including protocol. for example, https://host:port

  60. def sfPassword: String

    Permalink

    Snowflake password

  61. def sfRole: Option[String]

    Permalink

    Snowflake role - optional

  62. def sfSSL: String

    Permalink

    Snowflake SSL on/off - "on" by default

  63. def sfSchema: String

    Permalink

    Snowflake schema

  64. def sfTimezone: Option[String]

    Permalink

    Snowflake timezone- optional

  65. def sfToken: Option[String]

    Permalink
  66. def sfURL: String

    Permalink

    URL pointing to the snowflake database, simply host:port

  67. def sfUser: String

    Permalink

    Snowflake user

  68. def sfWarehouse: Option[String]

    Permalink

    Snowflake warehouse

  69. def skipWriteWhenWritingEmptyDataFrame: Boolean

    Permalink
  70. def stagingTableNameRemoveQuotesOnly: Boolean

    Permalink
  71. def storagePath: Option[String]

    Permalink
  72. def streamingStage: Option[String]

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

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

    Permalink

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

  75. 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.

  76. 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.

  77. def toString(): String

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

    Permalink

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

  79. def truncateTable: Boolean

    Permalink

    Truncate table when overwriting.

    Truncate table when overwriting. Keep the table schema

  80. def uploadChunkSize: Int

    Permalink
  81. def useAwsMultiplePartsUpload: Boolean

    Permalink
  82. def useCopyUnload: Boolean

    Permalink
  83. def useExponentialBackoff: Boolean

    Permalink
  84. def useProxy: Boolean

    Permalink

    Proxy related parameters.

  85. 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.

  86. lazy val usingExternalStage: Boolean

    Permalink
  87. final def wait(): Unit

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  89. 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